AnsweredAssumed Answered

inserting a character (comma, paragraph return) into text string

Question asked by LindaWilkes on May 15, 2011
Latest reply on May 18, 2011 by LindaWilkes

Title

inserting a character (comma, paragraph return) into text string

Post

I have a text string that I want to add a character like a comma or paragraph return every 4 characters.

For example I have a string like GE09GE08GE07 and I need to separate this into GE09,GE08,GE07

Is there a calculation function that can do this?  I've tried left with repeats but it just gives me the same 4 characters over and over, not the next four.

HELP!

Linda

Outcomes