Forum Discussion

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
6 months ago

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)  
Metadata
CostinA's avatar
CostinA
New Contributor
6 months ago

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?

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
6 months ago

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