03-07-2008
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
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
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
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
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
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
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
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
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
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
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
STRFMON(3) Linux Programmer's Manual STRFMON(3)
NAME
strfmon, strfmon_l - convert monetary value to a string
SYNOPSIS
#include <monetary.h>
ssize_t strfmon(char *s, size_t max, const char *format,
...);
ssize_t strfmon_l(char *s, size_t max, locale_t locale,
const char *" format , ...);
DESCRIPTION
The strfmon() function formats the specified monetary amount according to the current locale and format specification format and places the
result in the character array s of size max.
The strfmon_l() function performs the same task, but uses the locale specified by locale. The behavior of strfmon_l() is undefined if
locale is the special locale object LC_GLOBAL_LOCALE (see duplocale(3)) or is not a valid locale object handle.
Ordinary characters in format are copied to s without conversion. Conversion specifiers are introduced by a '%' character. Immediately
following it there can be zero or more of the following flags:
=f The single-byte character f is used as the numeric fill character (to be used with a left precision, see below). When not speci-
fied, the space character is used.
^ Do not use any grouping characters that might be defined for the current locale. By default, grouping is enabled.
( or + The ( flag indicates that negative amounts should be enclosed between parentheses. The + flag indicates that signs should be han-
dled in the default way, that is, amounts are preceded by the locale's sign indication, for example, nothing for positive, "-" for
negative.
! Omit the currency symbol.
- Left justify all fields. The default is right justification.
Next, there may be a field width: a decimal digit string specifying a minimum field width in bytes. The default is 0. A result smaller
than this width is padded with spaces (on the left, unless the left-justify flag was given).
Next, there may be a left precision of the form "#" followed by a decimal digit string. If the number of digits left of the radix charac-
ter is smaller than this, the representation is padded on the left with the numeric fill character. Grouping characters are not counted in
this field width.
Next, there may be a right precision of the form "." followed by a decimal digit string. The amount being formatted is rounded to the
specified number of digits prior to formatting. The default is specified in the frac_digits and int_frac_digits items of the current
locale. If the right precision is 0, no radix character is printed. (The radix character here is determined by LC_MONETARY, and may dif-
fer from that specified by LC_NUMERIC.)
Finally, the conversion specification must be ended with a conversion character. The three conversion characters are
% (In this case, the entire specification must be exactly "%%".) Put a '%' character in the result string.
i One argument of type double is converted using the locale's international currency format.
n One argument of type double is converted using the locale's national currency format.
RETURN VALUE
The strfmon() function returns the number of characters placed in the array s, not including the terminating null byte, provided the
string, including the terminating null byte, fits. Otherwise, it sets errno to E2BIG, returns -1, and the contents of the array is unde-
fined.
ATTRIBUTES
For an explanation of the terms used in this section, see attributes(7).
+------------+---------------+----------------+
|Interface | Attribute | Value |
+------------+---------------+----------------+
|strfmon() | Thread safety | MT-Safe locale |
+------------+---------------+----------------+
|strfmon_l() | Thread safety | MT-Safe |
+------------+---------------+----------------+
CONFORMING TO
POSIX.1-2001, POSIX.1-2008.
EXAMPLE
The call
strfmon(buf, sizeof(buf), "[%^=*#6n] [%=*#6i]",
1234.567, 1234.567);
outputs
[EUR **1234,57] [EUR **1 234,57]
in the nl_NL locale. The de_DE, de_CH, en_AU, and en_GB locales yield
[ **1234,57 EUR] [ **1.234,57 EUR]
[ Fr. **1234.57] [ CHF **1'234.57]
[ $**1234.57] [ AUD**1,234.57]
[ L**1234.57] [ GBP**1,234.57]
SEE ALSO
duplocale(3), setlocale(3), sprintf(3), locale(7)
COLOPHON
This page is part of release 4.15 of the Linux man-pages project. A description of the project, information about reporting bugs, and the
latest version of this page, can be found at https://www.kernel.org/doc/man-pages/.
Linux 2017-09-15 STRFMON(3)