data conversion strangeness

[Craig White]

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 <craigwhite at azapple.com> 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 - PLUG-discuss at lists.plug.phoenix.az.us
> > 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 - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss