3
CSV file editor options
source link: https://techteapot.com/posts/csv-file-editor-options/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
CSV file editor options
I need to create a CSV file using pipe (|) field separators and caret (~) field delimiters to feed some data into our e-commerce system. The format of the file is not under my control.
Excel is of no use whatsoever. Whilst I can use pipe field separators, I can’t use caret field delimiters. Excel only supports single or double quotes or no field delimiters at all.
What are the alternatives?
- Csved -- looks just the job except that it assumes fixed width fields;
- Windows notepad -- this would work OK, but would be pretty nasty to work with. All of the colums would be all over the place, so it would be difficult to ensure that all of the data is valid;
- Excel -- enter the data in the wrong format, and hope I can convert to the correct format later using something like Windows PowerShell.
About Jack Hughes
An experienced software engineer with 20+ years experience writing products for Microsoft Windows based operating systems as well as 17+ years experience hosting websites on Linux and Windows including e-commerce and CMS systems.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK