Link to home
Create AccountLog in
Avatar of ferrarista
ferrarista

asked on

vbscript - detect word

Hi guys,

I have a csv file that has three words within quotes and separated by coma.

"word1", "word2", "word3".

these words can have different lenghts, but I need to retrieve the third one, without the quotes.
I have already identified the correct line (because the csv file could have many lines), but once I identify the line containing the word I need (which is actually the first one), I need to collect the third one. Do I need a regular expression ?
How could I accomplish that ?

Thanks!!
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ferrarista
ferrarista

ASKER

But I'm using a plain text file, not excel.... would that work ?
Open csv in Excel. change the cell and save it. Then re-open in text file, that will be gone.
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.