Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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,

RK

1 ACCEPTED SOLUTION

avatar
Master Guru
@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('\\[','(')}

View solution in original post

3 REPLIES 3

avatar
Master Guru
@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('\\[','(')}

avatar
New Contributor

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

avatar
New Contributor

looke like issue in NiFi. created Jira ticket for it

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