Is it possible to change the CSV format from comma to pipe?
I have a 3rd part vendor who is requiring a PIPE separator

Rather than lay out the fields side-by-side in the details section, create a formula that concatenates them into a single string with a pipe between each field. Then export that as text.

Pure Genius!
That should totally work. Now my problem is I have 1 filed that is huge and I can't export it without it truncating. Looks like the max I can get it width-wise is 200 (right-click text object:size and position). My longest full data line is 319.282 chars.

Pure Genius!
That should totally work. Now my problem is I have 1 filed that is huge and I can't export it without it truncating. Looks like the max I can get it width-wise is 200 (right-click text object:size and position). My longest full data line is 319.282 chars.

Do you want to set pipe as the delimiter at a global level? Or just for this one report? I'm looking at the Export Format Options file (available on the Start Menu) and I'm seeing this section:

<CharacterSeparatedValues>
<ExportMode>0</ExportMode> <!-- -1=Legacy, 0=Standard -->
<Delimiter></Delimiter>
<SeparatorText>,</SeparatorText>
<ReportSectionsOption>1</ReportSectionsOption> <!-- 0=Export, 1=ExportIsolated, 2=DoNotExport -->
<GroupSectionsOption>0</GroupSectionsOption> <!-- 0=Export, 1=ExportIsolated, 2=DoNotExport -->
</CharacterSeparatedValues>

I'm thinking you could change the SeparatorText value to a pipe character, but that would be a global change. If that works for you, it's worth trying. If not, I'm not sure what plan B is yet.

Ron is correct. You would use the Export Format Options file. This is only available for Pro users. Are you running free or Pro? Thanks!

Matt

I have not yet had a chance to read any of the manuals, I didn;t knwo this was even here. I would want these options on more of a per report basis. I am on Pro version.

OK, the export options is working -sort of.
<ExportMode>0</ExportMode> <!-- -1=Legacy, 0=Standard -->
<Delimiter></Delimiter>
<SeparatorText>|</SeparatorText>
<ReportSectionsOption>1</ReportSectionsOption>
<GroupSectionsOption>1</GroupSectionsOption>

What this does, is any non-text (date, numbers) field is no quotes and a pipe, but any text still has quotes. I can't find a setting that removes the quotes.

OK, the export options is working -sort of.
<ExportMode>0</ExportMode> <!-- -1=Legacy, 0=Standard -->
<Delimiter></Delimiter>
<SeparatorText>|</SeparatorText>
<ReportSectionsOption>1</ReportSectionsOption>
<GroupSectionsOption>1</GroupSectionsOption>

What this does, is any non-text (date, numbers) field is no quotes and a pipe, but any text still has quotes. I can't find a setting that removes the quotes.

I agree there are some formatting options that would be preferable to have on a per-report basis. This is one, the ability to generate a group tree with PDF exports is another.