Bypass Characters in Transformation Rules
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)
Forum Discussion
5 Replies
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.
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.
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
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?
Yes, I would just like to know if there is a way to do it without using parser rules or complex expressions.
