qlik sense Automation substr with strrpos

[rk23]

Hi All

I am trying to get part of string using qlik automation job and its not working as expected 

basically I got a string like "  App name - (4fghj-efgh6) "  and want get App Id which is second part within bracket

and tried  like 

{substr: {$.inputs.'Choose App name'}, { strrpos: {$.inputs.'Choose App name'}, '(' } -1,{ textlength: {$.inputs.'Choose App name'} } - { strrpos: {$.inputs.'Choose App name'}, '(' } + 1}

but no output coming 

[salmankojar]

Hi @rk23 How you are getting the Input of App Name and id? you are manually entering it or getting it from Blocks?

[rk23 · Accepted solution]

Hi From Listapps then joining the app name and app id

I got this working now with reg expression as like

{regexparse: {$.inputs.'Choose App name'}, '\(([^)]*)\)[^(]*$'}

[salmankojar]

Hi @rk23 you can also use the AppID's by the method shown in attached Automation Json File.