topic Script in QlikView https://community.qlik.com/t5/QlikView/Script/m-p/956270#M974020 <HTML><HEAD></HEAD><BODY><P>hi</P><P>if my fied looks exactly like this :</P><P></P><P>42216|Services|Dial Up Internet</P><P>42216|Services|Domiciliations</P><P>42216|Services|Pin Pay</P><P>42216|Services|Safe Box</P><P>42216|Services|Sweep</P><P>42248|Accounts|403</P><P>42248|Accounts|421</P><P>42248|Accounts|427</P><P>42248|Accounts|461</P><P>42248|Accounts|462</P><P></P><P>I don't want to seperate but only want to replace '42248' by '42247'</P><P>Hope anyone can help</P></BODY></HTML> Wed, 02 Sep 2015 09:43:42 GMT mario-sarkis 2015-09-02T09:43:42Z Script https://community.qlik.com/t5/QlikView/Script/m-p/956270#M974020 <HTML><HEAD></HEAD><BODY><P>hi</P><P>if my fied looks exactly like this :</P><P></P><P>42216|Services|Dial Up Internet</P><P>42216|Services|Domiciliations</P><P>42216|Services|Pin Pay</P><P>42216|Services|Safe Box</P><P>42216|Services|Sweep</P><P>42248|Accounts|403</P><P>42248|Accounts|421</P><P>42248|Accounts|427</P><P>42248|Accounts|461</P><P>42248|Accounts|462</P><P></P><P>I don't want to seperate but only want to replace '42248' by '42247'</P><P>Hope anyone can help</P></BODY></HTML> Wed, 02 Sep 2015 09:43:42 GMT https://community.qlik.com/t5/QlikView/Script/m-p/956270#M974020 mario-sarkis 2015-09-02T09:43:42Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/956271#M974021 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>Load *,Replace(Test,42248,42247) as Test1;</P><P>Load * Inline [</P><P>Test</P><P>42216|Services|Dial Up Internet</P><P>42216|Services|Domiciliations</P><P>42216|Services|Pin Pay</P><P>42216|Services|Safe Box</P><P>42216|Services|Sweep</P><P>42248|Accounts|403</P><P>42248|Accounts|421</P><P>42248|Accounts|427</P><P>42248|Accounts|461</P><P>42248|Accounts|462</P><P>];</P></BODY></HTML> Wed, 02 Sep 2015 09:51:38 GMT https://community.qlik.com/t5/QlikView/Script/m-p/956271#M974021 qlikmsg4u 2015-09-02T09:51:38Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/956272#M974022 <HTML><HEAD></HEAD><BODY><P>Or this to give extra safety:</P><P></P><P><STRONG>Table:</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Load *,Replace(Test,42248<SPAN style="color: #ff0000;">|</SPAN>,42247<SPAN style="color: #ff0000;">|</SPAN>) as Test1;</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Load * Inline [</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Test</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42216|Services|Dial Up Internet</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42216|Services|Domiciliations</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42216|Services|Pin Pay</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42216|Services|Safe Box</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42216|Services|Sweep</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42248|Accounts|403</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42248|Accounts|421</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42248|Accounts|427</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42248|Accounts|461</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>42248|Accounts|462</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>];</STRONG></P></BODY></HTML> Wed, 02 Sep 2015 09:59:02 GMT https://community.qlik.com/t5/QlikView/Script/m-p/956272#M974022 sunny_talwar 2015-09-02T09:59:02Z