Replace with String Contains

[settu_periasamy]

Hi,

I need to replace the string based on between the values(like textbetween). see the example below.

Need to replace the String ': * |' as blank. (note :  '*' contains any length)

FieldOne: raja | FieldTwo: India | FieldThree: Calculated |

result should be :

FieldOne FieldTwo FieldThree

i tried the below expression

'=replace('FieldOne: raja | FieldTwo: India | FieldThree: Calculated |',':'&chr(42)&'|',' ')

Thank You.

[settu_periasamy]

It is working fine Daniel. But the problem is , Only three strings displayed.

Thank you. I'm closing this Discussion

[jagan · Accepted solution]

Hi Sethu,

Copy the string into a variable and use that variable in the expression.  If your string is dynamic like 4, 5 , 6 values then trying this in script is the best option.

Regards,

Jagan.

[settu_periasamy]

Ok Jagan. I will do like that.