Posted: Wed Aug 22, 2007 3:36 pm
If you always have all 3 elements, just add a tr command to the sequential stage to filter out all <lf> characters, then define your source file as having no line terminators. If the "<" character doesn't show up in the data I would use that as the column delimiter, declare 4 varchar columns (the first is always empty) and remove the header text from each string.