question Handle date column with spaces in nifi in Support Questions

Handle date column with spaces in nifi

Chakkara — Tue, 06 Jul 2021 12:32:57 GMT

I am trying to format the date field which contains spaces in replace text processor from a csv file.

Got the error as it is unable to parse the date column which is spaces for first record. Please let me know how to handle this

Error message: Replace text failed to process session due to Cannot parse attribute value as a date; date format ddMMyyyy; attribute value:

Input csv:

1, , 123

2,02091997,234

Search value : (.{1}),(.{8}), (.{3})

Replacement value : $1, ${'$2':toDate("ddMMyyyy") :format("yyyy-MM-dd HH:mm:ss.SSS") }, $3

Replacement strategy : Regex Replace

Evaluation mode : Entire Text

Re: Handle date column with spaces in nifi

aakulov — Wed, 07 Jul 2021 05:20:13 GMT

Hi @Chakkara ,

What would you like the parser to do when it encounters an invalid date value? If this is a recurring problem, where multiple lines in your file have the same number of spaces to indicate missing date, then you can use ifElse in your replacement value command (something like this).

Hope that helps,

Alex

Re: Handle date column with spaces in nifi

Chakkara — Wed, 07 Jul 2021 08:15:32 GMT

Thanks for the response and it works!!