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

This works for me even if I use "Text (Multiple)" (example: forum.appian.com/.../121639)

Let's try this:

1. Use this expression only as seen in my example, notice how this time I am appending fn! before the word split to make sure it calls the out of the box function:

=fn!split(ri!text,char(126))

2. Copy and paste this input to make sure your text doesn't have any weird characters from an HTML page:

A~B~C

3. Click "Test Rule"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 11 years ago

This works for me even if I use "Text (Multiple)" (example: forum.appian.com/.../121639)

Let's try this:

1. Use this expression only as seen in my example, notice how this time I am appending fn! before the word split to make sure it calls the out of the box function:

=fn!split(ri!text,char(126))

2. Copy and paste this input to make sure your text doesn't have any weird characters from an HTML page:

A~B~C

3. Click "Test Rule"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data