I have what appears to me to be a unique situation. I have a text file with raw data that is used for a report. The software uses segment identifiers to place data where it needs to be. I know what the identifiers are and what they mean in the report. I have been asked to put them in a format so that the data can be either sorted differently than what the report allows and to be able to link to other data to add city and state to store numbers in the report. The text file is delimited with an * but you have the segment id's on the line before the group of data and most of the data when looking at the line is formatted differently. Is there a way to import data using segments to isolate the data to different tables, i.e. items sold to one table, items on hand to another table and dollars sold to another table. I can manipulate the data once it is in the tables, I am just having trouble getting the data to the tables. This is small part of the text file. The entire report is 84 pages, there are almost 500 lines in the text file.
LIN, SK, VP,UP, ZA, QS, SDQ, EA, DO, QE are segment ID's and the ~ is end of line. The delimiter is the * .
Any help would be most great appreciated.