Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I want to replace the breakline(new line) from a string with '|' character. I want to copy a list of numbers from Excel into an input box, so after that I can search those strings in a search bar.
I tried this but it's not working
='('& Replace('$(vTest)',chr(13)&chr(10),'|')&')'
Example:
1
2
3
4
5
I want to search all those numbers into a search box so I need to transform them into the following format: (1|2|3|4|5)
I also tried
='('& Replace('$(vTest)',chr(13),'|')&')' and ='('& Replace('$(vTest)',chr(10),'|')&')' and
='('& Replace('$(vTest)','<br>','|')&')'