Remove extra comma from variable data using Power Automate Desktop.

(0) Share

Report

Posted on by NeerajYadav Microsoft Employee

Hi All,

I have data in ResultFile variable. There is a extra , after Also as highlighted in the data section.

Now just i want to remove , after Also word and store the data into a variable using Power Automate Desktop.

Other , should be remain.

Please help on this.

SET ResultFile TO ResultFile1

Data

DD, 3/25/2021
Summary ,RowsCount
--------------------------,-----------
Total count:,29406
count reached.,4513
address,15752
count reached. Also, block,8739
unsuppressed:,402
-------------------------,----

Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#replace

Was this reply helpful? Yes No
NeerajYadav Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for reply, But this is not solution.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

Why not? You replace Also, with Also

Was this reply helpful? Yes No
NeerajYadav Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Also, is not fixed. In other record word Also, can be change.
I want to remove first , only.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you even have a look at the documentation? Replace text is still the solution!

Regular expression: (\.[\s\w]+?),
https://regex101.com/r/AkJxCp/1

Replace with: $1

Was this reply helpful? Yes No