Remove everything after the first hyphen from the right

rahulshetty925

Hi All,

I have been trying to remove everything after first - from the right of a string including the -

Example My string has

INPUT: Output;

ABC-DEF-GHI ABC-DEF

JHX-HZXE JHX

HDKDK12-HJDJ-7695 HDKDK12-HJDJ

Requirement is to always remove everything from the first - right of the string.

I have tried Right([account], FindString([account], '-')) and some regex functions but nothing is giving me the right result.

Let me know if anyone can help.

Regards,

Rahul

Regex

Parse

Transformation

Accepted answers

Claje

Hi,

Here's a regular expression that should work:

(.*)-[^-]*

This will output all data before a dash that has only non-dash characters after it.

Additionally, a formula option is below:

Left([Account],Length(Account)-FINDSTRING(ReverseString(Account),'-')-1)

This will take the left characters up until a character before the last "-" in the string, thanks to ReverseString.

ponraj

Here is the sample workflow for your case. Hope this is helpful.

Input InputWorkflow Results Results

Remove everything after the first hyphen from the right.yxmd

All comments

StephenRuhl

I would use Text to Columns and split on "-". You only need to split to two fields and the result you want will be in the first field while everything else will split out into the second field.

Claje

Hi,

Here's a regular expression that should work:

(.*)-[^-]*

This will output all data before a dash that has only non-dash characters after it.

Additionally, a formula option is below:

Left([Account],Length(Account)-FINDSTRING(ReverseString(Account),'-')-1)

This will take the left characters up until a character before the last "-" in the string, thanks to ReverseString.

ponraj

Here is the sample workflow for your case. Hope this is helpful.

Input InputWorkflow Results Results

Remove everything after the first hyphen from the right.yxmd

rahulshetty925

Hi Claje,

Both the solutions worked in my case.Thank You.

I was probably not reversing the string.

Regards,

Rahul Shetty

rahulshetty925

Hi Sruhl,

I had laready tried this one.The problem with this one was the split in to first and second was not what I required.

For example -- output was getting split after the first hyphen.

Regards,

Rahul

rahulshetty925

Hi Ponraj,

This looks like a good hack for my question. Thanks very much.

Regards,

Rahul

Murugan

hey can u pls share your solved code ..becoz your .yxmd file is not opening ...share in notepad or readable format

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703