Answered

EXTRACT DATA FROM THE WEB PAGE - SAVE IN EXCEL

(0) Share

Report

Posted on by adrianorsene

Friends,

I am extracting a text from a web page and using that text to rename an Excel spreadsheet. However, the extracted text, for example, "198.457115/2023," contains characters that Excel does not accept, such as ("/").

Is there a way, at the moment I extract the text, to eliminate the "/" character?

Because of this issue, my workflow is encountering an error.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Use Replace text to replace the slash character with nothing by using %""% as the text to replace it with. Then use the result of this action for the file name.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

AK88 453 on at

Like (1)

Report
Copy link

Link copied!

Dear @adrianorsene ,

Please try to use 'replace action', then consider that the Replace variable applies to on 'Rename file ' action. For more reference please check attached screenshot.

If my answer provides solution to your query , please mark this as accepted.

Was this reply helpful? Yes No
adrianorsene 9 on at

Like (0)

Report
Copy link

Link copied!

Thanks Agnius, it worked!

Was this reply helpful? Yes No