Forum Discussion
ServiceQB
Qrew Member
Is the field MultiLine or Rick Text?
If it's Multi-Line Text try combos of /r /n
If it is Rich Text, Go into Edit Mode and put your cursor in the field and view the Source code (End of the format panel that appears) That will let you know if it's a break or a paragraph.
------------------------------
Tammie King
tjking@mintz.com
(978)828-9643
------------------------------
MarkShnier__You
2 years agoQrew Champion
The character for new line is actually \n
so try this
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
so try this
SearchAndReplace([1-Step feeder(s) - after AltBOM],"\n","; ")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- AdamKrzyzanek2 years agoQrew CaptainI tried both and not working :(
AndSearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")
Result :(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"\n","| ")
------------------------------
Adam Krzyzanek
------------------------------- MarkShnier__You2 years agoQrew ChampionDoes this recent post help to figure out what the characters really are?
https://community.quickbase.com/discussion/stripping-hidden-characters-from-text-strings-to-enable-field-equality?ReturnUrl=%2fcommunities%2fallrecentposts
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- AdamKrzyzanek2 years agoQrew Captain@Mark Shnier (Your Quickbase Coach) - Nailed it :)
When I used below formula it works:)
Upper(Trim(SearchAndReplace(SearchAndReplace(SearchAndReplace(SearchAndReplace(URLEncode([1-Step feeder(s) - after AltBOM]), "%0D%0A", "| "), "%0A", "| "), "%20", "| "), "%3A", "| ")))
------------------------------
Adam Krzyzanek
------------------------------