How to import a txt file with the format 'Di 02.07.1991 1718,02'

How to import the file without the weekday, probably change from dd.mm.yyyy to mm/dd/yyyy or datenum and change the decimal separator from ',' to '.'.

Answers (1)

fmt='%s %2d.%2d.%4d %4d,%2';
Build the time value as the next_to_last_column_value*100+last_column_value
Alternatively, read the whole file into memory as character array and do a global substitution for the comma with a period and then parse from memory with
fmt='%s %2d.%2d.%4d %f';

This question is closed.

Asked:

on 28 Jul 2015

Closed:

on 20 Aug 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!