Remove " " from a csv using apache nifi

Question

I have a csv looks like this :

id,name,age
"1","sachith","29"
"2","nalaka","29"

I want this to be like :

id,name,age
1,sachith,29
2,nalaka,29

For this I have used : ReplaceText Processor.

In it I have following settings:

Search value : (?s)(^.*$)

Replacement value : ${'$1:replaceAll('\"$1\"',$1)'}

Replacement Strategy : Regex Replace

Evaluation Mode : Entire text

But output file doent have any proper value. I think I am missing the right regular expression for Replacement Strategy.

Or do I have to use a separate processor for this task?

the simplest search value (regexp) = " and the replacement just empty value. — daggett
– daggett, Commented Nov 5, 2019 at 12:08
@daggett yes, this is the answer, Can you please post this as an answer, I can accept it. — Sachith Muhandiram
– Sachith Muhandiram, Commented Nov 5, 2019 at 12:14
Also make sure the fields do not contain any separators before removing the quotes. — Danny_ds
– Danny_ds, Commented Nov 5, 2019 at 13:33
@Sachith Field separators, like the comma in this case. If those appear in the fields, those fields have to be enclosed by double quotes. — Danny_ds
– Danny_ds, Commented Nov 5, 2019 at 17:23

daggett · Accepted Answer · 2019-11-05 12:16:01Z

2

if you want just remove all double quotes the simplest solution:

answered Nov 5, 2019 at 12:16

daggett

29k3 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1