The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
I am trying to build a model and two of the items that I need to trap as seperate items have the same label and characteristics in my report. Any suggestions or advice in trapping these items would be greatly appreciated. The items are labeled in red, TRACE:.------------------------------Jill WilliamsDirector of FinanceSchneider Regional Medical Center Hospital340-776-8311 etc 8106------------------------------
In your sample, it appears that the first trace number is not always the same length. What about the second trace number? The first suggestion would work if you can be certain that a blank will always occur somewhere in the same column that the second trace number isn't.Does the second trace number always occur above the settlement date line? If so, you can create a multiline trap to capture the two lines:TRACE NUMBER SETTLEMENT DATE Set the trap line to #2 and your trap to capture settlement date. In your sample text window you can then define two fields, Settlement date and TraceNumber2.You can then create another trap for the first trace number to trap on "Trace Number:"I mocked up your sample like so:And here is what I get in my data preview:------------------------------Chris PorthouseSenior Implementation & Integration EngineerAltair-------------------------------------------------------------------------Original Message:Sent: 06-24-2019 10:07 AMFrom: Jill WilliamsSubject: Trapping with same characteristicsI am trying to build a model and two of the items that I need to trap as seperate items have the same label and characteristics in my report. Any suggestions or advice in trapping these items would be greatly appreciated. The items are labeled in red, TRACE:.------------------------------Jill WilliamsDirector of FinanceSchneider Regional Medical Center Hospital340-776-8311 etc 8106------------------------------"
In your sample, it appears that the first trace number is not always the same length. What about the second trace number? The first suggestion would work if you can be certain that a blank will always occur somewhere in the same column that the second trace number isn't.Does the second trace number always occur above the settlement date line? If so, you can create a multiline trap to capture the two lines:
