Split text

  • 8 September 2023
  • 1 reply

Userlevel 3
Badge +6
  • Newly Minted Pigmenteer
  • 21 replies

Hi Pigment team! 


Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!





Best answer by Nathan 8 September 2023, 09:13

View original

1 reply

Userlevel 6
Badge +12



You can probably cut the string by FIND() the Month (Aug 23 here, but you’ll have to search for each month), then LEFT() from the result of the find, gives you the name.


Then you can use ITEM() to match the name vs the Employee dimension, which should give you your employee usable for summing values onto it.