cancel
Showing results for 
Search instead for 
Did you mean: 

Line breaking during CSV Parser

Matt
New Contributor

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

5 REPLIES 5

tstack
Former Employee

As mentioned in the other post, without some quoting around the field with line-feeds, it’s difficult to figure out what is what. Can you push back on the vendor to do proper quoting?