l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Jun 05 09:28

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Changing data with awk
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Changing data with awk

> Yes, "\n" terminates a record.  But Richard (the original poster) said
> that the field has embedded "carriage return" characters, which is "\r".
> Since "\r" is not "\n", the codes do work... at least under *NIX.
> Yes, pressing the "Enter" key produces carriage return code on a standard
> keyboard (ASCII 13 "\r"), but *NIX translates it to the linefeed code
> (ASCII 10 "\n"), whereas DOS/Windows translates it to carriage return
> followed by linefeed "\r\n", and the older MacOS (before 10) doesn't
> translate it at all.  And by convention "\n" under C (along with various
> other languages) represents the default line terminator for that platform
> ("\n" for *NIX, "\r\n" for DOS/Windows, "\r"  under older MacOS.)  But
> unlike DOS/Windows, UNIX Lets you turn off the translation using termios.
> But now we're off topic... -_-v
> -Mark

Thanks Mark, I wasn't aware of those subtleties.

But, I'm betting Richard has embedded ASCII 10s in his file, and that
is why SQLLoader (Oracle's mass data loading tool, which uses ASCII 10s
as it's record separator) is giving him problems.

Richard, wha'chu'got in your file?

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!