Resolve issue where Columns move over on CSV Reports in Confirm

Product Feature: Street Works


Some columns are moving over to the right for some of the Reports in Confirm, ONLY when reports are saved as "Comma Separated Text(Visible data)"


The root cause is the fact that the values of a few of the columns (on the affected rows) contain an actual comma “,”.


UPDATED: November 7, 2017
Solution is to refrain from using  "Comma Separated Text(Visible data)" and stick with “Comma Separated Text (All data)” when saving Reports in Confirm.