Text search, match, and group

[#1]

Example: Column 1 is my description and Column 2 is my grouping. How can I set a certain condition where it can differentiate what I'm grouping by from Column 1?

Column 1          Column 2       

1k                    k

1k                    k

1k                    k

2b                    b

2b                    b

2b                    b

2b,1k               bk

2b,1k               bk

2b,1k               bk

Any help would be appreciated.

[swuehl]

Maybe like

LOAD

   Column1,

   PurgeChar(Column1,'0123456789,') as Column2

FROM ...;