Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replacing Carriage returns without loosing EOL
Top Forums Shell Programming and Scripting Replacing Carriage returns without loosing EOL Post 302173542 by Majiktom on Friday 7th of March 2008 04:24:50 AM
Old 03-07-2008
Power Replacing Carriage returns without loosing EOL
Hello, I have read a few threads on this subject and tried a few things out, but still come up short.

There was one good example, then the last reply was something to the effect of 'Use Sed' & 'Read a book'...

Well I read a bunch of online tutorials on sed, awk, tr, but still can't get the right results.

input file>

1234|hello there buddy|8beers|2008-01-01
1234|this is a nice party, don't you think?|2champaigns|2008-01-01
1234|there are two things:
thing 1 & thing2|36shots|2008-01-01

desired output>
1234|hello there buddy|8beers|2008-01-01
1234|this is a nice party, don't you think?|2champaigns|2008-01-01
1234|there are two things: thing1 & thing2|36shots|2008-01-01

The closest I could get was with this command->

nawk '{ if ( $0 ~ /1234/ && NR > 1 ) { printf "\n"; } printf $0; } END { printf "\n"; }' party.txt > dump.txt

But after line 460664 I received an error:
awk: There are not enough parameters in printf statement ...

The only thing that looks different about that line is there is an ampersand '&' in one of the fields.

I tailed the rest of the file into the the nawk and it puked after another 1600 lines. I tried a couple more times and it still keeps running out of steam before the millionth row.

The other way I tried was ghetto style:
tr -d '\n' to remove all the carriage returns, then
sed s/2008-01-01/2008-01-01\n/g <party.txt> dump.txt

but sed pukes with a sed: Memory allocation failed after about a minute.

Ideally, I need a one liner...
Any suggestions?

Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

spaces and carriage returns in 'here documents'

As the title suggests, i am having some trouble figuring out how to pass spaces and carriage returns to a 'here document' ie #!/bin/bash /usr/local/install_script.sh <<SCRIPT yes no <pass carriage retun here> yes no <pass a space and then a carriage return here> exit SCRIPT any... (0 Replies)
Discussion started by: hcclnoodles
0 Replies

2. Shell Programming and Scripting

Remove Carriage returns between strings in a field

Is there any way to remove carriage retuns between the records? We have input records separated by TABS and have carriage returns as below: 123 456 789 ABC "1952.00" 678 "abcdef ghik lmno" Above we... (10 Replies)
Discussion started by: acheepi
10 Replies

3. Shell Programming and Scripting

Removing carriage returns with sed

How do we delete all carriage returns after a particular string using sed inside a K Shell? e.g. I have a text file named file1 below: $ more file1 Group#=1 User=A Role=a1 Group#=2 User=B Role=a1 Role=b1 Group#=3 User=C Role=b1 I want the carriage returns to be delete on the... (12 Replies)
Discussion started by: stevefox
12 Replies

4. Shell Programming and Scripting

removing thousand of carriage returns using sed

I need to replace thousands of carriage returns/line breaks in a large xml file and with spaces. I hope to do so with a script, called, for example, "removeCRs." I would invoke this at the command line as ml5003$ sed -f /Users/ml5003/removeCRs oldFile > newFile The script, I presume, would... (4 Replies)
Discussion started by: ml5003
4 Replies

5. Shell Programming and Scripting

removing carriage returns in text file

Hi I have a text file that looks like this: A B C D E F G H I I want it to be reformatted to A;B;C; D;E;F; G;H;I; (4 Replies)
Discussion started by: coolnfunky
4 Replies

6. Shell Programming and Scripting

Removal of carriage returns from a comma delimited file

Hi, I have a file which is having some carriage return in one of the field for which single line is coming in multiple lines. I want to combine all those multiple lines of that field into one line. Eg: Input: Id, Name, Location, Comments, Dept 2, John, US, I am from US. I... (5 Replies)
Discussion started by: mahish20
5 Replies

7. Shell Programming and Scripting

sqlplus returns leading carriage return into a variable

I am trying to generate some scripts to help manage an Oracle database. When I check the value returned from Oracle it has a leading carriage return in the variable. Is there a way to prevent this? Is there a way to easily strip out the carriage return. See code and output below. ... (7 Replies)
Discussion started by: Panzer993
7 Replies

