Hi Experts

Looking for small help

1. How to use AWK inside AWK
2. How to use cut/some unix commands inside awk

Ex:

echo "123:222,234:3333"|awk -F '[:,]' '{print $2}'
==> output : 222

$ echo "123:222,234:3333"|awk -F '[:]' '{print $1"-"$2"-"system("echo "$2|awk -F"," '{print $1}')}'
awk: {print $1"-"$2"-"system("echo "$2|awk -F"," {print
awk: ^ syntax error
awk: {print $1"-"$2"-"system("echo "$2|awk -F"," {print
awk: ^ syntax error

Here I want to get 3333


$ cat File.log
VAR1|11:1111,22:2222,33:3333|STD99
VAR2|A1:1212,A2:B2B2,A3:C3C3|STD98
VAR3|B1:6969,B3:9079,B3:9869|STD97


[oracle@pd4lmsdrdb01](+ASM1:/tmp)
$ cat File.log | awk -F "|" '{print $1"-"$2"-"$3"-"system("echo "$2"|awk -F '[:,]' '{print $2}'")}'
awk: {print $1"-"$2"-"$3"-"system("echo "$2"|awk -F [:,] {print
awk: ^ unterminated string

I want the output as below (showing for 1 line)

VAR1-11:1111,22:2222,33:3333-STD99|1111

Please let me know when I am making mistake

and using AWK inside AWK

Please use [code] tags for code and output.

It looks like your quotes are confused. You appear to have double quotes inside double quotes and single quotes inside single quotes. That's probably what's causing the "unterminated string" error. In the first example, there's a quote missing before the $1.

But I have to ask, if you want 3333 in your first example, why not
?? That is, change the delimiter to redefine the fields then print out the field you want.

The simple answers are:
1. Don't
2. Don't

That might be the most convoluted code I've ever seen for such a simple task. Use a single instance of awk to do everything.

but can you see how to use unix command inside awk using on one of the awk fields

this might not be so complicate code only thing is am not able to catch it.

You need to advise us on what decisions need to be made when a line from the file is read. Obviously your current solution does not work but we don't understand how you came to that code
just that it does not work.

As mentioned by syg00, there would not be any reason to call awk inside awk, you just need to use what you have correctly.

So, presented with the following input:
What decisions were made that would make the output look like:
To give you an idea, from a visual point of view there are 2 steps:

1. Change the pipe (|) into a hyphen (-)
2. Using pipe, colon and comma as separators, grab the third field and place at the end after change above and put a pipe in between

Thats fine I was able to implement awk inside awk
Figured out
Thanks

Please tell us how. Show us what worked. That will help the next guy.

Thank you.