How did you parse XML with AWK? I would never think of using AWK for XML data. I'd even stear clear of CSV data unless I could guarantee no in field commas or newlines.
Commas are easy if it's quoted. I just first run an awk script that uses " as the field separator and substitutes or deletes commas in odd numbered fields (as long as that's acceptable for your use case). Then with `-F,` I always check that NF is the same for all lines in the csv before proceeding.
Depending on how the xml is structured, it can be possible to just pattern match on the tags if you have something simple to do.
Depending on how the xml is structured, it can be possible to just pattern match on the tags if you have something simple to do.