Space Delimiter

Aspose.Cells Product Family
1

We are currently running Apose.Cells v 7.2.2.0. Is it possible in this or any newer version to use a blank space as a delimiter with which to split a file?

i.e. this would split into 4 records?

John Smith "123 abc lane" 111-222-3333

2

Hi,

Thanks for using Aspose.Cells.

Please use the following code with the latest version: Aspose.Cells
for .NET v8.0.0.1 and it works as expected.

The code loads the text with space as a delimiter and convert it to xlsx format. I have attached both the input and output files for your reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\sample.txt”;


TxtLoadOptions opts = new TxtLoadOptions();

opts.Separator = ’ ';


Workbook workbook = new Workbook(filePath, opts);

workbook.Save(filePath + “.out.xlsx”);