Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
maxloveiii
New Contributor III

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

View solution in original post

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

View solution in original post