Regex to check the string from end of the string

Question

I need to select the substring of a text from an given keyword. For example

Str= 'book, painting'

I need to get output like ', painting'

So i gave regular expression like (•*)(\, •*) and collect group2 as an output.

But if the input is

Str= 'book, painting, instrument'

I am getting ', instrument' as an output but i should get ', painting, instrument'.

I am doing this in Replace in string step in pentaho data integration — Thendral Nilavu
– Thendral Nilavu, Commented Jan 5, 2024 at 16:51
This is an sample string and my code has name in this format so i need to get all the secondary names which will be after the first comma.. So there may be many names after primary name so i am not sure how many I can expect after first comma — Thendral Nilavu
– Thendral Nilavu, Commented Jan 5, 2024 at 17:01

Jesse C · Accepted Answer · 2024-01-05 17:03:56Z

1

To specify that the regex should start matching at the start of your text, use "^". Similarly, "$" can be used to match the end of your text, grabbing until the end of the string.

Your first reference should explicitly exclude commas, to ensure it only grabs the first column.

 ^([^,]*)(\, •*)$

answered Jan 5, 2024 at 17:03

Jesse C

133 bronze badges

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

Collectives™ on Stack Overflow

Regex to check the string from end of the string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related