8. UNIX for Advanced & Expert Users

Add a Couple of Carriage returns to text file

I have a directory of over a hundred text files that I'm getting ready to merge with the CAT command. However there is only one space after each file; this makes the output look crowded. I would like to add two, possibly even four carriage returns at the end of each text file to make the final... (2 Replies)
Discussion started by: tg3793
2 Replies

9. Shell Programming and Scripting

TR not removing carriage returns

I have a CSV with carriage returns in place of newlines. I am trying to use tr to remove them, but it isn't working. Academic year,Term,Course name,Period,Last name,Nickname 2012-2013,First Semester,English 12,4th Period,Arnold,Adam 2012-2013,First Semester,English 12,4th Period,Adams,Jim... (1 Reply)
Discussion started by: nextyoyoma
1 Replies

10. Shell Programming and Scripting

Remove carriage returns from awk output

I'm on Linux version 2.6.32-696.3.1.el6.x86_64, using the Ksh shell. I'm working with the input file: John Daggett, 341 King Road, Plymouth MA Alice Ford, 22 East Broadway, Richmond VA Orville Thomas, 11345 Oak Bridge Road, Tulsa OK Terry Kalkas, 402 Lans Road, Beaver Falls PA Eric Adams,... (2 Replies)
Discussion started by: prooney
2 Replies

LEARN ABOUT MOJAVE

datetime::locale::tn_za

DateTime::Locale::tn_ZA(3)				User Contributed Perl Documentation				DateTime::Locale::tn_ZA(3)

NAME

       DateTime::Locale::tn_ZA

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'tn_ZA' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Tswana South Africa.

DATA

       This locale inherits from the DateTime::Locale::tn locale.

       It contains the following data.

   Days
       Wide (format)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (format)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (stand-alone)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (format)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (stand-alone)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BC
	 AD

       Abbreviated

	 BC
	 AD

       Narrow

	 BC
	 AD

   Date Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = -10 Lwetse 15

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

       Short

	  2008-02-05T18:30:30 = 08/02/05
	  1995-12-22T09:05:02 = 95/12/22
	 -0010-09-15T04:44:23 = -10/09/15

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05 18:30:30 UTC
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5 18:30:30 UTC
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = -10 Lwetse 15 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

       Short

	  2008-02-05T18:30:30 = 08/02/05 18:30
	  1995-12-22T09:05:02 = 95/12/22 09:05
	 -0010-09-15T04:44:23 = -10/09/15 04:44

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Bed
	  1995-12-22T09:05:02 = 22 Tla
	 -0010-09-15T04:44:23 = 15 Mat

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Bed, 2-5
	  1995-12-22T09:05:02 = Tla, 12-22
	 -0010-09-15T04:44:23 = Mat, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = Tlh
	  1995-12-22T09:05:02 = Sed
	 -0010-09-15T04:44:23 = Lwe

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Tlh 5
	  1995-12-22T09:05:02 = Sed 22
	 -0010-09-15T04:44:23 = Lwe 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Bed Tlh 5
	  1995-12-22T09:05:02 = Tla Sed 22
	 -0010-09-15T04:44:23 = Mat Lwe 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = Tlhakole 5
	  1995-12-22T09:05:02 = Sedimonthole 22
	 -0010-09-15T04:44:23 = Lwetse 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Bed Tlhakole 5
	  1995-12-22T09:05:02 = Tla Sedimonthole 22
	 -0010-09-15T04:44:23 = Mat Lwetse 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Bed, 2008-2-5
	  1995-12-22T09:05:02 = Tla, 1995-12-22
	 -0010-09-15T04:44:23 = Mat, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Tlh
	  1995-12-22T09:05:02 = 1995 Sed
	 -0010-09-15T04:44:23 = -10 Lwe

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Bed, 2008 Tlh 5
	  1995-12-22T09:05:02 = Tla, 1995 Sed 22
	 -0010-09-15T04:44:23 = Mat, -10 Lwe 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Tlhakole
	  1995-12-22T09:05:02 = 1995 Sedimonthole
	 -0010-09-15T04:44:23 = -10 Lwetse

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       Mosopulogo

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						DateTime::Locale::tn_ZA(3)
All times are GMT -4. The time now is 01:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy