Display only 1 Value

JDong

Hello Team,

I have the following data in a column 'Fruits'

Fruits

Oranges, Oranges

Apple,Apple,Apple

Kiwi

Grapes,Grapes, Grapes

This data is part of a large table and this is from the end outcome.

Is there a way I can retain just one value for each row in the column.

Expected outcome is :

Fruits

Oranges

Apple

Kiwi

Grapes

Thanks

Datasets

Developer

Preparation

Accepted answers

Emil_Kos

Hi @JDong,

I have created a workflow for you:

And the output is:

If this is something helpful please mark my post as a solution!

Good luck!

Fruits.yxmd

All comments

Emil_Kos

Hi @JDong,

I have created a workflow for you:

And the output is:

If this is something helpful please mark my post as a solution!

Good luck!

Fruits.yxmd

jdunkerley79

I would suggest a formula of:

REGEX_Replace([Fruits], ",.*", "")

This will delete everything from the first comma on.

RegexToComma.yxmd

JDong

This works too thanks !

I also used a REGEX formula to achieve this result

TRIM(REGEX_Replace([Concat], '\b(.+),(?=.*\b\1,?)', ''))

@jdunkerley79 This trims the spaces as well

grazitti_sapna

hi @JDong,

Here is another way of achieving the same output.

onevalue.yxmd

atcodedog05

Here is a workflow for the task.

Output:

Workflow:

Parse mode

([[:alpha:]]+).*

Hope this helps 🙂

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

Fruits.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703