If then formula - turn a number (e.g., 2) into a range (following the example: "2-2")

Hi all, I am trying to do the following for the data shown: wherever there is a number instead of a range, I want to turn that number into a range. For example, "1" gets turned into "1-1" and "2" gets turned into "2-2".

Current View:

Desired View

If anyone has any pointers I would really appreciate it! Thank you.

Datasets

Expression

Text Mining

Data Investigation

Accepted answers

Christine_Assaad

Hi @erinylai

Please see attached. It's exactly the same methods, I just included the extra columns.

Output:

Range_2.yxmd

All comments

Christine_Assaad

Hello @erinylai

You can achieve the desired output in many ways; attached are 2

1- One that uses Regex.

2- One that check for hyphen.

Hope that helps. Cheers!

Range.yxmd

erinylai

Wow Christine thank you so much!! That was super helpful and thanks so much for including the workflow.

I have a follow-up question as I tried things out on my end. The screenshot I showed in the message was more of a intermediary step and as I went back to the initial view I found it difficult to incorporate the items. I have attached as follows the initial view (raw data set), current view (where things stand after I parse it based on the "+" character), and the final desired view. Could you please help me out? Thank you so much!

Christine_Assaad

Hi @erinylai

Please see attached. It's exactly the same methods, I just included the extra columns.

Output:

Range_2.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703