23.08.2010 | 18:37
ako možda netko zna, a vjerujem da vas ima...
imam slijedeći problem, imam textualni file koji otprilike izgleda ovako:
MPA.W1SPP.PA.W1LPP Master of Public Admin - Law and Public Policy
MPA.W1SPP.PA.W1LGM Master of Public Admin - Local Government Management
MPA.W1SPP.PA.W1SNPL Master of Public Admin - Nonprofit Management & Leadership
MPA.W1SPP.PA.W1PA Master of Public Admin - Policy Analysis
MPA.W1SBS.PADM.PML Master of Public Admin - Public Management & Leadership
MPA.W1SBS.PADM.TMP Master of Public Admin - Terrorism, Mediation, and Peace
MPH.W1HHS.RLK.W1GN Master of Public Health - General
MS.W1HHS.CRA.W1GN MS: in Clinical Research Admin-General
itd.
trebao bih to nekako kopriati u open office (spreadsheet) ali da mi ovaj prvi dio (lijevi kodovi) budu u jednom stupcu, a opis u desnom stupcu.
druga opcija mi je da nekako od ovog txt fajla napravim 2. u jednom je opis, a u drugom ove šifre. tada bi bilo easy C/P u Open Office-ov "excel"
zna netko ili moram ručno derati 253 redova C/P?