Reading Delimited Input Files with Different Start and End Delimiters

[ks01]

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:

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!