Unanswered

how to trim whitespaces in PAD

(0) Share

Report

Posted on by bensat2

Hi ,

1. i am tying to trim whitespaces in the excel data within Power automate desktop as sometimes the user enters 1123c and sometimes by mistake 1123c folowed by space.

2. In some case the data is AB_Package_1123 and some times it is IN_AB_package_1123. how to ensure both are read

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

You can use Trim text to trim whitespaces from a text string. That should be straightforward. But if you want to fix it in Excel, you will either need to read every value individually and write it back to Excel, or use Find and replace in Excel spreadsheet and replace whitespaces (%" "%) with nothing (%""%), assuming that is valid for all of the cells.

Not sure I understand the second question, though. What's wrong with it?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@bensat2
In case if you want to trim the data during iteration of excel datatable you can directly apply trim end of the currentitem variable like below
Else as @Agnius mentioned you can use trim action which is available in the text package.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report
@bensat2

Please use the below code for the same:

Code:
SET WebPageProperty3 TO $'''192.168.0.1''' Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Asset Details.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData LOOP FOREACH CurrentItem2 IN ExcelData IF WebPageProperty3 = CurrentItem2['IP'].Trimmed THEN Display.ShowMessageDialog.ShowMessage Title: $'''Info''' Message: $'''Trimmed''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report
Hi @bensat2 ,

If you have spaces at beginning and End of the string/input you can just use Trim Text Action directly as shown in below image 1:

Image 1:

If you want to remove spaces in between the text and start and end of text/input/string you can use the VBScript as shown in below image.
Please find the solution.

Code:
SET UserInput TO $'''IN_AB_ package_ 1123''' @@copilotGeneratedAction: 'False' Scripting.RunVBScript.RunVBScript VBScriptCode: $'''Dim str str = \"%UserInput%\" Set re = New RegExp re.Pattern = \"\\s+\" re.Global = True str = Trim(re.Replace(str, \"\")) WScript.Echo str''' ScriptOutput=> VBScriptOutput ScriptError=> ScriptError

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No