database, grouping by city

I have a | piped delimited text file that I created using csvedit from
ezscripting. From the documentation I can't find a way to group by
city. Does anyone know of any programs that can read a | piped text
file and display my output. i.e. below is what I need

San Jose
80 First Street 25,321 sq.ft. $1.15
191 Market Street 50,000 sq.ft. $1.20

Milpitas
45 Second Street 33,000 sq.ft. $1.25

etc.


Thanks,
Chris
Chris [ Mo, 31 Dezember 2007 08:52 ] [ ID #1896508 ]

Re: database, grouping by city

Does not sound like a FrontPage problem, but Access and Excel will
handle pipe delimited text files.

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"Chris" <chris95008 [at] yahoo.com> wrote in message
news:6750be39-1829-4f4d-8fd7-4603d7b73759 [at] t1g2000pra.googleg roups.com:

> I have a | piped delimited text file that I created using csvedit from
> ezscripting. From the documentation I can't find a way to group by
> city. Does anyone know of any programs that can read a | piped text
> file and display my output. i.e. below is what I need
>
> San Jose
> 80 First Street 25,321 sq.ft. $1.15
> 191 Market Street 50,000 sq.ft. $1.20
>
> Milpitas
> 45 Second Street 33,000 sq.ft. $1.25
>
> etc.
>
>
> Thanks,
> Chris
Ronx [ Mo, 31 Dezember 2007 11:40 ] [ ID #1896518 ]
Microsoft » microsoft.public.frontpage.client » database, grouping by city

Vorheriges Thema: Change font of script
Nächstes Thema: Buttons in Front Page 2000