question Re: getDelimitedField when delimiter is a \ in Support Questions

getDelimitedField when delimiter is a \

jiglesias — Thu, 11 Apr 2019 04:15:14 GMT

Hello,

I have an attribute log_source that holds a path like D:\dir1\dir2\dir3

I need to get only dir2 but I'm unable to escape the slash with ${log_source:getDelimitedField(3,'\')}

I've tried several things unsuccessfully.

Re: getDelimitedField when delimiter is a \

MattWho — Thu, 11 Apr 2019 05:10:46 GMT

@Julian Iglesias

You can accomplish above using a function chain in your NiFi Expression Language (EL) statement.

Rather then using the getDelimitedField() EL function:

${log_source:getDelimitedField(3,'\')}

-
You can successfully do this using the substringAfter() function twice to strip away what is before "dir2" and the substringBefore() function to strip away everything after "dir2":

${log_source:substringAfter('\\'):substringAfter('\\'):substringBefore('\\')}

Thank you,

Matt

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

Re: getDelimitedField when delimiter is a \

jiglesias — Thu, 11 Apr 2019 05:43:59 GMT

@Matt Clarke thank you, it works.

Just in case somebody needs it I managed to make it work using getDelimitedField

log_source:getDelimitedField(3, '\\', '"', '~')}