i have this below, i want to split it, but it show...
# suitescriptv
vennila ramasamy
08/11/2023, 9:56 AMi have this below, i want to split it, but it shows error
["Id,EntityType,DisplayLabel,Entity_c,Entity_c.DisplayLabel,Date_c,Employee_c,Employee_c.Name,RelPrj_c,RelPrj_c.DisplayLabel,Memo_c,ServiceItem_c,Duration_c,Billable_c\r"]
could anyone please help
n
NElliott
08/11/2023, 10:32 AMSplit how and what is your error?
NElliott
08/11/2023, 10:35 AMYou have one array element and it contains a long string which looks comma separated.
short answer
yourArray[0].split(',');
v
vennila ramasamy
08/11/2023, 11:37 AMCannot call method "split" of undefined
vennila ramasamy
08/11/2023, 11:37 AMstill gettng this error
n
Nathan L
08/11/2023, 11:52 AMCan you show your code?
v
vennila ramasamy
08/11/2023, 11:54 AMvar content = columns[i].split('\r",');
log.debug('content',content);
var contentSplit = content.split(',')[0];
log.debug('contentsplit',contentSplit);
vennila ramasamy
08/11/2023, 11:55 AMthe content is "Id,EntityType,DisplayLabel,Entity_c,Entity_c.DisplayLabel,Date_c,Employee_c,Employee_c.Name,RelPrj_c,RelPrj_c.DisplayLabel,Memo_c,ServiceItem_c,Duration_c,Billable_c\r"
n
Nathan L
08/11/2023, 11:58 AMAnd that doesn't work?
v
vennila ramasamy
08/11/2023, 12:01 PMCannot find function split in object
vennila ramasamy
08/11/2023, 12:02 PMThe contenet is ["Id,EntityType,DisplayLabel,Entity_c,Entity_c.DisplayLabel,Date_c,Employee_c,Employee_c.Name,RelPrj_c,RelPrj_c.DisplayLabel,Memo_c,ServiceItem_c,Duration_c,Billable_c\r"]
w
Watz
08/11/2023, 1:30 PMWatz
08/11/2023, 1:30 PM