Export CSV as PIPE delimited using System Export Set

Matt Small1
Tera Expert

I found that using the system export set to export records to a mid-server so we can then transfer via SFTP to a vendor will meet our need,   however was wondering if there was some way that the CSV file export could be PIPE   '|' delimited instead of comma.   The 3rd party vendor would prefer to get the file PIPE delinted.     Looking at the   "sys_export_set" table there is no field where you can set the CSV delimiter like you can on the "sys_data_source" table.     Does anyone have an idea or know if it is possible to do a pre-export script or post-export script on the scheduled_data_export that could read take the generated CSV file and replace the comma with PIPE.   Any ideas on how do do that?       I have looked at what John Andersen has here

Beyond the Comma — File Export Delimiters | John Andersen had here but that post is from 2010 and i'm not seeing how i can use that SI in my pre or post export script.   Any ideas would be appreciated.

1 REPLY 1

Chuck Tomasi
Tera Patron

I don't believe the current export set implementation allows you to change the delimiter. The only way I know to do this would be a processor as described in that article you cited.



I invite you to open an enhancement request! Our product managers DO listen.


Enhancement requests: Tell us how you would improve the ServiceNow product