How can I read certain data from my text file?

I have a text file that is formatted as such:

P_527=20024	-568251	0	0,	5908.191819 MHz
P_528=15789	-565446	0	0,	5910.010001 MHz
P_529=10575	-562629	0	0,	5911.828182 MHz
P_530=5744	-561325	0	0,	5913.646364 MHz

I need to read the first column into a vector without the " P_XXX= ", the entire second column, and the final column without the 'MHz'. I've successfully read the second column using textscan but cannot successfully read any of the other columns. Thank you for your help.

Answer 1

[Walter Roberson]

filename = 'test.txt';
fid = fopen(filename);
data = cell2mat(textscan(fid, '%*[^=]=%f %f %*f %*f, %f MHz'));
fclose(fid);