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
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
If this is a question about JMP, you should post it to the JMP User Community at
PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.