Split field data into 2 columns

[#1]

Hi

I have a field with data in with the following combination;

123456789Element Name

I want only the Element Name to show in a Calculated Dimension.

1. Numbers to be removed (no set count of number)

2. Only Element Name to be show

I'm guessing I will have to show all but numbers but am unsure how to do this.

Can anyone help please?

Andy

[swuehl · Accepted solution]

Try

Purgechar('123456789Element Name','0123456789')

[#3]

Do you want to keep the numbers? If not you could use the purgechar() function in the script to erase all number caracters form that field.

Otherwise, does the number part has the same length in all values?, If so you may use the right() function to show only the string part you want to show.

Hope it helps.

[rustyfishbones]

This Video on YouTube will help

Qlikview PurgeChar

http://youtu.be/vDZ8DIj1qcs