Does anyone have any idea how to update a field when data is inserted (this is from an external API) to remove line breaks in a text field?
I already have various ones set up like the example below to replace some characters with a space but don't know what I would use instead of the "/" in the shown example to reomve a line break. I have tread CHAR(10), \n, \r etc but wasn't expecting those to work and they didn't. If it was just a basic SQL I would use something similar to REPLACE(REPLACE([@field:Prop_Address], CHAR(10), ' '), CHAR(13), ' ') but have no idea how to achive this in the Caspio GUI.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Roosta
Hello all,
Does anyone have any idea how to update a field when data is inserted (this is from an external API) to remove line breaks in a text field?
I already have various ones set up like the example below to replace some characters with a space but don't know what I would use instead of the "/" in the shown example to reomve a line break. I have tread CHAR(10), \n, \r etc but wasn't expecting those to work and they didn't. If it was just a basic SQL I would use something similar to REPLACE(REPLACE([@field:Prop_Address], CHAR(10), ' '), CHAR(13), ' ') but have no idea how to achive this in the Caspio GUI.
Thanks for looking!
Cheers, Roosta
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.