I have a value like "A1~B2~C3" in a multiple PV. Now I want to convert

rishub over 11 years ago

I have a value like "A1~B2~C3" in a multiple PV. Now I want to convert into multiple values like "A1; B2; C3" so that I can treat them as 3 different values. I used substitute function to show it as "A1; B2; C3" but it still counts it as single value. How can I get it as multiple values?

Thanks...

Discussion posts and replies are publicly visible

Parents

0 rishub over 11 years ago

split(ri!text,"~")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rishub over 11 years ago

split(ri!text,"~")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data