Grab data from text file

[Directlinq]

Grab data from text string

I have a text string of
# akon - dance
How can i parse before the - without the # into one variable and after the - into another variable?
Many Thanks

 

[Directlinq]

No one got any ideas?

 

[Volvo]

Maybe the function ParseWord may help...
Get more informations here.

Good Luck!

 

[Directlinq]

I cant get it to grab all the text before the - just individual words as some of the lines in the text file have more than one word.

 

[DCrake]

Can you give a couple of examples of before and after using the best to worse case senerio.

David