Skip to main content
Participant
September 11, 2020
Question

Convert CSV data in text field to a List in anther text field

  • September 11, 2020
  • 1 reply
  • 446 views

Trying to Document-Level JavaScript to get comma separated values shown in one text field to show as a list in another multiline text field. 

 

Example (csv): 1SZ,ATT,FHS,GU6

Needed Result: 

1SZ

ATT

FHS

GU6

 

Current Document Level Javascript (no success):

 

function StockOptions(){
var stkOpt = this.getField("List_Options").valueAsString.split(",");
var oldValue = this.getField("Factory_Options").valueAsString;

this.getField("Factory_Options").setItems(stkOpt);
if(stkOpt.indexof(oldValue)!=-1) this.getField("Factory_Options").value = oldValue;
}

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
September 11, 2020

That code was written to populate a drop-down field, not a text field. Use this, instead:

 

this.getField("Factory_Options").value = this.getField("List_Options").valueAsString.replace(/,/g, "\n");
Participant
September 11, 2020

that did it! Thank you