Solved

Text function to remove multiple parents from a level 0 sub-account in GL metadata

  • 18 June 2024
  • 2 replies
  • 59 views
C
Rank
  • Chedi Newly Minted Pigmenteer
  • Newly Minted Pigmenteer
  • 1 reply

Hi. I’m new to Pigment so hoping someone has solved this problem before.

Has anyone been able to parse out the rightmost X number of characters that appear after any number of colons in a dimension member? e.g. [60001 Personnel Costs : XYZ : ABC: Salaries and Wages] should return [60001 - Salaries and Wages], where XYZ and ABC are illustrative of potential sub-accounts that need to be removed.

icon

Best answer by Thu Mai 19 June 2024, 06:24

View original

2 replies

Thu Mai
Rank
Userlevel 3
Badge +6

Hi Chedi, you can use TEXT functions in Pigment to get the right outcome you want, for example: LEFT, RIGHT, MID, … I think they’re quite smilar to Excel TEXT functions

For your case, the formula would be simple as this: 

Hope my answer helps 😊

Thu Mai
C
Rank

Thanks, Thu Mai. This is working for us: 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings