what am I doing wrong?

diwaskarki — Sat, 16 Nov 2024 21:40:46 GMT

I am extracting the string in between the string tags from the below xml.

This is the script I am using:

IF (ACTION = 'Remove Role Access', TextBetween(Replace(Replace(Replace(Replace(ATTRIBUTES,chr(10),' '),' ', ''), '<String>', ''), '</String>', chr(10)), '<entrykey="RemovedAccess"><value><List>', '</List>')) As [Removed Roles]

However, all the spaces in between the string is replaced with non space. In the script, when I replace the non space with space, it does not work. Script runs but does not bring in anything. Any help would be appreciated. Thanks .

Re: what am I doing wrong?

uacg0009 — Wed, 02 Jan 2019 09:03:58 GMT

Hi Diwaskarki,

I think you can try to use textbetween first, like:

IF (ACTION = 'Remove Role Access', Replace(Replace(Replace(TextBetween(ATTRIBUTES,'<entry key="Removed Access">','</List>'),'<value>' & chr(10) & '<List>',''),'<String>',''),'</String>','')) As [Removed Roles]

Please try.

Aiolos Zhao

Re: what am I doing wrong?

diwaskarki — Wed, 02 Jan 2019 21:10:15 GMT

that did not work.

topic what am I doing wrong? in App Development

what am I doing wrong?

Re: what am I doing wrong?

Re: what am I doing wrong?