Re: Format of files outputted from Innopac

[Carol Gyger <gyger@xxxxxxxxxx>]

Angela,

I almost always pick the defaults offered by FTS -

Field Delimiter  , (comma)
Text Qualifier   " (quote)
Repeated Field Delimiter  ; (semicolon)

When you import into Excel, make sure you choose the following settings -

Delimited
Delimiters - semicolon and comma
Text Qualifier - " (quote)

The text qualifier is really important because it basically tells Excel to
treat the semicolons and commas within the text fields as text, not
delimiters.

cg

Carol Gyger
Systems Administrator
Fort Collins Public Library
201 Peterson St.
Fort Collins CO  80524
(970)221-6716
gyger@xxxxxxxxxx

On Wed, 14 May 2003, Angela Burdiss wrote:

> I would agree with this.  If you output titles, you have a lot of cleanup
> to do in Excel if you use comma delimited.
> Angela
>
> At 11:20 AM 5/13/03 -0400, you wrote:
> >You should pick a delimiter which isn't in the data in the records. I
> >usually choose the vertical bar |  character.  -- Howard
> >
> >At 02:57 PM 5/13/2003 +0000, you wrote:
> >>Hi,
> >>I hope that more experienced users of the system can help us.  We want to
> >>take a file outputted from Innopac & take it into EXCEL or any MS product
> >>- What delimiter should we pick?
> >>Thanks for your help
> >>Ann
> >>--
> >>This message was distributed through the Innovative Users Group INNOPAC list
> >>Public replies:  INNOPAC@xxxxxxxxxx
> >>Update your subscription options:
> >>http://innopacusers.org/list/listinfo/innopac
> >
> >--
> >This message was distributed through the Innovative Users Group INNOPAC list
> >Public replies:  INNOPAC@xxxxxxxxxx
> >Update your subscription options:
> http://innopacusers.org/list/listinfo/innopac
> >
> ----------------------------------------------------------------
> Angela Burdiss, Automated Systems and Services Librarian
> Dawes Memorial Library, Marietta College, Marietta, OH 45750
> (740) 376-4537, burdissa@xxxxxxxxxx
> ----------------------------------------------------------------
>
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC@xxxxxxxxxx
> Update your subscription options: http://innopacusers.org/list/listinfo/innopac
>