EasyXLS - View topic - Reading Text File: Delimiters for Rows and Columns?

View unanswered posts | View active topics It is currently Sat Nov 23, 2024 2:25 pm

Reading Text File: Delimiters for Rows and Columns?

Moderators: daniela, claudiu, oana

Page 1 of 1

[ 4 posts ]

Print view

Previous topic | Next topic

Reading Text File: Delimiters for Rows and Columns?

Author

Message

Dennis

Joined: Thu Mar 23, 2017 6:05 am
Posts: 3

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

Thu Apr 06, 2017 5:59 pm

Dennis

Joined: Thu Mar 23, 2017 6:05 am
Posts: 3

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

Sat Apr 08, 2017 10:24 am

daniela

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania

Re: Reading Text File: Delimiters for Rows and Columns?

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

_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook X Reddit LinkedIn

Thu Apr 13, 2017 2:24 pm

Dennis

Joined: Thu Mar 23, 2017 6:05 am
Posts: 3

Re: Reading Text File: Delimiters for Rows and Columns?

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

Very nice!

Thu Apr 13, 2017 4:59 pm

Page 1 of 1

[ 4 posts ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum