req viewer / editor x delimited files

[mduran]

Hi,

I have a lot of pipe delimited files to work with and I am looking for a simple (not full blown) viewer/ editor of files with content with delimitors (comma, pipes, semicolon...). Please advice. Thanks.

[majkinetor !]

You can convert it to nomrmal csv delimited file

Autohotkey script

Code: Select all

FileRead, text, MyPipeDelimitedFile.txt
Text := RegExReplace( text, "|", ";")
FileAppend, %text% MyCommaDelimitedFile.csv
Run, excell MyCommaDelimitedFile.csv

you can use %0% instead file name to allow later associations of pipe files with this script which will on dbl click run excell.

[mduran]

Thanks, but running Excel is exactly what I'm trying to avoid. There are many such pipe delimited files I want to edit and transforming the pipe into comma and sending it to Excel would be too much overkill for me.

[RID500]

Isn't "CSV-Viewer by Atlanoff" good for this issue?

Lister-plugin for TotalCommander

Use this plugin for display CSV-files
(Comma separated columns format)

As delimeter used characters ';' or ',' or '|' or tab
Also you can add your delimeters via registry.
Plugin can autodetect delimeter.

Recommended to use together with
Access Viewer Plugin (wñx_mdb).

[tbeu]

What about the CSV lister plugin? It is able to display pipe separated files but not to edit them.

[mduran]

Thanks, this is a good plugin, but no edit possible.
Any other out there ?

[RID500]

Hi,

.....I am looking for a simple viewer/ editor of files ...

What now?
Now you have got an viewer and this isn't good anymore now?
Please ask for what you really want in your initial posts ("i need an editor, not an viewer").
Thanks.

[mduran]

I'm sorry but I think I made this clear in my initial post

...I am looking for a simple (not full blown) viewer/ editor of files with content with delimitors...

[majkinetor !]

/join #TCMD Chat at irc.freenode.net - Today's newbies are tomorrow's experts.

ROFL.

Is this the place that Sir_Silva is visiting too ?

If, so, great, I will join today, I need something to relax me.