creating a new field from the text of an existing field

[hopkinsc]

Hi all,

if i have a field called NAME and the values for this field are

ADDAX1

ADDAX2

ADDAX3

BO1

BO2

BO3

BO4

TRF41

TRF44

how do i get just the text from this into a new field?

ie

ADDAX

BO

TRF

Thanks

[MK_QSL · Accepted solution]

Temp:

Load PurgeChar(NAME,'0123456789') as NAME Inline

[

  NAME

  ADDAX1

  ADDAX2

  ADDAX3

  BO1

  BO2

  BO3

  BO4

  TRF41

  TRF44

];

NoConcatenate

Final:

Load Distinct NAME Resident Temp;

Drop Table Temp;

[munna1317]

hi, use this function while loading

purgechar ( Name,'1234') as name

Regards,

harish