Script help for Integration Manager, concatenate fields for Reference field

(0) Share

Report

Posted on by ABrown

I am working on creating an IM and am trying to find my way through it, but have a couple of questions (posting separately). In the below sample code that is offered in the GP IM script library, how do I code for only the first character of one of the fields? For example, in Segment1 I only want the first character. Also, what if I want the first 5 of another segment? Would that be different than the first character? Is this sample they offer VB? It doesn’t appear to be VB I’m used to, but I am not a programmer and only have fundamental experience.

CurrentField = SourceFields("Accounts.Segment1") + SourceFields("Accounts.Segment2") + SourceFields("Accounts.Segment3")

Can someone please help me with modifying the sample for what I need? Thank you in advance!

*This post is locked for comments

All responses (3)

Answers (1)

ABrown 69 on at

Like (0)

Report

RE: Script help for Integration Manager, concatenate fields for Reference field

Figured it out, VB Script, which is slightly different than VB. Thank you again!
ABrown 69 on at

Like (0)

Report

RE: Script help for Integration Manager, concatenate fields for Reference field

Thank you!!! It worked. What language or syntax is this? I'd like to be able to find some resources. Thanks again, I really appreciate it.
Verified answer

Mike Bufano 1,480 on at

Like (0)

Report

RE: Script help for Integration Manager, concatenate fields for Reference field

Use the "Left" in your statement and at the end, indicate the number of characters.

CurrentField = Left(SourceFields("Accounts.Segment1") ,1)

You can use that same technique for the other fields.