How to put this in Write cell

How to put this in Write Cell?

“=IFERROR(MID(D5,FIND(”""+strText+""",D5)+0,FIND("""+strTry+""",D5)-FIND("""+strText+""",D5)+0),FIND("""+strCheck+""",D5)-FIND("""+strText+""",D5)+0))"

Hi,

Your expression seems no problem. Do you have any issue?

img20211124-8

Regards,

Hello @Yoichi

Yes, see attached images

Hi,

Oh, It was runtime error.
Can you try the following due to extra parenthesis.

"=IFERROR(MID(D5,FIND("""+strText+""",D5)+0,FIND("""+strTry+""",D5)-FIND("""+strText+""",D5)+0),FIND("""+strCheck+""",D5)-FIND("""+strText+""",D5)+0)"

Regards,

Hello @Yoichi

I tried your formula. It’s working. But the result is not correct.

Normally, in excel, it should be like this formula.

=IFERROR(MID(D5,FIND(“Text”,D5)+0,FIND(“Try”,D5)-FIND(“Text”,D5)+0),MID(D5,FIND(“Buyer”,D5)+0,FIND("Check,D5)-FIND(“Text”,D5)+0))

Hi,

The above is not same as your first expression. Do you still have issue? If you have, can you share current expression in UiPath?

“=IFERROR(MID(D5,FIND(”""+strText+""",D5)+0,FIND("""+strTry+""",D5)-FIND("""+strText+""",D5)+0),FIND("""+strCheck+""",D5)-FIND("""+strText+""",D5)+0))"

Regards,

Hello @Yoichi

Yes Im still having issues. I want to get the value for “Buyer”

Result: Buyer: JamesRam Mobile

=IFERROR(MID(D5,FIND(“Buyer”,D5)+0,FIND(“Seller”,D5)-FIND(“Buyer”,D5)+0),MID(D5,FIND(“Buyer”,D5)+0,FIND(“Last Update”,D5)-FIND(“Buyer”,D5)+0))

James Johnson;Target: JamesTower, Inc.Buyer: JamesRam Mobile, Inc.Last Update: November 22, 2021Announce Date: October 15, 2021Effective Date: October 15, 2021Deal Number: 4072588Transaction SummaryDeal Type:Minor

Hi,

It seems not UiPath matter but Excel formula matter… And it’s difficult to find your issue from the above information. If you can share workbook, it might help to solve the issue.

Regards,