Replace String with 0 in NiFi

Asked Oct 25 '18 at 18:20

Active Oct 27 '18 at 03:00

Viewed 172 times

I have a CSV file as follows:

Time,Age, Address, Temperature 1,Temperature 2

2018:09:20 18:07:56.941,12,NaN,NaN,0

2018:09:20 18:07:56.951,45,24,23,NAN

2018:09:20 18:07:56.981,34,NaN,57,0

The problem is some column have NANs and numbers mixed and I want to replace all the 'NAN' in a column to '0' value. I know we can use ReplaceText processor. Please find attached my config for ReplaceText but its not replacing any NAN TO 0.

Please help to achieve this. Thank you

edited Oct 27 '18 at 03:00

OneCricketeer

179,855
19
132
245

asked Oct 25 '18 at 18:20

Shrads

1

Is it that none of either Nan or NAN are getting replaced by zero? If case is the problem try appending (?i) in the beginning of regex and make it (?i)\bNAN\b – Pushpesh Kumar Rajwanshi Oct 25 '18 at 18:34
Solved it. It was case sensitive problem. I was using NAN instead of NaN. Thanks – Shrads Oct 25 '18 at 18:41
My guess was right. Glad it worked for you :) – Pushpesh Kumar Rajwanshi Oct 25 '18 at 18:41

Replace String with 0 in NiFi

0 Answers0