James Studer 3 Posted March 9, 2018 Share Posted March 9, 2018 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... Link to comment Share on other sites More sharing options...
Jeff Levetin Posted March 14, 2018 Share Posted March 14, 2018 Hi @James Studer, Great work. I created a similar function, but your's is more elegant. Link to comment Share on other sites More sharing options...
James Studer 3 Posted July 7, 2018 Author Share Posted July 7, 2018 New URL to article: https://www.livingintech.com/2018/03/scribe-labs-variable-connector-used... Link to comment Share on other sites More sharing options...
Ash Arendsz Posted July 13, 2020 Share Posted July 13, 2020 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now