File Parsing

fanatic_ravi · 06-13-2013, 04:55 AM

Any Single one-line command to read file like below and provide o/p as

/dev/sda d6 00 00 CL4Q 03:7e OPEN-V 00000111
/dev/sdaa d6 00 1a CL4Q a3:6e OPEN-V 00000111
/dev/sdaaa 97 03 08 CL3G 0f:83 OPEN-V 00000111
/dev/sdaab 7c 05 27 CL4G 0f:a2 OPEN-V 00000111
/dev/sdaac 97 03 09 CL3G 0f:84 OPEN-V 00000111
/dev/sdaad 7c 05 28 CL4G 0f:a3 OPEN-V 00000111
/dev/sdaae 7c 05 29 CL4G 0f:a4 OPEN-V 00000111

Output should be as below in CAP's

CL4Q 00:03:7E OPEN-V 00000111
CL4Q 00:A3:6E OPEN-V 00000111
CL3G 00:0F:83 OPEN-V 00000111
CL4G 00:0F:A2 OPEN-V 00000111

druuna · 06-13-2013, 05:10 AM

Code:

awk '{ print $5, "00:" toupper($6), $7, $8 }' infile

BTW: You've been asking a lot of similar questions, you might want to look at the following links:

Bash:

Sed and Awk:

O'Reilly: Sed/Awk

BTW: Please put your script/data inside [code] ... [/code] tags it preserves all spacing. If you don't know how: LQ - BB Code List.

chrism01 · 06-13-2013, 05:12 AM

Its a good idea to use code tags https://www.linuxquestions.org/quest...do=bbcode#code when posting data/code to preserve formatting/indentation etc.

Maybe you could amend the code you were given here http://www.linuxquestions.org/questi...le-4175465676/

You could always use awk instead.

fanatic_ravi · 06-13-2013, 06:31 AM

I don't have a linux machine, so downloaded gawk-3.1.6.1 and tried as below and it failed as below .any idea as how to fix this ?

Code:

C:\gawk-3.1.6-1-bin\bin>awk '{ print $5, "00:" toupper($6)
, $7, $8 }' xpinfo.2013_06_02_aft2
awk: '{
awk: ^ invalid char ''' in expression

H_TeXMeX_H · 06-13-2013, 06:31 AM

These are just homework questions.

fanatic_ravi · 06-13-2013, 06:41 AM

got the solution

Code:

 awk "{ print $5, \""00:\"" toupper($6), $7, $8 }" xpinfo.2013_06_02_aft2

druuna · 06-13-2013, 06:57 AM

Quote:

Originally Posted by fanatic_ravi

I don't have a linux machine

You should include this information in your original posts.

This is a linux forum and answers will be based on that assumption if no indication is there that this is not the case.

Many things are different when using windows
- redirecting is done differently,
- pipes are different,
- EOL is different,
- quoting is different,
- tools used might not have the same functionality/options,
- etc....