Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
if my fied looks exactly like this :
42216|Services|Dial Up Internet
42216|Services|Domiciliations
42216|Services|Pin Pay
42216|Services|Safe Box
42216|Services|Sweep
42248|Accounts|403
42248|Accounts|421
42248|Accounts|427
42248|Accounts|461
42248|Accounts|462
I don't want to seperate but only want to replace '42248' by '42247'
Hope anyone can help
Try this
Load *,Replace(Test,42248,42247) as Test1;
Load * Inline [
Test
42216|Services|Dial Up Internet
42216|Services|Domiciliations
42216|Services|Pin Pay
42216|Services|Safe Box
42216|Services|Sweep
42248|Accounts|403
42248|Accounts|421
42248|Accounts|427
42248|Accounts|461
42248|Accounts|462
];
Or this to give extra safety:
Table:
Load *,Replace(Test,42248|,42247|) as Test1;
Load * Inline [
Test
42216|Services|Dial Up Internet
42216|Services|Domiciliations
42216|Services|Pin Pay
42216|Services|Safe Box
42216|Services|Sweep
42248|Accounts|403
42248|Accounts|421
42248|Accounts|427
42248|Accounts|461
42248|Accounts|462
];