Unanswered

Replace multiple characters with specific characters in a string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a requirement where I need to replace multiple characters with specific replacement characters in a string.

Example: Replace '#25' with 'String 1', Replace '#35 with 'String xyz' and and so on. The mapping will be stored in a SharePoint list. the characters can occur any number of times in a single string, so, I need to identify them, get the correct mapping/replacement character from the SP list and replace it.

Example of a string: "quick#25brown#35fox" ==>Should become 'quickString 1brownString xyz' after replacement.

What would be the efficient way to do the replacements in the String? I tried a quite a bit and could not find a solution yet. Any help would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

David_MA 14,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You can stack the expressions for multiple replaces such as:

replace(replace(replace(body('column_name'),'#25','String 1'),'#35','String xyz'),'Third replace','and so on')

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks David_MA. This would definitely work, but the challenge is to detect the pattern (can be more than one in a string), retrieve the corresponding replacement from a SharePoint List and do the replacements.

Was this reply helpful? Yes No