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
------------------------------
