@Diya.3rif BAS has internal function csv_parse, but it doesn't handle rows without commas.
So this won't work
Anyway there is regexp support, so you can process text very easy.
This regexp should work for you \"([^\"]+)\"
And here is project which solves your problem.
I fixed my problem by deleting the first row everytime Im done with it. So now I create a excel file, everytime script works on first row, it deletes it and second row becomes first one and works like that.
Yes I am doing this, although the typing to the form seems a bit slow for me when the text consists of a paragraph of maybe 100 characters. There seems to be a lag before the typing starts. Also, avoid the use of macro-enabled excel formats since BAS does not seem to be compatible with them.
@dreinyel said in How to extract information from txt or excel:
Guys, I made a script to auto fill some forms. This is great but the only thing is that I have to write manually what I want the scrpti to use. It's anoyiong because I already have it a text file or excel. Wante to know if theres a way the Bot just take all the info that it needs from a list of data-
Use the resource "LinesFromFile".