Delete the blanks before and after the string
If you search for actions, you can often do what you want to do with drag and drop, but when you extract data from websites and on-premises software, you may come to data that is not originally necessary.
This time, I will explain how to delete the front and rear blanks from the acquired text data.
implemented with copy and paste
Copy the following code and paste it on the edit screen of Power Automate Desktop to add the target action.
Text.Trim Text: $'''%' ←Full -width blank half -width blank→ '%''' TrimOption: Text.TrimOption.Both TrimmedText=> TrimmedText
Operate and implement Power Automate Desktop
Enter "Text Trimming" from "Action Search" and set the property as follows.
Parameter name value Textbooks to trim The target variables and the character string enclosed by %''% Total target You can choose both, only the lead, the end
When executed, a string where the blank is removed from the target text is returned.