Skip to main content

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 n60001 - Salaries and Wages], where XYZ and ABC are illustrative of potential sub-accounts that need to be removed.

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 😊

Thanks, Thu Mai. This is working for us: 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings