How to replace bits of a string that contains new lines?

(0) Share

Report

Posted on by Gilariel1

Hi there!
I have a string that's coming from a cell in excel that contains multiple lines like so:

Line 1 what the beep?

Line 2 beep boop bap.

Line 3 hello beep.

How do I replace all instances of 'beep' with 'hello'?

I've tried everything I can think of and no luck so far 😞 The normal replace function doesn't seem to do it, and my javascript attempts don't even return anything?

function ExecuteScript() { 
 var res = %ExcelCellContents%.replace("WORKBOOKS", "red");
 WScript.echo(res);
}

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Gilariel1

If you want to replace the text directly in Excel then you can use Find and replace cells in Excel worksheet action.

But if you want a string function then the Replace Text works perfectly fine.

After running the process, the replaced words are as highlighted below.

Was this reply helpful? Yes No
Gilariel1 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response VJR.
Yes if I just use a string variable like you did then it works, but if I pull that from the excel cell (like I need to do) it doesn't work for some reason? Any ideas?

Last time I tried the excel find and replace it also didn't work with newlines in cells unfortunately. But maybe this has changed in 2022?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Make sure to disable entire cell contents.

Was this reply helpful? Yes No
Gilariel1 18 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks, this was very helpful.
I got this to work with individual words and very short phrases, but not with paragraphs. I think maybe there's a max limit to how much text you can replace at once (this seems to be the case even in Excel's native find and replace too from what I can see!), so I think that's where I was going wrong too.

Thanks so much for your help.

Was this reply helpful? Yes No