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

[Emil_Kos · Accepted solution]

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!

[jdunkerley79]

I would suggest a formula of:

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

This will delete everything from the first comma on. 

[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.

[atcodedog05]

Hi 

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 😀👍

[atcodedog05]

Hi @JDong 

If you dont have leading spaces(i,e before the text). I dont think trim is really required.

Anyways glad to hear it got solved.

Happy to help 🙂

Cheers and Happy Analyzing 😀

[Emil_Kos]

Hi @JDong,

Thank you for marking my answer as a solution.

Good luck!