Pipe delimiter not found as field delimiter
Moderators: chulett, rschirm, roy
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...
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...