Skip to main content
Participant
Sep 11, 2020 3:59 PM UTC
Question

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

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 is closed to new replies. Start a new post to keep the conversation going.

2 replies

try67
Community Expert
Community Expert
Sep 11, 2020 4:51 PM UTC

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");
Translate
Participant
Sep 11, 2020 7:05 PM UTC

that did it! Thank you

Translate