Did you know you can change the CSV delimiter used by the Utility - File Management VBO?

ewilson — Wed, 31 Mar 2021 18:26:00 GMT

It's true! If you have CSV files that use a delimiter other than the default comma (,) you can customize the behavior of the Utility - File Management VBOs Get CSV Text as Collection action by creating a file named schema.ini and placing it in the same folder as your CSV file.

The contents of the schema.ini file should be:

[<CSV File Name>]
Format=Delimited(<Your Delimiter Character>)

Example:

[MyTestFile.csv]
Format=Delimited(|)

There are additional properties that you can specify too. To find out more about what you can do with schema.ini file check out this Microsoft page.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

topic Did you know you can change the CSV delimiter used by the Utility - File Management VBO? in Digital Exchange

Did you know you can change the CSV delimiter used by the Utility - File Management VBO?