How to filter out hide/remove number values only in List Box

[#1]

Hello,

New to Qlikview. I was given a query for taking Excel data and separating out numbers from within the values (e.g., 5G;#1, CAPLAIN;#2, etc.):

table1:

load * from table1;

RecordTagsFromTable1:

load KeyWords, subfield(purgechar(KeyWords, '#'), ';') as RecordTag resident table1;

The results produced a list box that separated word values from the number values:

List Box:

5G

CAPLAN

AMI

1

2

3

Is there a way to remove the numbers and just keep the text values?

[vinieme12]

table1:

load * from table1;

RecordTagsFromTable1:

load KeyWords, subfield(KeyWords, ';' , 1) as RecordTag resident table1;

[vinieme12]

what exactly does the data look like!!