Comparing string ignoring spaces

(0) Share

Report

Posted on by KDAI

143

I have a filter function for a collection

Filter(
    testlist,
    DestDistrict = Trim(varcurrentitem.SourceDistrict)
)
 
the problem i have is the DestDistrict has an extra space in between values like 
 
Wes t Virgini A 
 
now the source district has 
West Virginia
 
how do compare these two values ignoring the spaces in-between or leading
I just want to match the characters only. 
WestVirginia= WestVirginia
 
 

Categories:

Power Platform Build Tools

All responses (2)

Answers (1)

ronaldwalcott 1,026 on at

Like (0)

Report

Comparing string ignoring spaces

For efficiency you could use a With and something like

With({_stringToCheck:Substitute(Trim(varcurrentitem.SourceDistrict), " ", "")},

Filter(
testlist,
Substitute(DestDistrict, " ", "") = stringToCheck
))

and remember delegation issues may occur depending on the collection size
Verified answer

SaiRT14 1,278 on at

Like (0)

Report

Comparing string ignoring spaces

try modify your Filter function:

Filter(
testlist,
Substitute(DestDistrict, " ", "") = Substitute(Trim(varcurrentitem.SourceDistrict), " ", "")
)