Обсуждение: Carrage Returns \ Line Breaks!
Hello all, I have a file that I am trying to import/copy into a table. The problem that I am having is that there are carriage returns through out the document. These carriage returns should be copied into the column it belongs to yet during the copy table from '/home/location/file.ext' using delimiters '|'; I get errors when it hits the carriage return. Can i get around this?
On Mon, 18 Dec 2000, Brian C. Doyle wrote: > I have a file that I am trying to import/copy into a table. The problem > that I am having is that there are carriage returns through out the > document. These carriage returns should be copied into the column it > belongs to yet during the > copy table from '/home/location/file.ext' using delimiters '|'; > > I get errors when it hits the carriage return. Can i get around this? You should convert the carriage returns into the literal text '\n'. Are they ^J or ^M? -- Brett http://www.chapelperilous.net/~bmccoy/ --------------------------------------------------------------------------- A soft answer turneth away wrath; but grievous words stir up anger. -- Proverbs 15:1
Okay now I am an Idoit. How do I tell what is used for the carriage return? I know how to make the replacement I just can not tell they characters used. At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote: >On Mon, 18 Dec 2000, Brian C. Doyle wrote: > > > I have a file that I am trying to import/copy into a table. The problem > > that I am having is that there are carriage returns through out the > > document. These carriage returns should be copied into the column it > > belongs to yet during the > > copy table from '/home/location/file.ext' using delimiters '|'; > > > > I get errors when it hits the carriage return. Can i get around this? > >You should convert the carriage returns into the literal text '\n'. Are >they ^J or ^M? > >-- Brett > http://www.chapelperilous.net/~bmccoy/ >--------------------------------------------------------------------------- >A soft answer turneth away wrath; but grievous words stir up anger. > -- Proverbs 15:1
On Mon, 18 Dec 2000, Brian C. Doyle wrote: > Okay now I am an Idoit. How do I tell what is used for the carriage > return? I know how to make the replacement I just can not tell they > characters used. Are you on Windows, Unix or Mac? -- Brett http://www.chapelperilous.net/~bmccoy/ --------------------------------------------------------------------------- Knock, knock! Who's there? Sam and Janet. Sam and Janet who? Sam and Janet Evening...