topic Identify Number and strings in QlikView

Identify Number and strings

anuradhaa — Fri, 05 Feb 2016 03:52:21 GMT

HI,

One column contains strings and numbers. i want to group them and store two separate colums as number and string

I know how to do this with numbers

if(IsNum(Left(Mid(tId,2),1)),tId) as num,

but how can i extract strings?

jagan — Fri, 05 Feb 2016 03:54:30 GMT

HI,

if(Not IsNum(Left(Mid(tId,2),1)),tId) as string,

Regards,

jagan.

jagan — Fri, 05 Feb 2016 03:55:16 GMT

One more method

if(Not IsText(Left(Mid(tId,2),1)),tId) as string,

Regards,

Jagan.

settu_periasamy — Fri, 05 Feb 2016 04:41:47 GMT

Can you give some sample data?

May be like this..

KeepChar(tId,'0123456789') as Num1,
KeepChar(Lower(tId),'abcdefghijklmnopqrstuvwxyz') as Text

jonathandienst — Fri, 05 Feb 2016 05:02:04 GMT

Please provide some sample values and your desired output.