On 3/18/2010 10:11 PM, Thomas Taylor wrote:
I import a comma separated list from my bank and open it in OOcalc. I
have trouble reading the date in their format of YYYYMMDDhhmmss, it's
all glommed together. I want to run a script on it before importing that
will put some character (prefer either "_" or " " as shown below.
DEBIT,20100208120000[0:GMT], \
DEBIT,20100208120000[0:GMT], \
DEBIT,20100204120000[0:GMT], \
DEBIT,20100125120000[0:GMT], \
DEBIT,20100125120000[0:GMT], / rest of lines trimmed
DEBIT,20100122120000[0:GMT], /
CREDIT,20100120120000[0:GMT], /
CHECK,20100119120000[0:GMT], /
^ ^
date field (YYYYMMDDhhmmss)
DEBIT,2010_02_08_120000[0:GMT], <<<<< end result I want
pass 6 or 7 char then find ","
then 4 digits for year
insert "_"
then 2 digits for month
insert "_"
then 2 digits for day
insert "_"
get rest of line
Tried combinations of sed & awk but haven't been able to insert the "_"
between the year, month, day, and time fields.
Pointers and suggestion would be greatly appreciated. I'm in the process
of learning bash scripting so please include how the script works (what
it does). I'm an old hand at C and assembler but the bash/sed/awk syntax
has me baffled.
Thank you all for your scripts. I'm running all of them and trying to
decipher they work. Frustrating sometimes but lots of fun.
Sorry it took so long to get back to you. Having problems with both
kmail and thunderbird crashing when composing new messages and replies.
Currently doing email in t-bird under windblows (Grrr).
Hey Ted, how's Manchester united doing this year?
--
Thanks, Tom (retired penguin)
openSuSE 11.3-M3, kde 4.4.0
FF 3.6.0
