Box Characters while reading CSV files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
Box Characters while reading CSV files
Hi All,
Iam moving a CSV file from Windows to UNIX, then reading the CSV file in one of my job and when trying to view data in dataset i'm able to see a box character appended to the value of a column which has a datatype of VARCHAR(8).
The box character is not appended for the values if the string is of length 8.
Eg: For the value "abcdefgh" there is no box character appended, whereas if the value is "abcdef" there is a box character appended.
Is there a way to handle these box characters in Datastage.
Iam moving a CSV file from Windows to UNIX, then reading the CSV file in one of my job and when trying to view data in dataset i'm able to see a box character appended to the value of a column which has a datatype of VARCHAR(8).
The box character is not appended for the values if the string is of length 8.
Eg: For the value "abcdefgh" there is no box character appended, whereas if the value is "abcdef" there is a box character appended.
Is there a way to handle these box characters in Datastage.
Rohith
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
when you transfer file from Windows to Unix or in other way , "Ctrl M" Character will be appended to end of each line. That has to be removed fom the file, otherwise Datastage will not able to read the file.rohithmuthyala wrote:Yes..... this column is the last one in my file.
Record level final delimiter is end.
thanks,
Sri
Thanks,
Sri C
Sri C
-
- Participant
- Posts: 17
- Joined: Wed Feb 06, 2008 5:09 am
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India