Forum Discussion

Qrew Captain

3 years ago

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...

Tables and fields

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

The character for new line is actually \n

so try this

SearchAndReplace([1-Step feeder(s) - after AltBOM],"\n","; ")

------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------

Qrew Captain

3 years ago

I tried both and not working :(

SearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")

And

SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"\n","| ")

Result :(

------------------------------
Adam Krzyzanek
------------------------------