Query ~ Seperate 1 field into 8 fields using Pipes "|"

[IceChris]

Information
8|REPORT BY THE COMMITTEE APPOINTED TO STUDY CLASSIFICATION, TRANSPORTATION, DISTRIBUTION STORAGE AND SALES OF PESTICIDES IN *******|***** *. *****|******** ** *** **********|****|||PA2|

Okay, so my office had this emergency data dump, we lost the library, the records were saved but to do so they had to be backed up as .t files :-s which means less formating then a txt file , anyway, my office is hopeful I can fix their problems, sorry bout the ***'s, I was told that I can not put that information up on the net for security/privacy purposes. Anyway, what I have to figure out to do is to take this 1 field and split it into 8 fields, these correspond with the | character. If you see 2 || or more together it means that field was empty. Anyway, I just need a way to break these into 8 seperate fields, any feed back would be great.

 

[KeithG]

So is it delimeted by a "|". have you tried to import the file as delimeted with a "|"? If that did not work you are probably going to have to open the file up as a TextStream object and create a function to retrieve the data and write it to a fiel.

 

[boblarson]

check out the SPLIT function. You can use it to read line by line and create a single row array based on the delimiter you choose (in this case the | ).