VERIFIED SOLUTION i

Resolve issue where Columns move over on CSV Reports in Confirm

Product Feature: Street Works

Issue

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)"

Cause

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

Resolution

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.