Hello team,
I am not able to find out if it is possible to use multiple delimiters in Import CSV to Database object. Some of our users create csv with comma some of them with semicolon and I need to ensure it will work with both options. Based on the object configuration it seems like it is not possible, as Multiple option is disabled. Any suggestion please?
Thanks
Discussion posts and replies are publicly visible
This is not supported. You will have to detect the delimiter first, or let the user decide.
I don't believe it's possible to use multiple delimiters, but could you have a gateway in your process that checks which delimiter is used? You'd likely need to extract the first row, and then check to see if a comma or semicolon is used.