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/