New Living In SCRIBE Online Blog Post - SCRIBE Labs - Variable Connector Used To Control A Loop (Dynamically) March 09, 2018

[James Studer 3]

Recently, while working on a data migration task, I had a requirement to transform data stored in a string delimited by ";" and parse it to create multiple line items in the target systems.Here is an example as a visual:

 

Source:

productA, productB, productC, productD...

 

Target:

productA

ProductB

ProductC

ProductD

...

 

In the target system, each product would be a line item on an opportunity.In the source system this was all listed in a text box as a string and delimited by ";".Also the cell where this data was in the source could be null, have one item, ten items, fifty items, etc.So I needed a way to loop through this.

 

http://livinginscribeonline.blogspot.com/2018/03/scribe-labs-variable-co...

[Jeff Levetin]

Hi @James Studer,

 

Great work. I created a similar function, but your's is more elegant.

[James Studer 3]

New URL to article: https://www.livingintech.com/2018/03/scribe-labs-variable-connector-used...

[Ash Arendsz]

Hi Community,

 

The Variables Connector have been recently re-released under Connector extensions.

For the latest documentation and extra samples, have a look here:

https://help.scribesoft.com/scribe/en/index.htm#sol/conn/conn_ext.htm

 

https://support.tibco.com/s/article/TIBCO-Scribe-Online-Connector-for-Variables-Sample-Map