Parse a String

[DataPirate26]

Hello I want to Parse the Filename from the String provided. So the string would be -  "00083B","Kelly TaxView Parent 01",",","TA_EXPORT","M". I want to parse out - Kelly TaxView Parent 01.

Can someone assist me out with this. 

[cmcclellan · Accepted solution]

Text to Columns would do that, and then remove the "

BUT .... is that really what you're loading ?  It just looks like a CSV file with quoted values, which can be read in and the quotes removed easily.

[binay2448 · Accepted solution]

Find attached solution ....

[DataPirate26]

This worked perfectly. Thanx