Topic: Editing CSV Files (1 of 6), Read 124 times
Conf: Basic editing, Block operations
From: Jon Pilling
Date: Wednesday, June 06, 2001 07:30 AM 

What I need to do is (I am sure) very simple.  I have a CSV file that has the usual format with the first line being the headers, and subsequent lines being the data.

      

      Unfortunately the download is poor and if the field did not exit then it was omitted, so I need a quick way of displaying the data in a column form so that the missing fields can be visually identified.

      

      ie from

      

      NAME,ADDRESS1,ADDRESS2,ADDRESS3,CITY,STATE,ZIP

      Jon Pilling,Saxel Close,Aston,Bampton,Oxon,OX182EB

      

      to

      

      NAME		ADDRESS1	ADDRESS2	ADDRESS3	CITY	STATE	ZIP

      Jon Pilling	Saxel Close	Aston		Bampton	Oxford	Oxon	OX182EB

      

      

      Any ideas.

      

      

      Many thanks

 

Topic: Editing CSV Files (2 of 6), Read 126 times
Conf: Basic editing, Block operations
From: Christian Ziemski
Date: Wednesday, June 06, 2001 09:42 AM

First you can replace the comma's with TAB's via menu or via command line:
Replace(",","|009", BEGIN+ALL+NOERR)

Then it's nearly formatted as you wish.
But most likely it's not well looking now since the TAB configuration isn't fitting.

Maybe my old TABUMAT.VDM
ftp://ftp.vedit.com/share/tabumat.vdm
can help you here.

It configures VEDIT's TAB's according to the current cursor line.
Just place the cursor in the header line and call TABUMAT.VDM.

If it's still looking bad you can edit the header line (delete the TABs and format the line with spaces as you need (the width of every field)), place the cursor in that line and call TABUMAT.VDM again.

HTH

Christian

 

Topic: Editing CSV Files (3 of 6), Read 126 times
Conf: Basic editing, Block operations
From: Christian Ziemski
Date: Tuesday, June 12, 2001 03:24 AM

While testing Jon's Outlook export I found some not handled limitations in my macro TABUMAT.

Now it's updated:
ftp://ftp.vedit.com/share/tabumat.vdm


It configures VEDIT's TAB's according to the current cursor line looking for words or for "double-quoted items".

Doing that it respects VEDIT's limits of 33 TAB's in the columns 1-255.

Christian

 

Topic: Editing CSV Files (4 of 6), Read 128 times, 2 File Attachments
Conf: Basic editing, Block operations
From: Ian Binnie
Date: Thursday, June 14, 2001 01:41 AM

I spend a lot of time editing tabbed files.

Tabumat does a good first pass of putting these into columns, but sometimes the columns are too narrow resulting in a ragged display.

TabRight.vdm nudges the tabs to make columns wider.
I assign it to Shft-Cursor-Left (OK if you don't use Shift for selection).

TabLeft.vdm does the opposite.

  TABLEFT.VDM (1KB)
  TABRIGHT.VDM (1KB)

 

Topic: Re: Editing CSV Files (5 of 6), Read 134 times
Conf: Basic editing, Block operations
From: Christian Ziemski
Date: Thursday, June 14, 2001 11:02 AM

On Thu, 14 Jun 2001 01:41:23 -0400, Ian Binnie wrote:

>Tabumat does a good first pass of putting these into columns, but =sometimes the columns are too narrow resulting in a ragged display.

Yes. The original idea of Tabumat was to manually add a control line
consisting of some single characters and then adjust the TAB's to it.

Jon's real header line from Outlook with long words in it can confuse
Tabumat a bit (optically).


>[TabRight.vdm and TabLeft.vdm]

Good idea!

All the TAB handling seems to be worth to be consolidated.
Some time...


Christian

 

Topic: Editing CSV Files (6 of 6), Read 128 times, 1 File Attachment
Conf: Basic editing, Block operations
From: Ian Binnie
Date: Sunday, October 21, 2001 08:09 PM

TabRight.vdm now creates new tabs to the right as well as nudging the tabs
to make columns wider.
I assign it to
Shft-Cursor-Right (OK if you
don't use Shift for
selection).

  TABRIGHT(1).VDM (1KB)