How to load a .dat (comma-separated)

How can I read a file in .dat format, which has three commas in each row and only the second is a separator? The others are decimal separators.
Maybe I do not explain my problem sufficiently, so I attach the mentioned file.

 Accepted Answer

v=importdata('1.dat')
w=v(1:2:end)
out=regexprep(w,'(?<=\S+,\S+),', ' ')

2 Comments

Thank you for your quick answer. Please, what would be different if I need to remove all the commas?
out=regexprep(w,',', ' ')

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!