We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Is there a way to find which delimeter is saved in a csv file

I have a scenario in which there might be case in which the csv file is saved with a delimiter other than ‘,’ is there a way to find that delimiter using any property

I have to cobnvert it to Xlsx file ,
right now i am using TxtLoadOptions separator {} to make the resulting file but How can i detect which delimiter is used
Is there any way to get delimiter from csv file using Aspose.cells


Thanks for your query.

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!