Skip to main content
June 13, 2025
Question

Bypass Characters in Transformation Rules

  • June 13, 2025
  • 2 replies
  • 0 views

I am curious if there is a way to bypass characters in a transformation rule without using a complex expression.

For example,

000485 (Source) -> 458 (Target)

394904 (Source) -> 904 (Target)

 

2 replies

June 13, 2025

I think you could do it with a Mask map: ???* as the source with * as the target should work in theory but I have had mixed success when using * as the target. 

 If that doesn't work you could create Mask type maps and enter ???485 as the source and then 485 as the target.

SamwiseAuthor
June 13, 2025

Unfortunately, you will need to have ??? on both sides. It would have to look something like ???485 (source) -> ???485 (Target), else it will return on error.

June 13, 2025

As MarcusH​ says, a mask mapping with ???485 as the expression and 485 as your target should work. I have a similar mapping mapping ???80 to Target acct 10000



 

June 13, 2025

Can you use an complex expression where you define the source account (e.g sAcc) and do something like  if sAcc..TrimStart("0") = 485 Then Return 485?

SamwiseAuthor
June 13, 2025

Yes, I would just like to know if there is a way to do it without using parser rules or complex expressions.