Silver ⭐️⭐️⭐️

Solved

Regex to replace all characters after " ;" in a string in a flowfile - NiFi

2 replies
4862 views
Translate All

Hi,

Am trying to replace all characters after ";" including ; in the flowfile record.

I was using replacetext processor with ;.*$ as the search value and set empty value for Replacement value properties to achieve this. However it is not working out.

Any inputs in this regard would be really helpful.

Example:

Input

Replace;text;processor

Expected Output:

Replace

Thanks,

Bala.

Apache NiFi

MattWhoAnswer

Titanium ⭐️⭐️⭐️

@Bala S

I would recommend using capture groups in your regex. Here is an example that will work for your example:

I then replace with just the value from capture group 1

-

Here is another example that is more generic (can have many ";<somevalue>" after first one:

Here again I use capture group 1 as my replacement value.

-

Thank you,

Matt

-

If you found this answer addressed your question, please take a moment to login in and click the "ACCEPT" link

MattWhoAnswer

Titanium ⭐️⭐️⭐️

@Bala S

I would recommend using capture groups in your regex. Here is an example that will work for your example:

I then replace with just the value from capture group 1

-

Here is another example that is more generic (can have many ";<somevalue>" after first one:

Here again I use capture group 1 as my replacement value.

-

Thank you,

Matt

-

If you found this answer addressed your question, please take a moment to login in and click the "ACCEPT" link

Translate

bsivalingam83Author

Silver ⭐️⭐️⭐️

Thanks @Matt Clarke. I went with the option 2 and it worked. Thanks again for the quick reply.

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.