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.
Best answer by Thu Mai
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 😊
+10Hi 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 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
