DSXchange

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.

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.

What should you be getting, and what format settings are you using?

ray.wurlod wrote:What should you be getting, and what format settings are you using? ...

Actualy 77° - 9° 10 should come in seperate column and R0403 should come in another column.
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.

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.

Or read it as a single field, strip out the double quotes and then let a Column Export stage create the two fields.

Each field is missing its opening quote. Have a severe talk with the data provider.

As Ray suggested first step is to talk to the data provider if that is possible
OR
Read as a single column ,pass that to a stage variable, strip out the " from the stage variable and use field function on the stage variable in the derivation for columns.