Interpret sed and awk in the below command.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Interpret sed and awk in the below command.
# 1  
Old 01-12-2009
Data Interpret sed and awk in the below command.

Could you interpret the following sed and awk command for me?

command:
cat tempfile2 |sed "s/\(BUILD-3-.*-[0-9]\.[0-9]-\)\([0-9].*\.[0-9].*\.[0-9].*\)/\2/" | awk '{printf "%-8.8s %-23.23s %-30.30s %-50.50s\n", $1,$2,$3,substr($0,index($0,$4))}' > outfile2 2>/dev/null

input:data in tempfile2
BUILD-3-CbsOrderDTVInterfaceV2-1.0-2.0.7 DCR-14447 vk0957-?Vikas?Kaward validate?BTN?field?as?alphnumeric?instead?of?numeric.

output:
2.0.7 DCR-14447 vk0957-?Vikas?Kaward validate?BTN?field?as?alphnumeric?instead?of?numer
Image
# 2  
Old 01-12-2009
It's transforming the input file into the output file. Specifically, the sed command is stripping everything from "BUILD-3" until some version number, keeping only that version number. The awk command is formatting the resulting space-delimited fields into strings of a maximum length (of 8, 23, 30, and 50 characters). So you see the last field is truncated and instead of displaying "...?numeric." it displays "...?numer".
# 3  
Old 01-12-2009
But please look into this.....

Thank you for the valuable input.

But while I give the following input,

BUILD-3-ECDBCrisDataLoaderV8-1.14-8.14.2 DCR-14461 mpdwfxt?-?Jayashree Remove?Pef?Changes

It gives the following output which is not as per the above format? can you tell me why?

BUILD-3- DCR-14461 mpdwfxt?-?Jayashree Remove?Pef?Changes
# 4  
Old 01-12-2009
I think the problem is that the sed command is inside double-quotes. This means the shell is interpreting \. and so sed sees a period, which means "match any character", as opposed to \. which means "match a period". So the expression matches everything it can, including DCR-14461 in the second column. Simply replace the double-quotes (") with single-quotes (').
# 5  
Old 01-12-2009
But sir!!!!!!

Still i get the same error.

output:

cat tempfile2 |sed 's/\(BUILD-3-.*-[0-9]\.[0-9]-\)\([0-9].*\.[0-9].*\.[0-9].*\)/\2/' | awk '{printf "%-8.8s %-23.23s %-30.30s %-50.50s\n", $1,$2,$3,substr($0,index($0,$4))}' > outfile2 2>/dev/null

mbsyst01:vj8436$cat outfile2
BUILD-3- DCR-14461 mpdwfxt?-?Jayashree Remove?Pef?Changes
BUILD-3- DCR-14463 sc4294 Change?the?getSBTCComponents?file?to?include?the?l
BUILD-3- DCR-14476 mpdwfxt?-?Jayashree Undoing?perf?changes
# 6  
Old 01-12-2009
That's odd. Okay, replace all instances of
Code:
.*

with
Code:
[^ ]*

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with sed/awk command

Hi All, This is my first thread. Hopefully you guys can help me out. I have a csv file, that provides access to managers to a tool. The file is loaded onto our server containing all the assc id's with a trailing comma. For ex: 182950, 123456, However, we receive a file that... (8 Replies)
Discussion started by: Prateek Dubey
8 Replies

2. Shell Programming and Scripting

Need help with sed/awk command

Dear ALL, I am still struggling with some basic sed operations. I want to change path in a file as shown below: case_OM = PV4Reader( FileName='/home/linuxUser/demoCases/s1/case/case.OM' ) to case_OM = PV4Reader( FileName='/home/linuxUser/demoCases/s2/case/case.OM' ) In this file there... (5 Replies)
Discussion started by: linuxUser_
5 Replies

3. 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

4. UNIX for Dummies Questions & Answers

How does Awk interpret $0!~

I know $0 is the entire file's contents (at least I think that is what it is!), but what exactly is: $0!~ This was a snippet from a larger line awk '$0!~/^$/ {print $0}' This deletes blank lines, but I want to know specifically the $0!~ part... I am guessing /^$/ is regex for blank line...... (5 Replies)
Discussion started by: glev2005
5 Replies

5. Shell Programming and Scripting

SED/AWK command

Hi All, I have a file which has following lines : - Deploy XXX application <server-address> - info <server-address> - Deploy XXX application <server-address> - info <server-address> - Deploy XXX application <server-address> - info <server-address> I want output like this way in... (8 Replies)
Discussion started by: bhaskar_m
8 Replies

6. Shell Programming and Scripting

Interpret the sed command.

Could you interpret the following sed and awk command for me? command: cat tempfile2 |sed "s/\(BUILD-3-.*-\.-\)\(.*\..*\..*\)/\2/" | awk '{printf "%-8.8s %-23.23s %-30.30s %-50.50s\n", $1,$2,$3,substr($0,index($0,$4))}' > outfile2 2>/dev/null input:(data in tempfile2)... (1 Reply)
Discussion started by: vj8436
1 Replies

7. 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

8. Shell Programming and Scripting

sed for this awk command

Hi what would be the sed equivalent of this awk command: awk '/$getsn/{getline;next}{print}' file It deletes the variable found and the next line after it in a file. Thanks (3 Replies)
Discussion started by: wisher115
3 Replies

9. Shell Programming and Scripting

Help with Sed or AWK command!!!

Hi, I need help with Sed or AWk command.i want to remove all the numerals from the file name.These files are stored within a text file and after the numerals are removed,i need to redirect its output to another new .txt file. Input: aa_1002985_952.xml aa_bb_032207.txt... (5 Replies)
Discussion started by: kumarsaravana_s
5 Replies

10. UNIX for Dummies Questions & Answers

What do you know about the Sed and Awk command??

I just need some information on what they can be use for and whatever else there is. anything you know, state here (2 Replies)
Discussion started by: TRUEST
2 Replies
Login or Register to Ask a Question