Incorrect allignment while generating CSV file using DS job.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Tue Mar 26, 2013 12:02 pm
- Location: INDIA
Incorrect allignment while generating CSV file using DS job.
Hi all,
we are getting incorrect allignment for the few rows in csv file when generating using sequential file.
Format settings are delimeter as comma, quotes as double.
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
the above two columns are comming in single column instead of two columns.
we are getting incorrect allignment for the few rows in csv file when generating using sequential file.
Format settings are delimeter as comma, quotes as double.
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
77° - 9° 10",R0403"
the above two columns are comming in single column instead of two columns.
-
- Participant
- Posts: 62
- Joined: Thu Feb 08, 2007 6:01 am
- Location: Pune
It appears that there are special characters in the data that is being written to the target sequential file. Can you try removing the columns ( the ones that have special characters "°") and re-run the job and verify if the issue still persists. If the issue disappears, then you might have to somehow take care of the special characters and reintroduce the dropped columns in the target sequential file.
Note - I have assumed that your target is a sequential file stage.
Note - I have assumed that your target is a sequential file stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 37
- Joined: Tue Mar 26, 2013 12:02 pm
- Location: INDIA
Actualy 77° - 9° 10 should come in seperate column and R0403 should come in another column.ray.wurlod wrote:What should you be getting, and what format settings are you using? ...
Am using sequential file format settings for varchar columns using quote as double and delimeter as comma.
is there any way to change the settingsin sequential file to fix this issue.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Your file is probably not in a correct format.
According to your definition given in sequential file (Delimiter=Comma and Quote=Double) your result should go to same column.
Your correct format is :-
Remove quote=double and see what is your result.
According to your definition given in sequential file (Delimiter=Comma and Quote=Double) your result should go to same column.
Your correct format is :-
Code: Select all
"77° - 9° 10","R0403"
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore