Forum Discussion
KaranBhavsar
8 years agoQrew Trainee
Ok, so I have to use an intermediate Formula Text Field and write a formula to replace the text inside square brackets along with the brackets with a comma. How can I achieve that?
KaranBhavsar
8 years agoQrew Trainee
In the image I shared; my multi-line text field (say [Data] ) already had data "John, Shawn, Josh". Then through the HTML page that I attached below, I add more data i.e. "6" and "9.2" to the same multi-line text field [Data] that gets added with date-name stamp. If I add more data i.e. "10"; it will get added to the same [Data] with date-time stamp and will look like this.
John, Shawn, Josh [NOV-01-17 karan-bhavsar] 6 [NOV-01-17 karan-bhavsar] 9.2 [NOV-01-17 karan-bhavsar] 10
I want to replace the text inside square brackets along with the brackets with a comma so that I get this >> John, Shawn, Josh, 6, 9.2, 10
How can I achieve this using formula text field.
")
John, Shawn, Josh [NOV-01-17 karan-bhavsar] 6 [NOV-01-17 karan-bhavsar] 9.2 [NOV-01-17 karan-bhavsar] 10
I want to replace the text inside square brackets along with the brackets with a comma so that I get this >> John, Shawn, Josh, 6, 9.2, 10
How can I achieve this using formula text field.
")