03-31-2006
sed Command - Need Additional Assistnce
Here is my data
I have a file in the format below with about 15 fields per each record. I have 2 records displayed below.
"1234","Andy ","Rich ","0001","123 Main Street ","Dallas ", "1"
"2345","Andrew ","Richter ","0002","234 First Ave ","Kirby ", " "
My Final output needs to be as follows
"1234","Andy","Rich","0001","123 Main Street","Dallas","1"
"2345","Andrew","Richter","0002","234 First Ave","Kirby"," "
I am using the following Sed command and it works excep it also deletes the space in the field and I need the last data element to stay like it is either a "1" or a " " (space).
sed -e 's/[ ]"/"/g' inputfile>outputfile...
what do I need to change in the sed command that I am using to get the result that I am looking for. The above is just the sample of the data, and it is not all data elements, there are quite a few additional fields but the last field is what I have in my data sample.
Thanks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello:
I have a customer who is requesting the following security features on a Solaris 8 system:
1. Password history for the three previous passwords.
2. User account lockout after 3 failed login attempts.
Can anyone help provide me with a solution or direction for the above? (1 Reply)
Discussion started by: rambo15
1 Replies
2. Shell Programming and Scripting
Sorry for the duplicate thread this one is similar to the one in
https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121
Since there were no responses on the parent thread since it got resolved partially i thought to open the new... (4 Replies)
Discussion started by: rajan_san
4 Replies
3. Shell Programming and Scripting
Okay, title is kind of confusion, but basically, I have a lot of scripts on a server that I need to replace a ps command, however, the new ps command I'm trying to replace the current one with pipes to sed at one point. So now I am attempting to create another script that replaces that line.
... (1 Reply)
Discussion started by: cbo0485
1 Replies
4. UNIX for Dummies Questions & Answers
I know this script is crummy, but I was just messing around.. how do I get sed's insert command to allow variable expansion to show the filename?
#!/bin/bash
filename=`echo $0`
/usr/bin/sed '/#include/ {
i\
the filename is `$filename`
}' $1
exit 0 (8 Replies)
Discussion started by: glev2005
8 Replies
5. Shell Programming and Scripting
I need to be able to take the results from ls -l command and modify the output as follows:
I will run
ls -l *.mak
My results will be
aa.mak
bb.mak
cc.mak
I then need to take those results and create a file that has the following info:
dsjj/ubin/aa
dsjj/ubin/bb
dsjj/ubin/cc
... (3 Replies)
Discussion started by: jclanc8
3 Replies
6. Shell Programming and Scripting
Hi all,
I have script to monitor and sum up the total memory use up for each individual process.
proc=$1
svmon -P -O summary=basic,unit=MB|awk 'NR>4'|grep -w "${proc}" |awk '{sum+=$3} END {printf "\t" sum """\n";}'
But I would like the script to be able to display as following
... (3 Replies)
Discussion started by: ckwan
3 Replies
7. Shell Programming and Scripting
Input file:
3420023_3422482,3422486_3423070 46910
1795263_1798343 32681
1837399_1838886 1534
2148674_2149696,2149698_2149772 10203
3825382_3825555,3827296_3827900 198
1839890_1840294 72
.
.
Output file
3420023_3422482,3422486_3423070 3420023_3422482,3422486_3423070 46910
1795263... (1 Reply)
Discussion started by: perl_beginner
1 Replies
8. Shell Programming and Scripting
Hi,
I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :-
./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I'm relatively new to Unix scripting and am trying to get my head around piping.
I'm trying to take a header record from one file and prepend it to another file. I've done this by creating several temp files but i'm wondering if there is a cleaner way to do this.
I'm thinking... (10 Replies)
Discussion started by: BigCroyd
10 Replies
10. Shell Programming and Scripting
Hello i am having an issue with bash script and this is the code
now=$(cat hosts1.txt | awk '{print $2;}')
while read n ;do
ssh root@$now 'useradd test1; echo -e "test1\ntest1" | passwd test1 && echo "test1 ALL=(ALL:ALL) ALL" >> /etc/sudoers'
When i execute only part with cat, it... (8 Replies)
Discussion started by: tomislav91
8 Replies
LEARN ABOUT LINUX
strfmon_l
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)
Linux 2017-09-15 STRFMON(3)