Is there a way to have Astera automatically remove carriage returns within cells?
Sometimes we get data with these in them and without a careful eye it can cause problems. When running the file through astera it remains bad in the resulting file.
I have attached a file which has many of the issues I am speaking of.
If you scroll down the file you should see rows which are out of alignment, but when viewing in a text editor there is no extra comma just a return.
-----------------------------------------------------------------------------
Hello Topher,
There is an option in delimited file source properties that says " Allow record delimiter inside a Field Text". If you check this option, it will allow the record delimiter (that is carriage return in most cases) inside a cell and would not break the record at that point. Please let me know if this resolves your issue.
Thanks,
Technical Support
Astera Software
Thanks