question Re: NiFi UpdateRecord processor is throwing PatternSyntaxException: Unclosed character class near index 4 in Archives of Support Questions (Read Only)

NiFi UpdateRecord processor is throwing PatternSyntaxException: Unclosed character class near index 4

ravi0007 — Fri, 16 Nov 2018 05:46:10 GMT

updaterecord-config-exception.jpgI am trying to replace square bracket symbol [ with parenthesis symbol ( in my employeeName column in my csvReader structure with below syntax

replaceRegex(/employeeName, "[\\[]", "(")

Processor is throwing following exception.

RecordPathException: java.util.regex.PatternSyntaxException: Unclosed character class near index 4 [\\[]

same regular expression compiled successfully using java method java.util.regex.Pattern.compile method.

replaceRegex is working fine for other special characters such as {, <, ", _, - etc.

Please see the attachment for more details.

Any help is greatly appreciated.

Regards,

Re: NiFi UpdateRecord processor is throwing PatternSyntaxException: Unclosed character class near index 4

Shu_ashu — Fri, 16 Nov 2018 06:14:00 GMT

@ravi kargam

As a work around Instead of using replaceRegex function use replace function with below configs:

UpdateRecord Configs:

Replacement Value Strategy

Record Path Value

/employeeName

replace(/employeeName,'[','(')

(or)

If you are updating only one column value then

Replacement Value Strategy

Literal Value

/employeeName

${field.value:replaceAll('\\[','(')}

Re: NiFi UpdateRecord processor is throwing PatternSyntaxException: Unclosed character class near index 4

ravi0007 — Fri, 16 Nov 2018 06:23:55 GMT

Your suggestion worked. Thank you Shu for promptly addressing my issue.

Re: NiFi UpdateRecord processor is throwing PatternSyntaxException: Unclosed character class near index 4

ravi0007 — Fri, 16 Nov 2018 07:06:18 GMT

looke like issue in NiFi. created Jira ticket for it

https://issues.apache.org/jira/browse/NIFI-5826