Search Results

With " as the field separator, your sample input is shown on the first line below and the field numbers are shown on the next line (with the leading digit dropped in field numbers 13, 15, 19, 21, and...

Try also awk -F\" '/^{"driver.*first_name.*last_name.*}}$/ {print $6, $10, $14, $20, $24}' OFS=, file
xxxx,yyyy,US285204420,1 234,BUDGET

perl -ne 'print "$1,$2,$3,$4,$5\n" if /{"driver":{"first_name":"([^"]+)","last_name":"([^"]+)"},"confirmation_id":"([^"]+)","vendor":{"id":"([^"]+)","name":"([^"]+)"}}/' filename


ASSUMPTIONS,...