Identify first row as header from delimited text file.

I am fairly new with spreadsheets but am trying to create a delimited txt file to be imported through a COBOL program. The first line looks something like: Branch|Application|Date ............ ...

excel

SergeiBaklan
Aug 25, 2017
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

SergeiBaklan

Diamond Contributor

Aug 25, 2017

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

wporter

Copper Contributor

Aug 25, 2017

I reran it so dashes were inserted after the year and month--worked great.
Thanks!

Forum Discussion

Identify first row as header from delimited text file.

Resources