How to paste complex excel formula using set cell value

[VinayMurthy]

Hi I need some help on below scenario:
I need to paste the following formula to an excel but it not considered as text
=RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,"|","#",LEN(A1)-LEN(SUBSTITUTE(A1,"|","")))))

What is the escape character in BP?

 

[VJR]

Hi I need some help on below scenario:
I need to paste the following formula to an excel but it not considered as text
=RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,"|","#",LEN(A1)-LEN(SUBSTITUTE(A1,"|","")))))

What is the escape character in BP?

Hi VinayMurthy,

Check by replacing single double quotes with two double quotes (Post #8)

 

[VinayMurthy]

Hi VinayMurthy,

Check by replacing single double quotes with two double quotes (Post #8)

Thank you VJ it's working,
I have a text in the collection like :
2008 | Month | Address | Data | Name

So I need only the last value coming after the de limiter "|" symbol. What would be the best approach.. tried with split option but its gives column wise for each record in the collection....

 

[VJR]

Thank you VJ it's working,
I have a text in the collection like :
2008 | Month | Address | Data | Name

So I need only the last value coming after the de limiter "|" symbol. What would be the best approach.. tried with split option but its gives column wise for each record in the collection....

I am assuming you are mentioning that you have one string (inside the collection) in the format as 2008 | Month | Address | Data | Name and you need to fetch the Name.

For this you can do a InstrRev (Utlity strings) on the text and find out the last position of the | and then using other string functions fetch the Name.