topic Re: Split field data into 2 columns in QlikView

Split field data into 2 columns

Mon, 01 Jul 2013 15:07:44 GMT

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

Re: Split field data into 2 columns

swuehl — Mon, 01 Jul 2013 15:20:17 GMT

Try

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

Re: Split field data into 2 columns

Mon, 01 Jul 2013 15:20:17 GMT

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.

Re: Split field data into 2 columns

rustyfishbones — Mon, 01 Jul 2013 19:53:37 GMT

This Video on YouTube will help

Qlikview PurgeChar

http://youtu.be/vDZ8DIj1qcs