How to remove last character on a string before delimiter ( - )

[Anonymous]

Hi  community,

I have the following challenge, my Path_no_cycle column looks like this:

I need to keep only the first 3 digit before every ( - )

If we take one as example :

ORIGINAL data VALUE:

CGNA-CGNH-CDGH-MRSA-MLAT7-MLAT8

DESIRE DATA VALUE data VALUE:

CGN-CGN-CDG-MRS-MLA-MLA

Thanks!

[Anonymous]

Here you go. 

[ddpl]

@Anonymous 

In Power Query...

1st... Split Column by Delimiter ("-")

2nd... Select All Column then in Transform => Extract => First Characters (3)

3rd... Select All Coumn and then in Tranform => Merge Columns ("-")

[Anonymous]

Thanks i think we are close!

Since not all the strings have the same leng i have some null and the result is: ( i see -----after the laste one)

[ddpl · Accepted solution]

@Anonymous 

In Power Query...

1st... Split Column by Delimiter ("-")

2nd... Select All Column and then Replace null => "del" value

3rd... Select All Column then in Transform => Extract => First Characters (3)

4th... Select All Coumn and then in Tranform => Merge Columns ("-")

5th... Replace "-del" => blank

[Anonymous]

Great!!! thanks