I am trying to run the standard EXPORT_MD_TO_FILE Data Manager Package. I'm having an issue with any descriptions that have a comma. If the description has a comma, it splits it into another column in the export.
Thus, if I have:
45678 Pottery Austin, TX
My export will show: 45678,Pottery Austin, TX
I would think it should show: 45678,"Pottery Austin, TX"
(like any other csv file)
I have tried changing the OUTPUTDELIMITER field in the transformation file to a semi-colon (;), however the behavior does the following:
45678;Pottery Austin; TX
It seems like the behavior of the Export first makes the delimiter a comma, then does a find and replace of all commas with the OUTPUTDELIMITER value, thus even converting my text comma to a semi-colon.
Has anyone else experienced this and/or found a way around this?
(BPC NW 10.0)