CSV Export Missing Data

[Anonymous]

The goal is to have clients export data from a table reflected as is published. The current field in question reflects a list of districts with a comma as a delimiter. While published, data is accurately displayed. When exported, the data will correctly show up to 5 comma places. Any numbers after 5 comma places, will reflect 000. I tried playing with the formatting with in the CSV file but the output is still not correct. Any thoughts on how to have data exported correctly? Below you will find the current output + expected output. The column in question (Assigned_Districts) is reflected as a Text field. This was done in PQ Any advice is greatly appreciated. 

Current Output: Notice the last 2 rows with 000

Assigned_Districts

730,732

454,740,819

249,250,253

685,687,689,698,699,000

201,204,205,206,207,000,000,000,000,000,000

Expected Output: All of the data is correctly displayed

Assigned_Districts

730,732

454,740,819

249,250,253

685,687,689,698,699,700

201,204,205,206,207,835,208,209,210,215,216

[Anonymous · Accepted solution]

I was able to find a solution by changing the delimiter character from comma ( , ) to slash ( / ). This displayed the districts without any interruption. My guess is that since the numbers were 3 digits and separated by comma, the system was interpreting that as a very large number.