Using Textpad to view CSV files

[Tim Poll]

Anyone had any luck doing this?

[Andreas]

What is your problem with that?
CSV = comma separated values
normally just text, should be no problem to open.

[Andreas]

Please keep discussions here in forum - more people will be able to help and more people will be able to profit from the discussion.

Tim wrote a mail to me:
<i>I would like to view them in a column format or converted to some sort of
tabbed format for easy legibility.
</i>

I think you will have to replace the commata (or semicolons or whatever is used to mark columns) by tab characters
Replace
,
by
\t
and make sure Regular Expression is checked.

You can then use View->Document Properties->Tabulation (or, if you created a document class for your csv-files, in Configure->Preferences->Document Classes->Your CSV Document class->Tabulation) to set tab stops to the appropriate columns which depend on the content of the file.

Andreas

[Roy Beatty]

To turn the tabs to spaces -- turning a CSV into a fixed-width column file:<br>
1) Create a new document<br>
2) View > Document Properties (Alt+Enter) > Tabulation<br>
3) Set default tab spacing to 20 (or a value wider than your widest data column)<br>
4) Set Convert new tabs to space to Yes (checked)<br>
5) Hit Apply then OK<br>
6) Copy the entire CSV to the clipboard<br>
7) Paste into the new document<br>

Hope this helps,

Roy

[ron]

I am trying to set-up a contact list with a group of phone numbers. I have a list of approx. 10,000 numbers without area codes in an Excel spreadsheet. How can I use Textpad to place a three digit area codes in front of each of these numbers?
Thank you,
Ron