Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am getting a column from the database which has got some text(description) and some telephone numbers like one starts with +44.... and some numbers starts with 07......
How can I get only +44 numbers into the chart which is my requirement.
Any help is much appreiciated.
regards,
Vamsi,
May be like this
Concat({<[Message Endpoint] = {'+44*'}>} [Message Endpoint])
or add [Message Endpoint] as dimension and then this as your expression
Avg({<[Message Endpoint] = {'+44*'}>} 1)
Put this in Load Script:
...
if(left(trim(Message_Endpoint),3)='+44',Message_Endpoint,null()) as Message_Endpoint
....
then you only get all +44 Phone numbers.
Thank you .It did give me only those +44 numbers.
Thanks sunny.
It is pulling the 44 numbers but some weird behavior is throwing on the table.
cant understand what am i doing wrong.