Re: data conversion strangeness

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Craig White
Date:  
To: Main PLUG discussion list
Subject: Re: data conversion strangeness
vi identified it and allowed me to get rid of it...emacs didn't display
it.

Thanks

Craig
On Thu, 2006-06-15 at 16:14 -0700, Kenneth wrote:
> Can't tell you why the extra characters are there, maybe something in the way
> you exported from OO?
>
> Some editors will show you the special characters and let you delete them
> directly. If that doesn't work for you I can think of a couple of things.
>
> Use "tr" to change those characters to something like spaces, then fix it
> manually.
>
> Use "dd" to write out everything but the first three characters to a new
> file.
>
> "sed" might work to delete them, but I'm not a sed expert so I can't be sure.
>
>
>
> --- Craig White <> wrote:
>
> > I have a text file which I exported in tab delimited format from
> > Filemaker Pro on Windows, cleaned up in openoffice.org and want to
> > import into postgres.
> >
> > the first few characters in the file are killing me and I haven't a clue
> > on how to rid the file of them...
> >
> > 0000000 357 273 277   1  \t   B   l   o   o   d       B   o   r   n   e

> >
> > it's the 357 273 277 that don't belong...the data should start with "1"
> >
> > where did they come from and how do I get rid of them?
> >
> > Craig
> >
> > ---------------------------------------------------
> > PLUG-discuss mailing list -
> > To subscribe, unsubscribe, or to change you mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss


---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss