Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you elaborate more, what is your expected output?
May be PurgeChar(), KeepChar() help you?
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.
please share the sample data and out format required so that it will helpful for us suggest a solution
Hi,
Try like this
trim(TextBetween(text & ' ', '#', ' ')) as ID
OR Try
KeepChar(text , '#1234567890') AS ID
Hope this helps you.
Regards,
jagan.