regex - Replace multiple occurrences

Question

I have a string, Can be any of the below cases:

test1/test2/test3/test4/test5/
test1/test2/test3/test4//
test1/test2/test3///
test1/test2////
test1/////

My expected results are

test1/test2/test3/test4/test5
test1/test2/test3/test4
test1/test2/test3
test1/test2
test1 How can i achieve using regex ?

Currently, i am using regexp_replace(col, "/+/", "/") it is working but leaving an extra / on the end.

Split at /, filter out empty strings from the array, join with /. — Tomalak
– Tomalak, Commented Oct 4, 2018 at 19:30

Wiktor Stribiżew · Accepted Answer · 2019-07-12 09:40:17Z

2

You may use

regexp_replace(col, '/+$|(/){2,}', '\\1')

See the regex demo.

Details

/+$ - 1 or more / at the end of the string
| - or
(/){2,} - two or more slashes, the last of which will be saved in Capturing group 1 that you will be able to refer to from the replacement pattern using the \1 placeholder.

edited Jul 12, 2019 at 9:40

answered Oct 4, 2018 at 20:26

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Not a real meerkat · Accepted Answer · 2018-10-04 19:44:31Z

0

You can use the following regex:

/\/+$/gm

and replace with an empty string ('').

The regex will match one or more slashes in the end of the string, then will replace those with the empty string, meaning the paths will no longer end in a slash.

edited Oct 4, 2018 at 19:44

Not a real meerkat

5,7671 gold badge27 silver badges58 bronze badges

answered Oct 4, 2018 at 19:36

Poul Bak

11k5 gold badges39 silver badges70 bronze badges

Collectives™ on Stack Overflow

regex - Replace multiple occurrences

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related