troubleshooting Question

vbscript - detect word

Avatar of ferrarista
ferrarista asked on
VB Script
4 Comments1 Solution110 ViewsLast Modified:
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
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros