Write Cell Formula Error

[odure]

Hey friends, I hope we are well. I needed some help on writing excel formulas in the write cell activity- kindly assist with these if you can.

“=LEFT(C3,SEARCH”+(CHR(34)+CHR(34)+“,C3)-1)”

“=SUBSTITUTE(SUBSTITUTE(K3,“USh”,”“),”,“,”“)”

“=SUBSTITUTE(SUBSTITUTE(N3,“USh”,”“),”,“,”“)”

Kindly help,
Many thanks

Emmanuel O.

[HainTavuk (Kadir Elgün)]

you should write two " instead of one in formula string
for example: “=SUBSTITUTE(SUBSTITUTE(K3,”“USh”“,”“”“),”“,”“,”“”“)”

[Sudharsan_Ka]

HI @odure

Can you check with this one

“=LEFT(C3,SEARCH”+“(CHR(34)+CHR(34)”+“,C3)-1)”

Regards
Sudharsan

[odure]

Awesome,many thanks,this one worked

[odure]

@HainTavuk

“=SUBSTITUTE(SUBSTITUTE(K3,”“USh”“,”“”“),”“,”“,”“”“)”

This also worked Sir,my sincere appreciation,many thanks.

[odure]

@Sudharsan_Ka

=LEFT(C3,SEARCH”+“(CHR(34)+CHR(34)”+“,C3)-1)

Friends I keep getting this error in the excel report itself…

[Sudharsan_Ka]

Write this formula manually in the excel and check whether it is throwing same error @odure

[odure]

Yes its bringing the same error when manually entered.

[odure]

When I enter this =LEFT(C3,SEARCH(" ",C3)-1) - it works in Excel but in Studio,this formula throws an error.

[Sudharsan_Ka]

Try this @odure

“=LEFT(C3,SEARCH(”" “”,C3)-1)"

Regards
Sudharsan

[odure]

This has worked thank you.