SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

CSV external file load into DI 3.4

Accepted Solution Solved
Reply
Contributor SYN
Contributor
Posts: 39
Accepted Solution

CSV external file load into DI 3.4


I am loading CSV external file into DI 3.4.

I am using delimiters Comma and TAB for my CSV file.

Here I am uploading file correct only one problem i am getting.

Last column I am getting the value  "" in all rows for that column.

Can you please help me to resolve this problem.

Thank you.


Accepted Solutions
Solution
‎06-19-2012 02:49 PM
Super User
Super User
Posts: 6,502

Re: CSV external file load into DI 3.4

And the problem is what exactly?

One issue that might be related is the difference in end-of-line characters between Windows and Unix files. On Windows end of line is normally CR and LF characters. On Unix it is just the LF character. So when Windows text files are moved as binary files to Unix the CR ends up being the last character of the line.  I have seen a number of people consistently add an extra delimiter to the end of their CSV files so the extra CR ends up in its own column rather than messing up the real data in the last column.

View solution in original post


All Replies
Solution
‎06-19-2012 02:49 PM
Super User
Super User
Posts: 6,502

Re: CSV external file load into DI 3.4

And the problem is what exactly?

One issue that might be related is the difference in end-of-line characters between Windows and Unix files. On Windows end of line is normally CR and LF characters. On Unix it is just the LF character. So when Windows text files are moved as binary files to Unix the CR ends up being the last character of the line.  I have seen a number of people consistently add an extra delimiter to the end of their CSV files so the extra CR ends up in its own column rather than messing up the real data in the last column.

Contributor SYN
Contributor
Posts: 39

Re: CSV external file load into DI 3.4

Thank you very much for your help.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 215 views
  • 0 likes
  • 2 in conversation