topic String query in QlikView

String query

ralph_graham — Fri, 17 Oct 2014 14:38:06 GMT

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

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 — Fri, 17 Oct 2014 14:40:26 GMT

load

field,

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

....

alexandros17 — Fri, 17 Oct 2014 14:42:21 GMT

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

let me know

jpenuliar — Fri, 17 Oct 2014 14:53:03 GMT

Hi,

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