Output column 12/13/2012,20180205 coming like this
Moderators: chulett, rschirm, roy
Output column 12/13/2012,20180205 coming like this
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
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?
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:
Code: Select all
xxx,xxx,12/13/2012,20180205,xxx
Code: Select all
xxx,xxx,"12/13/2012,20180205",xxx
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: