Solved: keep everything to the right of the first hyphen

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

keep everything to the right of the first hyphen

Hi,

how can I use scan or subtr to keep everything to the right of the first hyphen?

var_have

2 - Some-what

4 - Very much

var_want

Some-what

Very much

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Posted 01-04-2018 05:52 PM (1234 views) | In reply to jenim514

Try

want_var=substr(var, index(var,'-')+1);

View solution in original post

1 REPLY 1

Tourmaline | Level 20

Posted 01-04-2018 05:52 PM (1235 views) | In reply to jenim514

Try

want_var=substr(var, index(var,'-')+1);