Removing Excess Comma's in an Concatenated Field

Hello --

I am working on a project and have a challenge that is eluding me. I have concatenated about 7 fields using a comma (,).

1) ,,,,CBC500,,,,CBC501,,

2) ,,,,,CBC100,,,,,

How do I keep a single comma to delineate, but remove any unnecessary commas. So for item 1, I want to see:

CBC500,CBC501

Thanks,

Seth

Common Use Cases

Accepted answers

MarqueeCrew

You could try:

Regex_Replace([field],",{2,}",',')

That gets rid of repeating commas. To get rid of the first and last commas:

Trim(Regex_Replace([field],",{2,}",','),",")

Does that work for you?

All comments

MarqueeCrew

You could try:

Regex_Replace([field],",{2,}",',')

That gets rid of repeating commas. To get rid of the first and last commas:

Trim(Regex_Replace([field],",{2,}",','),",")

Does that work for you?

smoskowitz

Wow! That worked! Now ask me if I understand why it worked.

Thanks,

Seth

davidhenington

You're good @MarqueeCrew , very, very good!

Anudeep_Yalamuru

Hello All, Just a similar issue. @MarqueeCrew could you please help with below? Unfortunately, your solution above isn't working. what am i doing wrong?

INPUT

Formula

Output

davidskaife

Hi @Anudeep_Yalamuru

Try changing the {1,} to {2,}

Anudeep_Yalamuru

Hi David,

I did the same but still left with the same issue.

Output

Anudeep_Yalamuru

Thanks @davidskaife It removed all the commas. Im happy with that for now. But I understood what you meant and you are right about the whitespace. Appreciate your responses.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703