Identify Number and strings

[anuradhaa]

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]

HI,

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

Regards,

jagan.

[jagan]

One more method

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

Regards,

Jagan.

[settu_periasamy]

Can you give some sample data?

May be like this..

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

[jonathandienst]

Please provide some sample values and your desired output.