How to separate the column having multiple data types in qlikview

[Anonymous]

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,

[sunny_talwar]

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)

[luke1986]

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.

[Anonymous]

Thank you .It did give me only those +44 numbers.

[Anonymous]

Thanks sunny.

It is pulling the 44 numbers but some weird behavior is throwing on the table.

cant understand what am i doing wrong.