Import TAB delimited file into MSStringGrid

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
DummyUser100
Newbie
Posts: 1
Joined: Wed Oct 11, 2017 6:30 pm

Import TAB delimited file into MSStringGrid

Post by DummyUser100 » Thu Oct 12, 2017 8:35 am

Hello
I have just a short question. I want to import a CSV-File ( TAB or semicolon delimited) with

Code: Select all

 SetDialogProperty>Dialog1,MSStringGrid1,LoadFromCSV,insertFile 
The problem is that by default space is used as delimiter. How can I change the delimiter ?

Thanks

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Import TAB delimited file into MSStringGrid

Post by Marcus Tettmar » Thu Oct 12, 2017 9:30 am

Not really sure what you mean. In my tests LoadFromCSV can work with comma, spaces or TABs as the delimiter. However, if your file has a delimiter that isn't supported you could do a StringReplace (or RegEx replace) on it before loading to the string grid.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts