Answered

Remove the comma from the middle of a string

(0) Share

Report

Posted on by golfnutt82

1,362

Hello,
I have a SharePoint list and one of the columns in the list is a number column "VelocityAppID" and that column contains e.g. "111,111" in almost 1000 list items. I created another column with a string datatype, and I called it "txtVelosityAppID".
I would like to remove the comma from each value of "VelocityAppID" and then put the cleaned value into "txtVelocityAppID.
Any help is appreciated.

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @golfnutt82

You can use replace function in the form of expression to remove comma from the text. Here is an example:

replace(string('111,111'),',','')

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (0)

Report
Copy link

Link copied!

Hello Manish,
Thanks for the reply.
I will need to do this for each record in the list.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @golfnutt82

Yes, you need to get all items using "Get items" action from SharePoint list. Then iterate through the list using "Apply to each" action. In each iteration apply an expression to remove the comma from the int column. Finally use "Update item" action to push the final text in the new column.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No