Unix environment has some excellent tools for parsing text in various forms. However off late the data is not in the regular set of formats(CSV,TSV,Record based or some other delimiter based) it used to be before. Data these days is exchanged in structured formats like XML's/JSON's.
I know there are some good tools like sed, awk and Perl which can chew down nearly form of data out there. However to work with this sort of structured data often one has to write a complete program and given the little time available to extract information, one has to sit down and figure out the whole logic of what one wants to query and put it down programatically. Sometimes this is not OK. Basically because the information extracted from those files acts inputs for further work. Also because of the time it takes to search for the appropriate solution and coding it up. A command line tool is needed with sufficient switches to find, query and dump data.
Im looking for tools that take a XML/JSON or other forms of structured data and dump it into other formats like csv etc. So that from there one could use other commands to get any information out of it.
Are there any command line utilities you know of which do this kind of a job. Are there already awk/Perl scripts available to this?