By using "sed" command. Please help!!! Post: 302419505

Sponsored Content

Top Forums Shell Programming and Scripting By using "sed" command. Please help!!! Post 302419505 by durden_tyler on Friday 7th of May 2010 11:06:11 AM

05-07-2010

Registered User

Quote:

Originally Posted by nvkuriseti

...
From the above file, there is a date of birth in body (=020). I want to remove/substitute the dateofbirth with spaces. Like, 19750426 is the date of birth but want to substiute as spaces "1#7#0#2#". Want to do this same in all records in the file. Can you please tell me how to do this in shell script?
...
A small change in my previous post. Instead of substitue the spaces, need to fill every 2nd character as # in the Date of Birth field.
...

You haven't mentioned if the date of birth part begins at a specific column in your file. If it does, and if you know that column number, then you can do something like the following Perl one-liner:

Code:

$
$ cat f1
010AAAAA 20100507 234KB BBBBBBBBBB_20100506.DAT
020CCCCC                     DDDDDDDDD         373983983           19750426           456.90               3983939EE
020FFFFF                     GGGGGGGGG         38938993H           19801102           783.33               DKJFDKJ983
030END OF FILE TOTAL 39839.22
$
$
$ perl -plne 's/^(020.{64})(\d).(\d).(\d).(\d).(.*)$/$1$2#$3#$4#$5#$6/' f1
010AAAAA 20100507 234KB BBBBBBBBBB_20100506.DAT
020CCCCC                     DDDDDDDDD         373983983           1#7#0#2#           456.90               3983939EE
020FFFFF                     GGGGGGGGG         38938993H           1#8#1#0#           783.33               DKJFDKJ983
030END OF FILE TOTAL 39839.22
$
$

Over here I know that date of birth begins from column 68 in rows that start with "020". Hence I put "64" in the brace quantifiers so that total length of the part before it is 3 (length of "020") + 64 = 67.

HTH,
tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone

2. Shell Programming and Scripting

Simplify Bash Script Using "sed" Or "awk"

Input file: 2 aux003.net3.com error12 6 awn0117.net1.com error13 84 aux008 error14 29 aux001.ha.ux.isd.com error12 209 aux002.vm.ux.isd.com error34 21 alx0027.vm.net2.com error12 227 dux001.net5.com error123 22 us008.dot.net2.com error121 13 us009.net2.com error129Expected Output: 2...

3. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

4. UNIX for Dummies Questions & Answers

Unix "look" Command "File too large" Error Message

I am trying to find lines in a text file larger than 3 Gb that start with a given string. My command looks like this: $ look "string" "/home/patrick/filename.txt" However, this gives me the following message: "look: /home/patrick/filename.txt: File too large" So, I have two...

5. Shell Programming and Scripting

Using sed to find text between a "string " and character ","

Hello everyone Sorry I have to add another sed question. I am searching a log file and need only the first 2 occurances of text which comes after (note the space) "string " and before a ",". I have tried sed -n 's/.*string $*$,.*/\1/p' filewith some, but limited success. This gives out all...

6. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz

7. Post Here to Contact Site Administrators and Moderators

Suggestion: adding two new groups "sed" and "awk"

Majority of the questions are pertaining file/string parsing w.r.t sed or awk It would be nice to have these two as their own sub category under shell-programming-scripting which can avoid lot of duplicate posts.

8. Shell Programming and Scripting

sed returns error "sed: -e expression #1, char 18: unterminated `s' command"

Hello All, I have something like below LDC100/rel/prod/libinactrl.a LAA2000/rel/prod/libinactrl.a I want to remove till first forward slash that is outputshould be as below rel/prod/libinactrl.a rel/prod/libinactrl.a How can I do that ???

9. Shell Programming and Scripting

Awk,sed : change every 2nd field ":" to "|"

Hi Experts, I have a string with colon delimited, want 2nd colon to be changed to a pipe. data: 101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3: I am trying with sed, but can change only 1 occurance: echo "101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:" | sed 's/:/|/2'...

10. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing �To� e-mail address and column 3 contains �cc� e-mail address to include with same email. Sample input file, email.txt Below is an sample code where...

LEARN ABOUT HPUX

fwtmp

fwtmp(1M)																 fwtmp(1M)

NAME

       fwtmp, wtmpfix - manipulate connect accounting records

SYNOPSIS

       [files]

DESCRIPTION

   fwtmp
       reads from the standard input and writes to the standard output, converting binary records of the type found in to formatted ASCII records.
       The ASCII version is useful to enable editing, via ed(1), bad records or for general purpose maintenance of the file.

       The argument is used to denote that input is in ASCII form, and output is to be written in binary form.	The arguments and are independent,
       respectively specifying ASCII input and binary output.  Therefor, is an ASCII to ASCII copy and is a binary to binary copy.  should be used
       for reading If is not used, structure is read.

   wtmpfix
       examines the standard input or named files in format, corrects the time/date stamps to make the entries consistent, and writes to the stan-
       dard  output.  A can be used in place of files to indicate the standard input.  If time/date corrections are not performed, will fault when
       it encounters certain date-change records.

       Each time the date is set, a pair of date change records is written to The first record is the old date denoted	by  the  string  old  time
       placed  in the line field and the flag placed in the type field of the structure.  The second record specifies the new date, and is denoted
       by the string placed in the line field and the flag placed in the type field.  uses these records to synchronize all  time  stamps  in  the
       file.   nullifies date change records when writing to the standard output by setting the time field of the structure in the old date change
       record equal to the time field in the new date change record.  This prevents and from factoring in a date  change  record  pair	more  than
       once.

       In addition to correcting time/date stamps, wtmpfix checks the validity of the name field to ensure that it consists solely of alphanumeric
       characters or spaces.  If it encounters a name that is considered invalid, it changes the login name to and  writes  a  diagnostic  to  the
       standard error.	This minimizes the risk that will fail when processing connect accounting records.

DIAGNOSTICS

       wtmpfix generates the following diagnostics messages:

WARNINGS

       generates no errors, even on garbage input.

FILES

SEE ALSO

       ed(1),  acct(1M),  acctcms(1M),	acctcom(1M),  acctcon(1M),  acctmerg(1M), acctprc(1M), acctsh(1M), runacct(1M), acct(2), acct(4), utmp(4),
       wtmps(4).

STANDARDS CONFORMANCE

																	 fwtmp(1M)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

Discussion started by: harshakusam

2. Shell Programming and Scripting

Simplify Bash Script Using "sed" Or "awk"

Discussion started by: sQew

3. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Discussion started by: shis100

4. UNIX for Dummies Questions & Answers

Unix "look" Command "File too large" Error Message

Discussion started by: shishong