Extracting data from one line 1

[rella]

My input looks like this:

[Name1] = { [Level] = 18, [Class] = Class1, [Rank] = Member1, },
[Name2] = { [Level] = 17, [Class] = Class2, [Rank] = Member2, },
[Name3] = { [Level] = 16, [Class] = Class3, [Rank] = Member3, },
[Name4] = { [Level] = 15, [Class] = Class4, [Rank] = Member4, },


What I’d like to see output is this:


Name1 18 Class1 Member1
etc....

Any help you can give me is greatly appreciated, even if just pointing me in the right direction. I tried using the = as a field separator but that doesn't help me get the name. I hate being a novice.

 

[PHV]

You may try this:
nawk '
{gsub(/[\[\]{},=]/,"");gsub(/(Level|Class|Rank)/,"");print}
' /path/to/input > output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vgersh99]

elaborating a bit on PHV posting:

{
  gsub(/[\[](Level|Class|Rank)[\]]/,"")
  gsub(/[\[\]{},=]/,"")
  print
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[futurelet]

BEGIN { FS = " = |, " }
{ gsub( /\[|\]/, "" )
  printf "%-12s%-7s%-10s%s\n", $1,$3,$5,$7
}

Let me know whether or not this helps.

If you have nawk, use it instead of awk because on some systems awk is very old and lacks many useful features. Under Solaris, use /usr/xpg4/bin/awk.

For an introduction to Awk, see faq271-5564.

PHV, remember what I told your about testing your code?

 

[rella]

Thank you both very much...

 

[rella]

Futurelet,


That worked perfectly.. thanks!

Now I'm going to figure out why it worked

Thanks again