Difficulty importing from Bank CSV Download

Asked by ricgal

I can download a csv file from my online banking, but the dates are in the format 1012010 for January 1 2010 and 14012010 for January 14, 2010

I want to import the data into wxBanker.

I don't know how to convert this. I do have the use of OOo Calc.



PS: I read the name of the program as weatherBanker, where wx=weather ;)

Question information

English Edit question
wxBanker Edit question
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Michael Rooney (mrooney) said :

Hi Rick! In the import CSV dialog, you can type anything you want in the "Date format" box, but I don't see a format that would match that. Using "%d%m%Y" would work, except that your CSV isn't zero-padding the day in the case of your January first example, which seems like a confusing scheme as it requires reading it backwards.

The only solution that I could see is prepending a "0" to any date field which has 7 instead of 8 characters, and then the "%d%m%Y" format should work if you type that in.

Let me know if that makes sense!

Can you help with this problem?

Provide an answer of your own, or ask ricgal for more information if necessary.

To post a message you must log in.