You’re offline. This is a read only version of the page.
6,071
Dear Experts,
What is the best delimited (csv, tab, ...) and fixed width text editor tool? Tool should be:
1. Easily view and update huge data by columns.
2. Unicode compatible.
3. Good handling text starts with char 0.
4. Not change text contains char ", date, datetime.
For example, I would like to make Description 2 same as Description of an Item.
Input text:
"*No.","*Description","*Description 2","*Unit Price","*Last Date Modified"
"0101","Bicycle 80" Chiều dài","","12,345.67","2014-12-06"
Expected save as:
"*No.","*Description","*Description 2","*Unit Price","*Last Date Modified"
"0101","Bicycle 80" Chiều dài","Bicycle 80" Chiều dài","12,345.67","2014-12-06"
Thanks for your help!
*This post is locked for comments
Dear All,
I just uploaded new video on YouTube (from 5:15 to 7:07) where you can see how to update delimited text via Libre Office Calc. Thanks and best regards!
Same result for input:
*No.,*Description,*Description 2,*Unit Price,*Last Date Modified
0101,Bicycle 80" Chiều dài,,"12,345.67",2014-12-06
We must use " for some cases:
- Item description such as 40" Monitor (" as inch).
- Text qualifier for number with thousand separator such as "12,345.67".
Thanks Jens and Jonathan!
- Libre Office Calc: satisfies 95% of the requirement for csv text only. 5% remainining can be done by C/AL. Expected and Libre Office Calc outputs:
"0101","Bicycle 80" Chiều dài","Bicycle 80" Chiều dài","12,345.67","2014-12-06"
"0101","Bicycle 80"" Chiều dài","Bicycle 80"" Chiều dài","12,345.67","2014-12-06"
- Microsoft Excel: I like end users use it. I've tried many options of MS Excel but fail with Unicode. Have I missed something?
- Rons CSV Editor and CSVed: not handle text qualifier and comma well. They have problem with value has thousand separator such as "12,345.67".
- UltraEdit and Notepad++: suitable for coding, cannot use for viewing and updating huge data.
Hi 4BzSoftware,
when in doubt I use UltraEdit. Notepad++ is also pretty useful.
with best regards
Jens
These tools have view problem:
Currently:
- Excel has nice view, but problem (with my requirements) when edit and save data (csv, unicode text).
- Notepad has no columns view, but edit and save data are fine.
Any tools else?
Thanks Jonathan!
I will take a look at these tools.
hi 4bzsoftware,
try it with
rons csv editor (excel like view): rons-editor-ultimate-csv-editor.en.softonic.com
or csved (excel like view, unicode): http://csved.sjfrancke.nl/
or ultraedit: www.ultraedit.com/.../csv_files.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (