How do I convert CSV file from Unix to Windows format?

(0) Share

Report

Posted on by Giuseppe Caradonna

1,421

Hi all,

I need to convert a CSV file, created in UNIX format, in a Windows format file in order to run, from code, the parsing of this CSV using the CommaTextIo class. The format of Windows and UNIX text files differs slightly. In Windows, lines end with both the line feed and carriage return ASCII characters, but UNIX uses only a line feed. As a consequence, some Windows applications will not show the line breaks in UNIX-format files.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Martin Dráb 240,059 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Wouldn't it be enough if you set '\n' to inRecordDelimiter() (instead of '\r\n')?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

You can use .NET classes like TextReader. It can handle every format of lines.

Was this reply helpful? Yes No
Douglas Noel 3,907 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Giuseppe,

please keep in mind, that the "Record Delimiter" often isn't the only problem you should circumvent. The character set is important too.

regards

Douglas

Was this reply helpful? Yes No
Giuseppe Caradonna 1,421 on at

Like
a
(0)

Report
Copy link

Link copied!

@Martin, you're right. Is enough to specify the record delimiter (I had left the default).

@Douglas, what do you mean with "character set"?

Was this reply helpful? Yes No
Douglas Noel 3,907 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Is it a fixes length character set (16bit,8bit) Unicode, or Ascii, or UNIX codepage ...., or is it a variable length charactrer like utf-8

Maybe you have to do some conversions (or let the "WhateverIO class help you by specifying the character set)

regards

Douglas

Was this reply helpful? Yes No
Giuseppe Caradonna 1,421 on at

Like
a
(0)

Report
Copy link

Link copied!

At this moment I don't have these informations. The only information that I have are the file format (does not change), the field delimiter is the semilon and that does not contain special characters.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

You probably need to investigate the code page of the UNIX file in order to have correct reading of the file:

https://msdn.microsoft.com/en-us/library/aa881745.aspx

Was this reply helpful? Yes No