Help with conditional formula / extraction

[AjaySetty]

Hello Masters,

I have the below data set example where C is the resulting output I need, out of the A & B column i want to select data which has values into C.

Please help.

A	B	C
R	2015-10070	2015-10070
2013-10049	D	2013-10049
A	2018-00261	2018-00261
2018-00113	F	2018-00113
2019-00118	J	2019-00118
A	2012-10014	2012-10014

[marcusblackhill]

Hey @AjaySetty !

Well, depend of the table rules I think, but with data like that you can just concatenate both columns and then remove any letter inside the column like in that example attached.

Hope that help! 

[atcodedog05]

Hi @AjaySetty 

Here is a workflow for the task.

Formula:

if REGEX_Match([A], "\d+-\d+") then [A]
elseif REGEX_Match([B], "\d+-\d+") then [B]
else Null() endif

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu]

@AjaySetty 
I am not sure if the Column C is as input or output here.

if output, @atcodedog05 has given great answer.

If input, a filter tool might the one to use.

[MarqueeCrew · Accepted solution]

@AjaySetty ,

 Did you happen to try:

MIN([A],[B])

i think that will work.  Else Max()

 cheers,

 mark

[grazitti_sapna]

Hi @AjaySetty,

Here is my take on this problem.

I hope it helps.

[atcodedog05]

I dont know how exactly does that work, logic behind it.

But interesting concept @MarqueeCrew 

Thanks for this great new learning 🙂

[AjaySetty]

This was so simple and small, now i feel silly to ask this question.

Thanks so much but how does that formula work?

[atcodedog05]

@AjaySetty 

Dont worry its not silly.

Even i would like to know how it works.

[MarqueeCrew]

@atcodedog05 ,

 when you sort the values of [a] and [b], 2020 comes before Apple.  Numbers come first and then letters. 

cheers,

 mark