Discussion board where members can get started with QlikView.
if my fied looks exactly like this :
42216|Services|Dial Up Internet
I don't want to seperate but only want to replace '42248' by '42247'
Hope anyone can help
Load *,Replace(Test,42248,42247) as Test1;
Load * Inline [
Or this to give extra safety:
Load *,Replace(Test,42248|,42247|) as Test1;