Microsoft Dynamics NAV (Archived)

What is the best delimited (csv, tab, ...) and fixed width text editor tool?

(0) Share

Report

Posted on by 4BzSoftware

6,073

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

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Thanks Jonathan!

I will take a look at these tools.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

did you set the comma , as seperator?

one problem is, that you enclose the values with quotes and you use also quotes in the values. better remove the leading and ending quotes.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

you could also try libre office calc: good results for your sample

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Hi 4BzSoftware,

when in doubt I use UltraEdit. Notepad++ is also pretty useful.

with best regards

Jens

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
keoma 32,729 on at

Like (0)

Report

hi, did you try to remove the enclosing quotes at the values (") ?

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

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".

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

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!

Was this reply helpful? Yes No