Forum Discussion

prajaktakeni11's avatar
prajaktakeni11
Icon for Helper I rankHelper I
2 years ago
Solved

Find a text with and without space

Hello , I want to filter text column which includes "tag within sale" , So I have used Search fucntion for it  however my data is not structured so it includes "tag   within  sale " (Data with spac...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi prajaktakeni11 

     

    Here is my testing:

     

    My sample:

     

    I created a calculated column as follows.

    Column 2 = 
VAR _space = IF(CONTAINSSTRING('Table'[column], " "), 1, 0)
RETURN
IF(_space <> 0, "within space", "without space")

     

    And then put this column into the slicer.

    Is this the result you expect?

     

    Best Regards,
    Community Support Team _Yuliax

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi prajaktakeni11 

 

Here is my testing:

 

My sample:

 

I created a calculated column as follows.

Column 2 = 
VAR _space = IF(CONTAINSSTRING('Table'[column], " "), 1, 0)
RETURN
IF(_space <> 0, "within space", "without space")

 

And then put this column into the slicer.

Is this the result you expect?

 

Best Regards,
Community Support Team _Yuliax

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • prajaktakeni11's avatar
    prajaktakeni11
    Icon for Helper I rankHelper I
    2 years ago

    Anonymous Thank you for your reply , but I am not looing for this soultion I want both (with and without space should be considered as one value)