March 17, 2009 at 7:25 am
Hi, i have a problem in getting the data from text file. The format of the doc file is not good.
I used regex to get the keyboard types and ignored the rest.
Now the problem is i have n number of fields with key value pair.
I have to import each field and a value into access mdb, since its not a fixed width, the only way i can get them is thr regex.
Ex: Agent Address(field) 00255 S(somecode) 28080WestTaylor St(value) City\State\Zip00255 S kokomo indiana Name 00456 ! ! S Some Titleco
Now i have build a regex for the field City\state\zip so as to begin from City\state\zip and select upto the field Name(ignoring name field)
How to exclude the entire word name from the pattern? since[^Name] works only for characters present in the words but not the entire word?
July 31, 2009 at 3:05 am
All in all, quite a civilised lack of agreement there - I even found the explaination interesting 🙂
My opinion = having regex, bcp, bulk insert, transact..and a copy of excel rocks every data situation you could possibly think of.
Thanks for the thread.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply