Load script remove rows based on containing character
Hi all,
I have the below load script. In the original table (bron) is a field named 'text' which contains a lot of information. I replaced the line feeds with the character '//' and made in a second table a new row for each part of the string.
Now some of these new rows (called substring) contain the character '€' and some don't. I would like to only load the rows which contain a € into my QlikView file. Can anyone help me with a correct syntax for this?
Bron: SELECT field1, REPLACE(REPLACE(text, CHAR(13), '//'), CHAR(10), '//') as text FROM ....
temp: load field1, 'Sub'&Autonumber(RowNo(),RecNo()) as ColNo, SubField(text,'//') as substring resident Bron;