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

Use the split() function passing ~ as the delimiter.

For this and other text functions review Appian Documentation at forum.appian.com/.../Text_Functions

Hi Eduardo,
Using split function gave me error:
EVAL:Invalid type@reason=Type Error: Invalid Character String: Cannot validate type (value in wrong format

split(ri!text,"~")

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

split(ri!text,char(126))

Even this did not work for me. My input is text multiple. That is why it is not working. Is there any function that works for multiple text input?

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"

Eduardo, I am getting the same result. I am using your expression and your test input but getting same error.

When I make Input single, it work but when multiple it gives error.

1. What Appian version?
2. Does your example look lime my screenshot when it's set to "multiple"?