Running replace function on entire flatfile

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Posts: 4
Joined: Thu Apr 01, 2021 7:51 pm

Running replace function on entire flatfile

Postby Nismon8er » Wed Apr 28, 2021 7:02 pm

I am running DBWriter -> Reformat -> StructuredDataWriter .... this works fine

What I need to do after that is run FlatFileReader (on the resulting file from the StructuredDataWriter above) -> Reformat -> FlatFileWriter because I need to replace all instances of double single quotes '' to NULL but im not sure how to go about this since I always need metadata and im not sure what that will be if I want to do this for the entire file

If someone knows of another way to do this let me know