If string contains a hyphen before the comma, change the hyphen into another character

Hi all - I am wondering what workflow to build to achieve the above desired output. Essentially I am trying to change the hyphen from the section before the comma since I want to eventually text to column the whole cell without messing up elements such as E18-1 and B718-2.

Would appreciate any pointers! Thank you.

Datasets

Parse

Expression

Data Investigation

Database Connection

Accepted answers

Luke_C

Hi @erinylai

Not sure if your sample data is representative, but if it is you can try the replace first function:

All comments

binu_acs

@erinylai Two ways of doing this (Regex and String functions)

Replace_012723.yxmd

erinylai

Hi binuacs, thanks so much for your response! I tried incorporating into my workflow and I am encountering a few challenges since the full dataset has ~70k rows. How would you suggest that I modify the workflow to accommodate to the larger datasets?

Thank you!!

Luke_C

Hi @erinylai

Not sure if your sample data is representative, but if it is you can try the replace first function:

binu_acs

@Luke_C You made it so simple, I forgot about the ReplaceFirst function and made the formula too complicated 😀

binu_acs

@erinylai Can you upload some dummy data if possible?

erinylai

Hi binuacs, you helped me with the bigger question under another post so will close this out here. Thanks again!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703