Next week I will be receiving a peculiar file that will contain several fields that can be up to 32k wide. These fields can hold almost anything including special characters, hidden characters and most frightening, carriage returns of all formats.
Trouble is, I have to preserve the format of these input fields, so, no removing carriage returns! Yikes!
The guys providing the source have cooked up a field delimiter character combination to separate the fields, as follows: {~^|^~} Yikes again! (still trying to determine if that character combination is suggestive of anything?!?!)
They don't yet realize about the end of line indicator, so I'm trying to cook up something to suggest, but I have yet to get an idea
![Idea :idea:](./images/smilies/icon_idea.gif)
Any suggestions? Also what are the downstream implications? I have to create a flat file as input to the job that actually hits the DB (Teradata in this case), so how am I going to create a load file with these embedded carriage returns?
![Sad :(](./images/smilies/icon_sad.gif)
Thought I'd post this now so some ideas can perculate before my deadline.
Rob Wierdsma