Parsing a word document into a csv or other machine readable format

dal2111

New Member
Joined
Mar 19, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hi all,

I have a non-delimited text file of health data called "2013_data.txt". This text file doesn't have any structure to it and the only way to structure it into columns and rows is to use the specified fixed length positions for each variable as indicated by the data dictionary "UserGuide2013.pdf".

So basically I would like to transfer each variable's character fixed positions (e.g. variable MAGER is characters 75-76) into a csv or machine-readable format. All of the other information about the variable I don't really care.

I want "UserGuide2013.pdf" -> properly formatted csv - something that looks like this (it's ok if it's not PERFECT, I can always do manually edits, but as long as it takes some of the work out of it, because I have many files like this)

Many thanks,
David
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

dal2111

New Member
Joined
Mar 19, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I should specify the data dictionary UserGuide2013.pdf" starts at page 11 and on. Those are the pages I'm interested in converting to csv
 

Watch MrExcel Video

Forum statistics

Threads
1,129,278
Messages
5,635,254
Members
416,849
Latest member
truerock

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top