Qlikview Replace function

oanabianca — Sat, 16 Nov 2024 19:55:44 GMT

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)

Re: Qlikview Replace function

oanabianca — Wed, 09 Oct 2019 15:36:21 GMT

I also tried

='('& Replace('$(vTest)',chr(13),'|')&')' and ='('& Replace('$(vTest)',chr(10),'|')&')' and

='('& Replace('$(vTest)','<br>','|')&')'

topic Re: Qlikview Replace function in QlikView

Qlikview Replace function

Re: Qlikview Replace function