AnsweredAssumed Answered

Below data is one of our record from input Flatfile (CSV). Text from Application server to office 2016 is a single field in the record.  We are facing data shifting issue due to the presence of line breaks and commas inside this field. "LPPSRKMS01","Appli

Question asked by mastanvalli.kothapalli974983 on Aug 30, 2018
Latest reply on Aug 30, 2018 by britto.parthalomew

Below data is one of our record from input Flatfile (CSV). Text from Application server to office 2016 is a single field in the record. 

We are facing data shifting issue due to the presence of line breaks and commas inside this field.

"LPPSRKMS01","Application Server - MS KMS

LPPSRKMS01 ( server 2016) is currently doing product keys for:

Server 2016R2, Server 2012, Server 2012 R2, Server 2008R2, Server 2008, Windows 10, Windows 7, Office 2013. Office 2016","Operational","true","VMWARE, INC.","","","VMware-42 23 5d 98 8f 2e a9 8f-16 ea d0 36 2a 65 a1 87","","","4,096","79.51","2","","Production","lpch.net","","10.251.210.48","","","","Forsythe Data Center - 275 Panama","","2018-07-13 17:00:00","","","","","","PATCH EXCEPTION","","","Windows Server","Service Management","IS SM Lev-SCH"

Outcomes