However it is very easy to convert an Excel file to pipe delimited in Easy Data Transform: Which means “Smith, John” has become “Smith| John”, which is almost certainly not what you want. If you replace all the commas with pipes, you will get: "Name"|"Country" For example a name value in a CSV file might include a comma: "Name","Country" ![]() ![]() in a text editor) is not advisable, because you might covert a delimiter character inside a value. Trying to convert the delimiter of a CSV file using simple find and replace (e.g. ![]() However some programs expect a pipe (|) delimiter. Excel typically saves CSV files with using comma (,) or semi-colon ( ) as the delimiter.
0 Comments
Leave a Reply. |