Hello, 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: Comment: Operator: BD: D_C TS: 2014-05-02T05:22:08.3119997 CFile: C_2014_04_24-11_30_39_M2.ini File: 20140423-PRD.ini LTemp: 23.0 FCW: I : -0.00047565 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] D_C 2014-05-02T05:22:08.3119997 C_2014_04_24-11_30_39_M2.ini 20140423-PDR.ini 23 NaN 0.653 Thank you
... View more