How to flag data using left/right contains formula

I need to make a formula that flags whitespaces in a column of data and then have a second column output that has a marker/some sort of flag next to the data that has trailing whitespaces.

I tried using an IF CONTAINS formula but I keep messing it up. Any idea on how to write this formula?

The column I am pulling from is just titled "Info". and the second column that I want the markers to be can be called "whitespace"

Workflow

Output

Expression

Accepted answers

All comments

BS_THE_ANALYST

Have you got some mock input data? 😊

slaurel

@BS_THE_ANALYST Yes. Column header is Info and under it can be

aaa

777

fdr

It really doesn't matter. The data can be a variety of numbers, decimals, letters. I just need a column to flag which ones have whitespaces (before and after), so I would use the contains left / contains right formulas (I think)

BS_THE_ANALYST

I came up with this. Does this tackle the issue?

FlaggingLeadingorTralingWhitespace.yxmd

Felipe_Ribeir0

Hi @slaurel

If i understood your problem well, it can be solved just by using left and right functions like these:

leftright.yxmd

Felipe_Ribeir0

@BS_THE_ANALYST , for this case i understood that it does not matter if you have 1 or many spaces as long as they are before or/and after the characters.

BS_THE_ANALYST

@Felipe_Ribeir0 you're right. Over complicated it. LEFT/RIGHT paired with searching for a single space will satisfy all leading/trailing space cases, regardless of length.

@slaurel see @Felipe_Ribeir0 's answer. Much more simplistic.

Nevertheless, Regex > 😂.

Felipe_Ribeir0

@BS_THE_ANALYST regex is insanely useful, so its a good idea to look at your answer too and understand why both approachs works!

As you said, maybe for this simple case the left/right can deal with the problem, but surely soon he will get a case where he will need regex 😅

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703