in reply to parse problem

Hi
You have already received good solutions.
Your algorithm should be:
A. split the data with the pattern . (pipe symbol in your case)
B. get the second item from the result of the above split.
Learn more about split.

artist