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 #874
Difficulty: Medium
A programming language is homoiconic if a program written in it can be manipulated as data using the language, and thus the program's internal representation can be inferred just by reading the program itself.
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