AnsweredAssumed Answered

HELP: Calculation to reformat text

Question asked by TonyTrevisonno on Jun 24, 2013
Latest reply on Jun 26, 2013 by philmodjunk

Title

HELP: Calculation to reformat text

Post

     Hi Folks,

     Does anyone have a good way of taking the following text in a field:

S11_12_13_11_11_14_11_12_13_11

     And in a CALCULATION field automatically format it into the following:

S11_12_13_11_11_14_11_12_13_11

S11_12_13_11_11_14_11_12_13

S11_12_13_11_11_14_11_12

S11_12_13_11_11_14_11

S11_12_13_11_11_14

S11_12_13_11_11

S11_12_13_11

S11_12_13

S11_12

S11

     So, basically, repeat the string minus the last section until you get to the end.

     This is a short example. I have many strings that may be 50 or 100 ‘underscores’ long.

     Any help would be appreciated.

     Thanks..

     TT

Outcomes