stant
commented
8 years ago to do csv with a regex, this should work: ([^,]([,]|\Z)). to split tabs like for excel: ([^\t]([\t]|\Z)).
it is using standard perl/java regex notation. It's powerful but a lot to teach. You can look it up though.
I think the regex field matching option needs some documentation. For example expect using
[^"]*or[^\"]*to work for each field in the below line, but it does not appear to."11/09/2010","ACH","","Electronic Deposit","","$1000.00","$1000.00"