Question

Is it possible to use multiple delimiters in Import CSV to Database

Forum|Forum|3 years ago
June 19, 2023
2 replies
0 views

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

stefanhelzle0001

This is not supported. You will have to detect the delimiter first, or let the user decide.

peter.lewis

Employee

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.

Sign up

Login with SSO

Login to the community

Login with SSO