Using Orchestrator Studio (groovy or JRuby) to read a CSV file or determine what the delimiter is

Hi folks

I have a CSV reading process that happily takes a CSV, reads though and calls a form recording to process each row. Happy days!

However, as this is being rolled out to global users, we are experiencing different users in certain countries use a different delimiter. , or ; for example

So to solve this issue I have several ideas.

Work out a way to determine what the delimiter is

Use a groovy script to read and parse the CSV (we may have to instal java libraries/methods however)

Use a JRuby script to read and parse the CSV (I hope JRuby has built in methods to do this)