CSV Registry contains newlines

Evil as is, my source data has newlines in fields something like:

1|11/2|John Nash|He likes to go to schools.
And he has some problems with his past.|Florida
2|8/4|Smith|I have nothing to tell.|Seattle

Is there any way to work with this? since Clover is complaining about bad formed registries. Is there any way to workaround this in CSVs?

Hello,

I have prepared for you an example project, which can solve your needs. In the UniversalDataReader component you can set “Data policy” attribute to “Controlled” and handle misformatted or incorrect data. This incorrect data subsequently can be corrected by the Reformat component. In the example, I used your sample data. The graph should cope with any occurrences of new lines in the field

I hope this example will help you to find the solution.
_________________
Jiri Novak
CloverCARE Support
Javlin, a.s.