EasyXLS
http://forum.easyxls.com/

Reading Text File: Delimiters for Rows and Columns?
http://forum.easyxls.com/viewtopic.php?f=9&t=2224
Page 1 of 1

Author:  Dennis [ Thu Apr 06, 2017 5:59 pm ]
Post subject:  Reading Text File: Delimiters for Rows and Columns?

Hi,

I try to use .easy_ReadTXTFile_AsDataSet which requires values for both row and column delimiters.

Where can I read more about these parameter's values?

TIA,
Dennis

Author:  Dennis [ Sat Apr 08, 2017 10:24 am ]
Post subject:  Re: Reading Text File: Delimiters for Rows and Columns?

I managed to resolve the issue:

Code:
Dim dsData As DataSet = txtFile.easy_ReadTXTFile_AsDataSet(DocumentsPath + "\Excel Files\ReportData.txt", vbNewLine, vbTab)


However, I would still like to see the available values for future references.

TIA,
Dennis

Author:  daniela [ Thu Apr 13, 2017 2:24 pm ]
Post subject:  Re: Reading Text File: Delimiters for Rows and Columns?

You can use any string values as delimiters, including multiple chars, like "***", "---", "anything".

Author:  Dennis [ Thu Apr 13, 2017 4:59 pm ]
Post subject:  Re: Reading Text File: Delimiters for Rows and Columns?

Thanks, that's indeed great as it gives great flexibility.

Very nice!

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/