Hi, did you complete the bank transaction seminar? I've watched your PayPal importing video which was interesting, unfortunatley my bank doesn't download everything in as organised fashion. I was hoping to see how you might approach deconstructing strings with different content formats.
Not yet but I'm planning on working on that after I finish the current account balances database that I'm working on. If your bank doesn't have a standard data file format feel free to post a sample of the data here so I can see what the format is and of course remove any personal information. Screenshots work best.
Craig JohnstonOP 16 months ago
Craig JohnstonOP 16 months ago
Ok, here you go, its from a french bank, hope it's ok. I've removed a lot of duplicates. I expect I'm going to have to analyse all the possibile formats. I'm really looking for advice on the best approach. I've tried once before just using IIF and string statements to try to btreak down Field2 but wondering if I should just try to write something in VBA to unstring each record sequentially...
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Seminars.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.