Pipe delimiter not found as field delimiter

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Details on how you configured that in the stage, please.
-craig

"You can never have too many knives" -- Logan Nine Fingers
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

The Sequential File Stage looks for an exact match of the particular numeric value of the delimiter character.

Some character encodings have multiple numeric values for the same symbols. One notorious example is Microsoft Word, which will convert " (quote) characters to something else that looks like a ", but does not compile when moved back into Visual Studio. Several other Windows / web based copy/paste programs have this sort of behavior.

What you need to do is look at the text file in a hex editor to get the delimiter's true value. Then put THAT hex value into the stage as the delimiter.

Or, you could just have an error in the stage setup, as noted already... :)
Post Reply