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

rishub over 10 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 Eduardo Fuentes
Appian Employee
over 10 years ago

That works for me but let's use this one instead to see if that works better for you

split(ri!text,char(126))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

That works for me but let's use this one instead to see if that works better for you

split(ri!text,char(126))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data