Hey Everyone,
Here’s an example of what I’m having issues with, since the contents that are inserted into the NOTES column have multiple line breaks. The data I’m receiving is via SFTP and wanted to see if this can be solved in Snap Logic.
The bolded text is the data that will be inserted into the NOTES column.
MODDATE|USERID|REC_NUM|CASE_NUM|DATE|TIME|DESCR|EXAMINER|TYPE|NOTES
20160203|DOMINGUEZMATTHEW|12345678|123456789|20081015|1130|Initial report|TESTING||TESTING NOTES
This text is still part of NOTES and is using line break to
that makes it go on multiple lines
What I need is to make all of this text appear in the NOTES column
-----------------------------------------------------------------------------
this is an example of what appears on our csv that we receive from our vendor
majority of it are copy and paste emails that the users have inserted
They go on for at least 50 lines until the next record is available
