Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Could you please help me out to split below city field into two part like city and pin code
CITY |
REET KARAIKAL-309602. Pondi |
REET KARAIKAL-609602. . Pondi |
, PUDUCHERRY-605010 west |
, PUDUCHERRY-605010 west |
COIMBATORE-641006 CMB |
COIMBATORE-641018 |
COIMBATORE-641018 |
METTUPALAYAM-641301 MTP |
METTUPALAYAM-641302 |
Ouput: | ||
City | PinCode | |
REET KARAIKAL | 609602 | |
PUDUCHERRY | 605010 | |
COIMBATORE | 641006 | |
COIMBATORE | 641018 | |
METTUPALAYAM | 641301 | |
METTUPALAYAM | 641302 |
I can suggest a couple of approaches.
If the only numbers are the PIN code you can use:
KeepChar(CITY, '0123456789')
If you could have numbers elsewhere you could get the data after the "-"
KeepChar(TextBetween(CITY,'-',' '), '0123456789')
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Hi ,
Its working for Pincode only, But i need both city and pin code like in below.
City | PinCode | |
REET KARAIKAL | 609602 | |
PUDUCHERRY | 605010 | |
COIMBATORE | 641006 | |
COIMBATORE | 641018 | |
METTUPALAYAM | 641301 | |
METTUPALAYAM | 641302 |
Perhaps you can try using the 'split' card in the 'Data Manager'