Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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