Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI,
if(Not IsNum(Left(Mid(tId,2),1)),tId) as string,
Regards,
jagan.
One more method
if(Not IsText(Left(Mid(tId,2),1)),tId) as string,
Regards,
Jagan.
Can you give some sample data?
May be like this..
KeepChar(tId,'0123456789') as Num1,
KeepChar(Lower(tId),'abcdefghijklmnopqrstuvwxyz') as Text
Please provide some sample values and your desired output.