Using an actual tab (\t) as a delimiter in "Build File" action (Integration Hub)

[Simon Ohle]

Hello,

when building a file schema for the "Begin File" action in the Integration Hub the guide tells me that I also could use \t as a delimiter.

When I export the CSV the delimiter is literally "\t" and not a tab, as I would have expected it.
Is it possible to export the csv with every field beeing a new column in the csv?

#integrationhub #developer #utilityactions #flowdesigner

[A Tarint]

Hi Simon,

Ran into the same issue and the solution/workaround provided by ServiceNow engineers is as follows.

>As a workaround to the issue that you are facing with Utility Actions Spoke - Append to Delimited File action, please run the below script to update the value 'Delimiter' field to \t via GlideRecord script as below:

var gr = new GlideRecord("sn_utility_spoke_file_schema");
gr.addQuery("sys_id", "<sys_id>"); // sys_id of the File Schema record
gr.query();
gr.next();
gr.delimiter = "\t";
gr.update();

Hope this helps.