Solved Extract substing from string

andrea93

Member
Hi,
i have a string of text (es. 123456 - 3 - Simon Red)
I have to extract "Simon Red". The strings' lenght until second "-" is variable. (es. 123456 - 10 - Simon Red)
How i can do? Ideas?

Thks
 

VJR

Well-Known Member
Staff member
Thaks so much

Curiosity: if i want take first "-"?
For finding the first position of a string within another string the Instr function is used. So Instr will determine the position of the first "-".
 
Top