Forum Discussion

e_poveda's avatar
e_poveda
New Contributor III
16 hours ago
Solved

Transformation Rule - Split - Complex Expression

I need to get, from a Custom Dimension, the characters starting after "D." or "T." when it's possible. Normally it comes as D. or T. at the beginning, followed by XYZ. What I want to get, as a direct...
Extenders
Parsing
XFBR
  • e_poveda's avatar
    e_poveda
    11 hours ago

    Thanks for your answer. 

    I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.

PKiernan's avatar
PKiernan
Icon for OneStream Employee rankOneStream Employee
11 hours ago

Have you tried a Mask rule where the Rule Expression is D. and the target value is  *,  Or D.??? to ??? . This is assuming the source star equals to target star, or the length of the question marks and source and target values are the same.

  • e_poveda's avatar
    e_poveda
    New Contributor III
    11 hours ago

    Thanks for your answer. 

    I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor
      4 hours ago

      I know you said you wanted to have the full member in stage. Another option is to map the trimmed member in the data source to a different column that isn't used so you have both.