question Re: NiFi Apache - how to remove punctuation from a single column in Support Questions

NiFi Apache - how to remove punctuation from a single column

Mikkkk — Wed, 23 Oct 2024 21:36:17 GMT

I am trying to remove the punctuation from a single column using the UpdateRecord processor. But I am unable to get it right. I attached screenshots of my configurations and properties.

Re: NiFi Apache - how to remove punctuation from a single column

DianaTorres — Wed, 23 Oct 2024 21:50:51 GMT

@Mikkkk Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our NiFi experts @steven-matison @joseomjr who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: NiFi Apache - how to remove punctuation from a single column

drewski7 — Thu, 24 Oct 2024 02:00:28 GMT

@Mikkkk

Please check my screenshot below. I changed the "Replacement Value Strategy" property to "Literal". I also updated the dynamic user property to this - ${field.value:replaceAll('[\\p{Punct}]', ' ')}

Here's the screenshot -

${field.value}: In NiFi’s Expression Language, field.value refers to the current value of the field being processed in a record (for example, the value of the ENTITY_NAME field if that’s what you’re working on).

:replaceAll('[\\p{Punct}]', ' '): This function searches the field.value for any punctuation characters (using the [\\p{Punct}] regex) and replaces each occurrence with a space.

Please "Accept the solution" if it helped!

Re: NiFi Apache - how to remove punctuation from a single column

DianaTorres — Tue, 29 Oct 2024 18:48:41 GMT

@Mikkkk Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.