One Star

[resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Hi,
tExtractDelimitedFields component is giving different output for Pipe ('|') delimiter. Its working fine only for comma(,) delimiter.
Please see the attached screen shots.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
One Star

Re: [resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Hi,
I suppose you should escape the "|" as "\\|" because it's a special character. This fixes it all.
Regards,
Arno
4 REPLIES
One Star

Re: [resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Which version? What's the bug number?
Highlighted
One Star

Re: [resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Hi,
I suppose you should escape the "|" as "\\|" because it's a special character. This fixes it all.
Regards,
Arno
One Star

Re: [resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Thanks Arno, it worked.... Smiley Happy
One Star

Re: [resolved] tExtractDelimitedFields is not recognizing the Pipe as delimiter

Great!