Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need to display textual values

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

1 Solution

Accepted Solutions
tresesco
MVP

Load

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

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

View solution in original post

3 Replies
arulsettu
Master III

try this

KeepChar('ww12',0123456789) as number

PurgeChar('ww12',0123456789) as text

replace ww12 with your field

tresesco
MVP

Load

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

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

Not applicable
Author

thanks tresesco thank u so much