You’re offline. This is a read only version of the page.
i have a large string that is a result of a http call. This string is '@' separated, but within each item in the string i have multiple occurrences of commas that i will like replaced by just a simple comma.
An example of the string is "Flat 1, Society Court,,,Aberdeen,Scotland@Flat 2, Society Court,,,Aberdeen,Scotland"
Basically i want this String to be in this format "Flat 1, Society Court,Aberdeen,Scotland@Flat 2, Society Court,Aberdeen,Scotland"
After which i can then split the text and store the results in a collection. This is what i have so far
ClearCollect(col_addresses, Split(Substitute(var_text,Match(var_text,"[,]{2,}").FullMatch,","),"@") )
What i have tried to do is find any matches in the string where there are multiple commas, and then replace them with a single comma, i then split the result. When i check the collection i just get the split on the original string with the commas still as they were.
it seems the Match function may not do the job or am i doing something wrong. Any ideas?
You can put this string in a Text Input called TextInput1
Share
Report
All responses (
Answers (
Flat 1, Society Court,,,Aberdeen,Scotland@Flat 2, Society Court,,,Aberdeen,Scotland
Then put this code in another text label
Left(
Concat(Filter(Split(TextInput1.Text,","),!IsBlank(Result)),Result&","),
Len(Concat(Filter(Split(TextInput1.Text,","),!IsBlank(Result)),Result&","))-1
)
Your result will look like this.
Flat 1,Society Court,Aberdeen,Scotland@Flat 2,Society Court,Aberdeen,Scotland
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
#1
WarrenBelz
982
Most Valuable Professional
#2
MS.Ragavendar
396
Super User 2025 Season 2
#3
Power Apps 1919
356
