I have a string that contains e.g. “Value * Value” or “Value 2 * Value”.
I would like to remove any text after the “*”. What is the best way to achieve this?
I have a string that contains e.g. “Value * Value” or “Value 2 * Value”.
I would like to remove any text after the “*”. What is the best way to achieve this?
@jon1302 String Split method
Str=“value 2 *value1”
Str.Split({*},StringSplitOptions.RemoveEmptyEntries)(0)
Output: value 2
Thanks, receiving an error: “Expression expected”. Do i need to convert the string to an array first?
Within the Update Invoice Data sequence:
FAME Validation.xaml (30.0 KB)
Hi @jon1302
You can try the below expression
For this formula, if you provide “Value 1 * Value 2”, it will split the string from “*” and return “Value 1”. Since I have added the Trim, it will remove spaces at the end as well.
I guess this is the best way to handle it…
Let know how it goes for you
Your genius strikes again! Thank you so much for your help Lahiru!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.