Suoritettu

Simple project to parse values in text files into Excel

I need some VBA code that will scan through a specified folder and all sub-folders looking at all found text (TXT) files.

The code needs to read (parse) the files and import the transaction value data into a single Excel worksheet for all the files.

The text file contains some garbage information, so need to ignore all this and only import the transaction lines.

The data dates are in short form, so need to get the year from earlier in the file (where the date is shown in full with the year). This is in the same searchable place in every file.

Some statements run from DEC to JAN, so need to take care to +1 the year if this condition.

Rows need to be as follows:

Statement Filename, Statement Item No (added sequentially), Transaction Date, Processing Date, Description, Amount, Foreign Currency, Foreign Currency Amount

(The last 2 rows are optional and only apply when the transaction is in a foreign currency).

(Rows 1 and 2 are added automatically - not based on the text file data. These will be used for sorting.)

Example statement follows. Some details changed and details snipped.

========1========

Statement of xxxx xxxxx

CHARLES DICKENS

1234­25XX­XXXX­1234

000273

14 OCT

PREVIOUS BALANCE

12 OCT THANK YOU-PAYMENT THROUGH ABANK

1234­25XX­XXXX­1234 CHARLES DICKENS

16,795.94 16,795.94-

SUB-TOTAL

1234­25XX­XXXX­1245 CHARLES DICKENS

0.00

05 OCT

02 OCT

HOME PRODUCT CENTER (PLOEYORK

TH

597.00

05 OCT

03 OCT

PAYPAL *AUTOGRO

4019455761 NY

11,461.25

08 OCT

07 OCT

DFT FLOATS S P/L - FLOSINGAPORE SG

263.51

SINGAPORE DOLLAR

10.30

Page 1/4

========2========

Taidot: tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: excel macros create text files excel, parse large text files java, sorting text files excel, vba read text file into array, excel vba read text file line by line, extract data from text file into excel vba, convert text file to excel 2016, excel vba import text file comma delimited, excel vba read text file into worksheet, copy data from text file to excel using vba, how to extract data from text file to excel using vba, search text files excel, importing text files excel using visual basic, vbscript import multiple text files excel, parse text files excel, import multiple text files excel macro, parse data text file excel, macro import multiple text files excel file automatically, importing multiple text files excel free macros, simple php cms editing text files

Tietoa työnantajasta:
( 25 arvostelua ) Lumpini, Pathumwan,, Thailand

Projektin tunnus: #19466204

Myönnetty käyttäjälle:

shamim0000at

Sir My name is Shamim. I've put your writing and got it done I have experience working before If you give me the job you can do it very well Thanks

$25 USD 2 päivässä
(1 arvostelu)
0.0
shahinrahimi

Hi, good day. I interested in this project although the budget that you define is low but I do like to write this VBA so if you interested in we could have quick chat on this. I have rich experience in excel (advanc Lisää

$60 USD 3 päivässä
(17 Arvostelua)
3.8

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$60 USD 2 päivässä
(326 arvostelua)
7.9
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$66 USD 2 päivässä
(138 arvostelua)
6.3
rinabuoy13

Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$45 USD 10 päivässä
(90 arvostelua)
6.0
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Lisää

$135 USD 3 päivässä
(64 arvostelua)
5.6
expertcoder1vw

Hi, I can develop a Windows console application that will parse all text files and extract the required information. I can deliver in 5 days, with daily updates, until we get it right. This is my best rate for the Lisää

$120 USD 5 päivässä
(18 arvostelua)
4.7
markelof

Hello, I can do this for you. It's pretty much an easy task. I can complete it in one day. Contact me.

$55 USD 3 päivässä
(26 arvostelua)
4.6
LyudmilaSimeonov

Hi and thanks for sharing your project. I'm very much interested in your idea and definitely want to get involved. Please see my profile page for your reference and kindly open a chat with me to further discuss details Lisää

$40 USD 7 päivässä
(5 arvostelua)
3.5
bktk

Hi Dear Sir, after reading the project description, I am offering my services to deliver the project on urgent basis. Sir I am free to start work on project right now and sir I am offering free sample. Sir lets discu Lisää

$21 USD 2 päivässä
(35 arvostelua)
3.7
Khanmahfuj

Hello, I have read your job posting very carefully and understand your requirements. I can start your job right now and can finish within your time frame. So lets discuss about your job in private message. Best Regar Lisää

$40 USD 7 päivässä
(0 arvostelua)
0.0
abhirm88

I would be able to do it as per my skills. Also as a start in freelance i will get a chance to show my skills

$45 USD 10 päivässä
(0 arvostelua)
0.0
teknosolve4

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do Lisää

$65 USD 7 päivässä
(0 arvostelua)
0.0