Hints, tips and tricks for newbies
Moderators: Dorian (MJT support), JRL
-
DummyUser100
- Newbie
- Posts: 1
- Joined: Wed Oct 11, 2017 6:30 pm
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
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
-
Contact:
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.