need to display textual values

[#1]

hi

i have a scenario in this i need to display numbers in one field and number+character combination in one field

1122

3344

1568

ww12

34rg

ww17

10kk

ttttt

in this i want to display 1122,3344,1568 in one field and remaining data in one field like that i have lot of data please help me to solve this problem

[arulsettu]

try this

KeepChar('ww12',0123456789) as number

PurgeChar('ww12',0123456789) as text

replace ww12 with your field

[tresesco · Accepted solution]

Load

          If( Isnum(trim(YourField)), YourField) as Numeric,

          If( Not Isnum(trim(YourField)), YourField) as AlphaNumeric

[#4]

thanks tresesco thank u so much