Page 1 of 1
Output column 12/13/2012,20180205 coming like this
Posted: Tue Mar 06, 2018 1:50 pm
by vsvvreddy
Please help em to fix the output value. We are expecting to see the only one value. wrong data is coming in source file . please help me to clena up the data nd fix the output value
Posted: Tue Mar 06, 2018 2:53 pm
by chulett
Trying to follow along here.
If you have a csv (comma separated values) file and one of the fields has a comma
inside of it as data, you'll need to make sure that field is enclosed in quotes. If your file looks like this, then (ignoring the "xxx" bits) it will be read as two fields:
If it looks like this, then it's just one field:
So, is that what is going on? There are no quotes so it is parsed as two separate fields?
Posted: Tue Mar 13, 2018 10:11 pm
by ray.wurlod
And, if they ARE being parsed as two separate fields, then it should be a simple Transformer stage expression to concatenate them with a comma in between.