topic Re: qlik sense Automation substr with strrpos in Qlik Automate

qlik sense Automation substr with strrpos

rk23 — Tue, 25 Jun 2024 15:38:44 GMT

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

Re: qlik sense Automation substr with strrpos

salmankojar — Wed, 26 Jun 2024 07:07:14 GMT

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

Re: qlik sense Automation substr with strrpos

rk23 — Wed, 26 Jun 2024 15:43:39 GMT

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'}, '$([^)]*)$[^(]*$'}

Re: qlik sense Automation substr with strrpos

salmankojar — Thu, 27 Jun 2024 08:47:54 GMT

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