awk parsing problem Post: 302909499

Sponsored Content

Top Forums Shell Programming and Scripting awk parsing problem Post 302909499 by RudiC on Thursday 17th of July 2014 11:19:33 AM

07-17-2014

Registered User

You should have transcribed above literally. Try this (using "match..." as a pattern, not as part of the action):

Code:

awk     'match ($1, /SUDO_GRP\([^)]*\)/)        {MT=substr($1, RSTART, 8)
                                                 n=split(substr($1, RSTART+9, RLENGTH-10),T,"[,]*")
                                                 for (i in T) print MT "(" T[i] ")", $2}
        ' FS="|" OFS="|" file
SUDO_GRP(rsm)|900000313                                        
SUDO_GRP(analyzer)|900001093
SUDO_GRP(duladm)|900001093

---------- Post updated at 17:19 ---------- Previous update was at 17:13 ----------

Try this to become more flexible:

Code:

awk     'match ($1, MATCH"\([^)]*\)")   {L=length(MATCH)
                                         n=split(substr($1, RSTART+L+1, RLENGTH-L-2), T, "[,]*")
                                         for (i in T) print MATCH "(" T[i] ")", $2}
        ' FS="|" OFS="|" MATCH="SUDO_ALIAS" file
SUDO_ALIAS(HAMU1)|900001093

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk parsing problem

I need help with a problem that I have not been able to figure out. I have a file that is about 650K lines. Records are seperated by blank lines, fields seperated by new lines. I was trying to make a report that would add up 2 fields and associate them with a CP. example output would be...

2. Shell Programming and Scripting

Parsing problem

I need to separate out the contents in the string "xyz","1233","cm_asdfasdf" as xyz,1233,cm_asdfasdf Can anyone help me on this??

3. Shell Programming and Scripting

Parsing problem

Hi, i need to parse a string which looks like this "xyz","1233","cm_asdfasdf"

4. Shell Programming and Scripting

Parsing problem

I need to parse a string which looks like "xyx","sdfsdf","asf_asdf" into var1="xyx" var2="sdfsdf" var3="asf_asdf"

5. Shell Programming and Scripting

Parsing Problem

Hi all, I am having problems parsing the following file: cat mylist one,two,three four five,six My goal is to get each number on a seperate line. one two three four five six I tried this command: sed -e 's/\,/^M/g' mylist

6. Shell Programming and Scripting

Another parsing line awk or sed problem

Hi, After looking on different forums, I'm still in trouble to parse a parameters line received in KSH. $* is equal to "/AAA:111 /BBB:222 /CCC:333 /DDD:444" I would like to parse it and be able to access anyone from his name in my KSH after. like echo myArray => display 111 ...

7. Shell Programming and Scripting

Parsing problem

Hello, I have a similar problem so I continue this thread. I have: my_script_to_format_nicely_bdf.sh | grep "RawData" |tr -s ' '|cut -d' ' -f 4|tr -d '%' So it supposed to return the percentage used of RawData FS: 80 (Want to use it in a alert script) However I also have a RawData2 FS so...

8. Homework & Coursework Questions

Problem parsing input with awk

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I want add a line.For example:- 123456 1 1 0 1 1 0 1 0 0 0 1 5 8 0 12 10 25 its answer...

9. Shell Programming and Scripting

Complex text parsing with speed/performance problem (awk solution?)

I have 1.6 GB (and growing) of files with needed data between the 11th and 34th line (inclusive) of the second column of comma delimited files. There is also a lot of stray white space in the file that needs to be trimmed. They have DOS-like end of lines. I need to transpose the 11th through...

10. Shell Programming and Scripting

Problem parsing

Hi, I want to fetch a text.Clipping. ...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk parsing problem

Discussion started by: timj123

2. Shell Programming and Scripting

Parsing problem

Discussion started by: Sushir03

3. Shell Programming and Scripting

Parsing problem

Discussion started by: Sushir03

4. Shell Programming and Scripting

Parsing problem

Discussion started by: Sushir03

5. Shell Programming and Scripting

Parsing Problem

Discussion started by: rob11g

6. Shell Programming and Scripting

Another parsing line awk or sed problem

Discussion started by: RickTrader

7. Shell Programming and Scripting

Parsing problem

Discussion started by: drbiloukos

8. Homework & Coursework Questions

Problem parsing input with awk

Discussion started by: Arsh10

9. Shell Programming and Scripting

Complex text parsing with speed/performance problem (awk solution?)

Discussion started by: Michael Stora

10. Shell Programming and Scripting

Problem parsing

Discussion started by: protocomm