Get Characters from Inside String Between Symbols

[thec0dy]

6156661199 [ Mike Jones ] TEST1, NAME1 (3_15_2013).pdf

I have a string like the one above. I need to get three more elements out of this string.
1. DName which would be anything between the brackets [ ] as in Mike Jones
2. PName which would be anything after the ] bracket and before the ( parenthese as in TEST1, NAME1.
3. Date which would be anything between the ( ) parenthese as in 3_15_2013.

 

[jges]

You can use the InStr function to find the positions of the "[", "]", "(", and ")" characters. With this information you can use the Mid function to extract portions of the string between those positions.

 

[thec0dy]

Great thanks!

 

[ChrisHirst]

Or use Regular Expressions.

\[.*\] would match between brackets (the name)

\].*\( between a closing bracket and an opening paranthesis (TEST,NAME)

\(.*\) the text inside paranthesis (date)

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[PHV]

Or use the Split function:
aString="6156661199 [ Mike Jones ] TEST1, NAME1 (3_15_2013).pdf"
DName = Trim(Split(Split(aString,"[")(1),"]")(0))
PName = Trim(Split(Split(aString,"]")(1),"(")(0))
theDate = Trim(Split(Split(aString,"(")(1),")")(0))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886