Splitting one record into two

  • Thread starter Marc_STL via AccessMonster.com
  • Start date
M

Marc_STL via AccessMonster.com

I have a large text file that I have imported into Access. However, because
of the sepators (, |, ") it does not format nicely. I have been able to
massage the data in Access but still have one record I am trying to work with.


The records come across as N/A : N/A

I would like to split this into two records The only seperator is the :

How can I write a query statment to split these two. If I must wrtie the
same query twice (once for the left side and once for the right side) that is
fine.

Thanks
 
L

Lord Kelvan

what do you mean split records you knwo a record is a row right. can
you try to explain it by showing the before and after of what you want

Regards
Kelvan
 
M

Marc_STL via AccessMonster.com

The field has the following:

N/A : N/A

I want to make this into two fields

N/A

N/A

Where the : will be the place the data is phase.
 
J

John Spencer

NewField1: Left([CurrentField],Instr(1,[CurrentField],":")-1)

NewField2: Mid([CurrentField],Instr(1,[CurrentField],":")+1)

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Top