How to compare SWIFT Transaction Reference with CBS SWIFT_MSG?

Get Help & Discuss Process Studio
1

Hi Team,

I have two Excel files:

  • A file: Contains TranRefe

  • B file: Contains MSG, which is a long message.

For each TranRefe in the SWIFT file, I need to check whether it is contained anywhere in any CBS SWIFT_MSG.

Example:

  • A: ABC123

  • B SWIFT_MSG: :::20:ABC123|:::32A:...

  • Result: Matched

If the reference is not found in any CBS row, it should be Unmatched.

I need to separate the A file records into Matched and Unmatched outputs.

Can this be implemented using a Child Workflow with a loop through the CBS data? If yes, which AutomationEdge plugins and fields should be used, and how can the found result be returned to the parent workflow?

Thanks.

2

Yes excel that can be done use =ISNUMBER(SEARCH("word", A1)).
To find the exact character position where the word starts, and return TRUE or FALSE