Comparing string ignoring spaces

(0) Share

Report

Posted on by KDAI

172

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 Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

try modify your Filter function:

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

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No