topic Regular expression in qlikview in QlikView

Regular expression in qlikview

anuradhaa — Fri, 05 Feb 2016 05:20:31 GMT

I use below syntax to get ids from text

trim(TextBetween(text, '#', ' ')) as ID

but my text has two types

#21561666 testhggg

and

#8585858

when i use above expression i only get #21561666 testhggg values but i need both

any idea

Anonymous — Fri, 05 Feb 2016 05:30:50 GMT

Could you elaborate more, what is your expected output?

May be PurgeChar(), KeepChar() help you?

tresB — Fri, 05 Feb 2016 05:37:51 GMT

Try to share few more sample values and corresponding expected output. That would help us find a logical pattern and help you write the expression.

avinashelite — Fri, 05 Feb 2016 05:47:50 GMT

please share the sample data and out format required so that it will helpful for us suggest a solution

jagan — Fri, 05 Feb 2016 05:56:09 GMT

Hi,

Try like this

trim(TextBetween(text & ' ', '#', ' ')) as ID

OR Try

KeepChar(text , '#1234567890') AS ID

Hope this helps you.

Regards,

jagan.