Replacing field or table content

[leo88]

Hey guys,
I would like you to help me with a script. I need to create a column by replacing the textual content from another existing column, for example:

Coke 2L ---> 2L
Sugar 1KG ---> 1KG
Flour 5KG ---> 5KG
.... 
Can you guide me how to implement this? I believe I have to replace the letters until I get the goal, but I don't know how to start. Thanks.

[Vegar]

This is a duplicate post identical to https://community.qlik.com/t5/Qlik-Education-Discussions/Replacing-field-or-table-content/td-p/19062...

I gave  a suggestion to you for solution in the other thread.