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
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
