dhis2-devs team mailing list archive

[Timothy Harding <hardingt@xxxxxxxxx>]

Hello DHIS2 Dev Group

We are in a transition period at the moment between an offline Access
Database and the online DHIS2 HIS and in the next few months I will need to
do some reports that pull from both. Right now I am creating some pivot
tables to download. While I was performing some simple awk scripts, I found
a potential drawback to the CSV output.

I understand that CSV stands for Comma Separated Values, but several of our
organizational units have commas in their names. This is causing awk to go
haywire. Is there anyway we can download a pivot table from DHIS2 using a
different field separator? Such as a | or some character combination that
cannot exist inside the name field for an organizational unit?

I am aware of attempting this with more than one FS e.g. awk -F'","|^"|,$'
but this is even more finicky.

Thanks!


Timothy Harding
PeaceCorps Volunteer
Republic of Vanuatu
hardingt@xxxxxxxxx
+678 5955137