Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reading Delimited Input Files with Different Start and End Delimiters

Status
Not open for further replies.

ks01

MIS
Aug 11, 2002
110
0
0
US
Hi everyone.

I would like some advice on how to read in raw data where each record has multiple fields in which the delimiter used to start the string is different than the delimiter used to identify the end.

The backwards apostrophe (`) is used to indicate the beginning of the value and a tilde (~) indicates the end. Here are some examples:

Code:
02054-- `REFERENCE:~   `MXQ4570~    `DATE:~   `2014-02-65~

Basically, my field names and the field data are each enclosed by separate starting and ending delimiter.

Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top