Visit Our UNIX and Linux User Community


Can anyone help with a sed command?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Can anyone help with a sed command?
# 1  
Old 09-23-2002
Can anyone help with a sed command?

I have data that I need to "massage" in order to correct it prior to sending to be processed.

Below is 1 record of many.

0000011800000000159426750146341107193523234406252002AV765156210 45330 FLME0083489G56109FLME0083489G56109000000000000000000000000000000000660000000000000000000000000000000 00000660200

There is a ^M at the end of every record.

The data within the record that I need to change is:

FLME0083489G56109FLME0083489G56109

Where I want to change the G56109 to be replaced with blank spaces. This pattern is located 2 times in each record with FLME####### preceeds the data I want to change.

I know the exact position in each line that I want to either take out or change. I just don't know what would be the easiest route to take.

Could I perform a "cut" of the file and possibly "paste" in 6 blank spaces that I need in the 2 different places? Or is there a "sed" command that would be more efficient?

Any help is certainly apprecaited.
# 2  
Old 09-23-2002
Re: Can anyone help with a sed command?

Quote:
Originally posted by Docboyeee
Where I want to change the G56109 to be replaced with blank spaces. This pattern is located 2 times in each record
I would just use:
Code:
sed 's/G56109/      /g'

# 3  
Old 09-23-2002
Thanks for the reply.. but.. that won't help. The G##### is simply a pattern that falls precisely in the file. If the numerical values associated with G remained constant then your command would work for me.

If there was a command where I could search for FLME and once I found FLME within the data line, I could change the data in positions 8-13 AFTER encountering FLME to contain six blank spaces, that would work, just don't know the command.

I do know the position of the data in each record that I want to change to spaces. They are 225-230 and 242-247. I thought of cut and paste but am not sure exactly how to paste 6 blank spaces in the line at those positions. UGH!!!
# 4  
Old 09-23-2002
Well then, how about:
Code:
sed 's/\(FLME.....\)G...../\1      /g'

I may have the exact number of dots wrong, but you get the picture.
# 5  
Old 09-23-2002
I tried that code... but I am missing something.

Here is a pasting of several records.

0000011800000000001726552283540814193623235106202002A787917879956210 45380SG FLME0035909D85671FLME0035909D85671000000000000000000000000000000000715000000000000000000000000000000 00000715200 AS10 0000011800000000001826314494930424191513230806142002A2113 2809 78321 45385SG 45384SG 4538059SG43235SG FLME0083489G56109FLME0083489G56109000000000000000000000000000000002806000000000000000000000000000000 00002806200 AS10 0000011800000000001926346732241224193313244204122002A2113 45385 FLME0015393D54571FLME0015393D54571000000000000000000000000000000000675000000000000000000000000000000 00000675200 AS10

You will notice that the data I need to change varies.. it could start with a G or a D or even an E or possibly some other variable. Is there a way to just simply replace those positions in the file with blank spaces? Im missing something.. and I know it's right in front of me..
# 6  
Old 09-23-2002
If the G is not constant data, replace the G with a dot in my sed statement.
# 7  
Old 09-23-2002
This is the results I get.

1$ sed 's/\(FLME.......\)......\1 /g' < ahca.rpt > me

sed: 0602-404 Function s/\(FLME.......\)......\1 /g cannot be parsed.

Previous Thread | Next Thread
Test Your Knowledge in Computers #367
Difficulty: Medium
The Single UNIX Specification specifies vi, so every conforming UNIX system must have it.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Output of sed command to another sed command

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

2. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

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

3. Shell Programming and Scripting

sed Command

Hello, I'm working with this command which I'm having trouble understanding it: sed -e '1,$ s/SUB/N/g' < $1 > file.txt Where SUB stand for an special character with code in ASCII is 0x1A, notepad read it as a right arrow. Any help will be appreciated. (5 Replies)
Discussion started by: emilioveras
5 Replies

4. 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 ??? (8 Replies)
Discussion started by: anand.shah
8 Replies

5. UNIX for Advanced & Expert Users

sed command

Hi..... I'm using sed command for replace the words in a file cat >test.txt My test.txt contains Mary had a little ham Mary fried a lot of spam Jack ate a Spam sandwich Jill had a lamb spamwich Marry had a spicy wich $ sed 's/wich$/mirchi/g' test.txt output is: Mary had a little ham... (24 Replies)
Discussion started by: ksrivani
24 Replies

6. UNIX for Dummies Questions & Answers

sed insert command and variable expansion/command substitution

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

7. Shell Programming and Scripting

Convert Sed command to perl command

Hello, Can any perl experts help me convert my sed string to perl. I am unsuccessful with this. I have to remove this string from html files OAS_AD('Top'); I have come up with this. However the requirement is in perl. for find in $(find . -type f -name "file1.html") ; do cat $find |... (2 Replies)
Discussion started by: abacus
2 Replies

8. UNIX for Dummies Questions & Answers

some help with the sed command please

hi all, attached you can find a small txt file ( .txt ), GIVEN that past_scheduler="islip" and scheduler="mucf" can somebody please tell me WHY sed 's/-u '$past_scheduler'/-u '$scheduler'/g' .txt > .txt.temp fails ? thanx (3 Replies)
Discussion started by: OneDreamCloser
3 Replies

9. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

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

10. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

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

Featured Tech Videos