08-29-2014 12:54 PM
I have a txt file that gives me the data as shown below, but even I try to import it into SAS JMP it only gave me two columns with the data. I'll like to know if there is a way to use the first column as the column name and the second part after ":" as my data it self. I have multiple files and once I'm able to rearrange the data I'll concatenate them row after row.
Data from .txt:
eta [%]: NaN
M A [m2]: 0.65300
This is how I'll like to see it...
|Comment:||Operator:||BD:||TS:||Cfile:||File:||Ltemp:||FCW:||I||eta[%]||M A [m2]|