AnsweredAssumed Answered

String index out of range: -1

Question asked by ElliottKeene3591 on Jul 30, 2015
Latest reply on Jul 30, 2015 by ElliottKeene3591

Hi all. I'm trying to automate this Sales Order process into NetSuite however I'm receiving the following error when importing the Sales Order CSV - "String index out of range: -1". Below is the Shape Source Data:

OH,JAGO01,15627758,GB,1,,,,,,,29/07/2015,29/07/2015,,"
"
OD,10071,6,6,3.33,0,,,,,,,,,,
OD,20062,4,4,4.58,0,,,,,,,,,,
I understand what can cause this would be the speech marks on the top line and then the empty second line, however I'm unsure what's causing this as they aren't in the file.
Does anyone have a way of using a process to clean this up and remove them?

Outcomes