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)

Verified answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (2)

Report

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 (0)

Report

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

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

Like (0)

Report

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 (0)

Report

@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,905 on at

Like (1)

Report

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 (0)

Report

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 (0)

Report

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