I'm trying to remove all formatting and line breaks from a multi-line text field with Calculation field. This way it would mimic a single-line text field.
The use case is I have a JSON response coming from globiflow, but the JSON response is too long to allow for globilfow to write it to a single-line text field(they seem to have a character max in the API for this field type). So I need a calculation field to remove all formatting that a multi-line text field adds to the JSON response so I can successfully parse it for the data I'm looking for.
I tried these regex, but it failed to do the trick:
Thanks in advance!
Please sign in to leave a comment.