Good morning!
Is there a way to check which type of separator is on the csv that i’m receiving?
So setting the separator could be something dynamic instead of:
options.setSeparator(';');
Thank you
I am afraid, there is no better way to cope with it. We do not provide any such API to detect which delimiter was used in the CSV/Text file. As you know, the CSV file is just a plain text having string content/data. So, without the user’s specified delimiter, we cannot know and parse one line string value into cells accordingly (you know any kind of characters can exist in the field value). In short, I am afraid the separator cannot be detected automatically while loading the file.
Thanks for your understanding!