AdamKrzyzanek
3 years agoQrew Captain
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 thinking to use formula "SearchAndReplace" but I am not sure what to enter in Search for?:
SearchAndReplace([1-Step feeder(s) - after AltBOM],"?????","; ")
In excel I would search for Char(10) but how to find "Enter" in QuickBase?
I tried to Trim, but does not work.
I tried to use in formula enter but after save it is converted to "/n "
Any ideas how to search and replace "ENTER" between numbers?
There might be more then 1 enter.
------------------------------
Adam Krzyzanek
------------------------------