Use two field spearators in awk

Question

I am trying to parse a string like this with bash

OPS |all|1234|ip:port1|name|state|number|id|phone=123;zip=123;state=AB;city=seattle .
OPS |all|1234|ip:port2|name|state|number|id|phone=123;zip=123;state=AB;city=spokane .

I want output like this

seattle | ip port1
spokane | ip port2

I was trying to use awk with this

awk -F'|' '{ n = split($4,array,"|"); printf "%s, %s\n", $4, array[n] }' file.txt

but its not printing the details that I want

score 4 · Answer 1 · answered Jun 17 '17 at 17:26

4

Use -F and [] to set multiple field separators.

awk -F '[|:= ]' '{print $14,"|",$4,$5}' file

Output:

seattle | ip port1
spokane | ip port2

answered Jun 17 '17 at 17:26

Cyrus

84,225
14
89
153

I changed the input a little (a space after OPS ) an the output is coming out like this `AB;city | 1234 ip AB;city | 1234 ip` – jigsaw Jun 17 '17 at 17:33
If you insert an additional field separator, then the output also changes. – Cyrus Jun 17 '17 at 17:35
yeah, I just changed your answer to increment by 1 and it worked – jigsaw Jun 17 '17 at 17:43

Use two field spearators in awk

1 Answers1

Linked

Related