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
MarkShnier__You
Qrew Legend
Qrew LegendThe 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
------------------------------
I tried both and not working :(
------------------------------
Adam Krzyzanek
------------------------------
SearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")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
------------------------------- @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
------------------------------- MarkShnier__You.. thx for letting us know. Credit goes to Jeff @Jeff Love for him taking the time to close the loop on his own post!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------