String query

[ralph_graham]

Hello,

I'm trying to remove values before a certain character in a field, see example below:

Current field value

101 - 204

10 - 304

20 - 30

What I want to see is

204

304

30

So in other words I want to remove all values before a hyphen so that the last few values are shown.

Any suggestions?

Thanks,

Ralph

[maxgro · Accepted solution]

load

          field,

          subfield(field, '-', 2) as newfield,

          ....

[alexandros17]

Trim(Mid(myField, Index(myField,'-')+1))

let me know

[jpenuliar]

Hi,

Try =Right(testfield,Index(testfield,'-')-1)