Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

maxloveiii
New Contributor II

How to remove dynamic string

How to remove dynamic string in format '{*ABC234*}' like this.

EG

'TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

'

.......

(Any records  may be haven't the dynamic strings)

Remove red colour

I try to used "Replace" function

EG

Replace('TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

','{'&TextBetween('TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

','{','}')&'}','')

But it not work

Result : TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

Please provide for this problem.

MaxloveIII

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to remove dynamic string

See here for a solution. The discussion is about html tags, but it's the same problem. Just replace the < and > characters with your curly braces


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: How to remove dynamic string

See here for a solution. The discussion is about html tags, but it's the same problem. Just replace the < and > characters with your curly braces


talk is cheap, supply exceeds demand
Community Browser