striker359
Board Regular
- Joined
- Jun 19, 2014
- Messages
- 64
Hi,
I'm completely new to macro building but here goes:
I would like to extract info from an external txt file into Excel. For example:
txt file:
/* ----------------- Dummy ------------------- */
JobName: Dummy
send_notifications: y
max_runs: 5
/* ----------------- TAF-O-FF401D ------------------- */
JobName: TAF-O-FF401D
send_notifications: y
max_runs: 5
I would require a way to read the item category (JobName, send_notifcations, max_runs), for lack of a better term, and then to populate the corresponding info into specific columns in Excel.
For example:
JobName (Dummy) in Column A
send_notifications in Column B
max_runs (5) in Column C
With the /* ----------------- JobName ------------------- */ indicating a new job entry, I would require the next job entry to be on the next row and so on till there are no more job entries left.
Thanks in advance!
I'm completely new to macro building but here goes:
I would like to extract info from an external txt file into Excel. For example:
txt file:
/* ----------------- Dummy ------------------- */
JobName: Dummy
send_notifications: y
max_runs: 5
/* ----------------- TAF-O-FF401D ------------------- */
JobName: TAF-O-FF401D
send_notifications: y
max_runs: 5
I would require a way to read the item category (JobName, send_notifcations, max_runs), for lack of a better term, and then to populate the corresponding info into specific columns in Excel.
For example:
JobName (Dummy) in Column A
send_notifications in Column B
max_runs (5) in Column C
With the /* ----------------- JobName ------------------- */ indicating a new job entry, I would require the next job entry to be on the next row and so on till there are no more job entries left.
Thanks in advance!
Last edited: