Search And Replace to Remove "enters"
I have field where users can enter data and divide them by using Enter:
XXXXXX
YYYYYY
For another field summary I would like to convert this way of entering into: {XXXXXX; YYYYYY} I was thi...
Forum Discussion
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
------------------------------
- Field from which formula is taking data is [Text (lookup)] from different table, where this field is [Text - Multi-line].
Formula field which I was using to convert is standard [Formula - Text].
I modified formula but it did not help.
SearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")
------------------------------
Adam Krzyzanek
------------------------------ - MarkShnier__You
Qrew Legend
The character for new line is actually \n
so try this
SearchAndReplace([1-Step feeder(s) - after AltBOM],"\n","; ")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- I 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__YouDoes 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
------------------------------
