OpenEuphoria

Parsing problem

• Posted by Patrick Barnes <mrtrick at gmail.com> Aug 16, 2005
• 615 views

I have some finance data that my bank insists on lumping all together
into one field. A sample of the data is below:

Visa Purchase                26DECThe Carss Park Super Carss Par
Non Stg/Bsa Atm Wdl Fee
Internet Deposit             05JAN23:11itamoney
Visa Purchase                03JANWorld Vision Of Aust Burwood E
Adi Limited28686
Visa Cash Advance            07JANEur210.00 Banco Di Brescia
Visa Purchase                18JANOptus Tv/Net Autopay Chatswood
Internet Deposit             25JAN10:05shopping
Atm Withdrawal               25JAN11:09Westpaccrlngfrd 2 O/S    Carlingfor2=
  Au
Adi Limited28686
Atm Withdrawal               27JAN07:37St.George Telopea Hair Telopea Nsw \=
Au
Atm Withdrawal -Cba           27JAN09:20Cba Atm  Uts B'Way Op   Nsw 228498 =
  Aus
Visa Cash Advance            21JANEur120.00 Banco Di Brescia
Atm Withdrawal -Cba           28JAN08:48Cba Atm  Uts B'Way Op   Nsw 228498 =
  Aus
Visa Purchase                25JANWoolworths W1122    Carlingfo
Visa Purchase                26JANColes Express Dundas Dundas
Visa Purchase                25JANVodafone            Chatswood
Internet Deposit             29JAN09:57billls....
Eftpos Purchase              29JAN10:28N R M A Mcc        North Ryde
Atm Withdrawal - O/Bank       31JAN12:34Garden Island           Sydney     =
  Au
O/Seas Cash Withdrawal Fee
Visa Purchase                27JANBilo Telopea 4106   Telopea
Non Stg/Bsa Atm Wdl Fee
Atm Withdrawal               01FEB19:25St.George Telopea Hair Telopea Nsw \=
Au
Visa Purchase                29JANIkea Homebush Bay   Rhodes
Visa Purchase                28JANWoolworths W1200    Eastwood
Visa Purchase                29JANPlatinum Communicatn Rhodes
Visa Purchase                29JANCaci Clinic         Edgecliff
Visa Purchase                31JANWorld Vision Of Aust Burwood E
Visa Purchase                28JANVodafone            Chatswood
Visa Purchase                31JANWoolworths W1200    Eastwood
Tfr Wdl Bpay Internet         03FEB19:0311174893           Integral Energy

Each line is a single field in the incoming .csv file.
Any suggestions on how to parse it? In most but not all cases, the
second 'column' starts at about the 29th element. Sometimes the date
is given, sometimes data and time, sometimes nothing.

--
MrTrick
----------