Forum Discussion
Identify first row as header from delimited text file.
Nothing additional is required. For example, such .txt file
Branch|Application|Date A|ab|20170801 B|CD|20170802
could be imported into the Excel by two ways with results as
However, to transfer the number as 20170801 into correct date few additional simple steps will be required to instruct Excel how to transform. With correct source format (in my case ISO one as yyyy-mm-dd) the importing automatically recognize correct date format
Hi,
In general nothing additional is required if your data have same delimiter as first row. Modern Get&Transform will convert your data into Excel table; legacy Get Data from text creates the range which you could easily transform into the table.
The point it delimiter is to be the same for all rows, otherwise you need to do some additional transformations.
- The delimiter is the vertical bar or "pipe" symbol "|" and is the same for all rows. I was wondering if I could make a change in my program to create the text file that tells Excel: 1) the first row consists only of column headers and 2) create usage for specific fields like a date in YYYYMMDD format for example.
Thanks for looking at it.Nothing additional is required. For example, such .txt file
Branch|Application|Date A|ab|20170801 B|CD|20170802
could be imported into the Excel by two ways with results as
However, to transfer the number as 20170801 into correct date few additional simple steps will be required to instruct Excel how to transform. With correct source format (in my case ISO one as yyyy-mm-dd) the importing automatically recognize correct date format
- I reran it so dashes were inserted after the year and month--worked great.
Thanks!
