https://community.cloudera.com/t5/Support-Questions/How-to-extract-fields-enveloped-in-quotes-in-NiFi/m-p/306545#M222873 <P>I have some pipe delimited files. Each field is bounded by quotes like this.<BR /><BR />"Created_Date__c"|"CreatedById"|"CreatedDate"|"Guid_c"<BR />"2020-03-02 00:00:00"|"0053i000002XCpAAG"|"2020-03-02 16:01:34"|"94bf83ccf9daf610VgnVCM100000307882a2RCRD"<BR />"2020-03-03 00:00:00"|"0053i000002XCpAAG"|"2020-03-03 09:15:56"|"1a4bb238cdedd610VgnVCM100000307882a2RCRD"<BR />"2020-03-03 00:00:00"|"0053i000002XCpAAG"|"2020-03-03 09:52:33"|"22408baca6fee610VgnVCM100000307882a2RCRD"<BR /><BR /></P><P>I need to cleanse this data and the needs to look like this.</P><P><BR />Created_Date__c|CreatedById|CreatedDate|Guid_c<BR />2020-03-02 00:00:00|0053i000002XCpAAG|2020-03-02 16:01:34|94bf83ccf9daf610VgnVCM100000307882a2RCRD<BR />2020-03-03 00:00:00|0053i000002XCpAAG|2020-03-03 09:15:56|1a4bb238cdedd610VgnVCM100000307882a2RCRD<BR />2020-03-03 00:00:00|0053i000002XCpAAG|2020-03-03 09:52:33|22408baca6fee610VgnVCM100000307882a2RCRD</P><P>&nbsp;</P><P>I tried using ReplaceText with these configurations.<BR />search value - ^"(.*)"$ and Replacement Value - $1. But these configurations is not working and the file is routing to failure. not sure what might be the issue.</P><P>open to other suggestions. Thanks in advance.</P> Fri, 27 Nov 2020 15:35:48 GMT naga_satish 2020-11-27T15:35:48Z