You need to sign in to do that
Don't have an account?
Dirk Visser
Substitute linefeed with comma
I want in a formula field the linefeed being replace with a comma. Although I used the chr(10) equivalent thru my numpad, it doesn't replace it. How can I do it ?
So that it will be helpful to others.
Thanks,
Saravana
All Answers
Can you please share the formula you have used?
Also please refer this link if it helps.
https://salesforce.stackexchange.com/questions/18909/find-line-break-in-formula-field
Thanks,
Sarav
Sweet Potato Tec
SubStitute (cText, "◙", ",")
The "◙" stand for character 10 which is the linefeed character.
You can't directly substitute linebreak with comma.
Workaround:
Create a custom setting Global with a text area field CRLF and set the value as below.
a
b
Then use the below formula in the formula.
SUBSTITUTE(Text_LF__c, MID($Setup.Global__c.CRLF__c,3,1), ",")
Global__c - Custom Setting
CRLF__c - Custom setting field.
Text_LF__c is the text field in the object.
Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.
Thanks,
Sarav
Sweet Potato tec
So that it will be helpful to others.
Thanks,
Saravana
Note, this works in other contexts too. Instead of using the global variable, I just needed to do this within a flow - so I created a text template within the flow with the a/b text and used it with a substitute formula in exactly the same way.