topic Re: [resolved] tNormalize incorrectly splitting all characters in Talend Studio

[resolved] tNormalize incorrectly splitting all characters

Anonymous — Sat, 16 Nov 2024 12:09:20 GMT

Hi
I have a tFileInputDelimited component reading a .csv file.
This goes to a tNormalize.
In the tNormalize I use "|" as the item separator.
When I run the job column is separates all charactes
Jim|Smith will be delimited as
J
i
m
S
m
i
t
h
with an empty field where the | is.
I have tried reading the file in as ISO-8859-15 and UTF-8.
Please let me know how to resolve this.

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Wed, 07 Nov 2012 11:51:16 GMT

Hi
try "\\|", it works now.

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Wed, 07 Nov 2012 12:26:12 GMT

Hi,
That worked.
Thanks

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Thu, 17 Jan 2013 16:11:08 GMT

Hi,
I came a problem today, I have a CSV file having data like below:
Field1; Field2; Field3; Field4; Field5; Field6
Field7; Field8; Field9; Field10; Field11; Field12 | Field13; Field14; Field15
.
.
.
Field1; Field2; Field3; Field4; Field5; Field6 | Field4; Field5; Field6 | Field4; Field5; Field6 |........|N
Please let me know how Talend can handle such a problem. So i can map data like:
Field1; Field2; Field3; Field4; Field5; Field6
Field7; Field8; Field9; Field10; Field11; Field12
Field7; Field8; Field9; Field13; Field14; Field15
Target Schema is :
Field1; Field2; Field3; Field4; Field5; Field6
Thanks in advance
Asif

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Thu, 17 Jan 2013 17:43:59 GMT

I saw that, too, also using the "|" delimiter. It worked properly with the default "," but I have commas in my fields. I tried using "~" and it worked properly.
What's the problem with the "|"??

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Thu, 17 Jan 2013 18:33:52 GMT

It does not recognize "|" and do not normalize fields accordingly.

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Thu, 16 Mar 2017 12:12:46 GMT

With "\\|" works perfect!
Thanks

Re: [resolved] tNormalize incorrectly splitting all characters

krrohit1256 — Sun, 13 Feb 2022 08:34:29 GMT

When we hardcode item seperator as "\\|" in tnormalize, it works

But it does not work when we pass the same from context variable.

Any solution how can we pass it from context variable ?

Re: [resolved] tNormalize incorrectly splitting all characters

Anonymous — Sun, 13 Feb 2022 14:28:25 GMT

@KUMAR ROHIT , I made a testing on version 8.0.1 and it works also with context variable, set the default value of context variavble as \\|