How to retrieve letters only from given names which is mixed with numbers

                         Input

                Note that the input data has numbers mingled in it. So, we need to separate those numbers and letters apart and place them into two different columns. 

         In the tMap, we have to give the expression to replace all characters and numeric values with no space ("") as given below.

    Therefore, the final output with the separated customer number and customer names was obtained. 

Thank you very much.