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?