Can regexprep be used for partial text replacements containing special characters?

1 view (last 30 days)
I have a text file containing the following 3 lines of data:
"028 2016 10:11:12.12345" 39.028469 -104.484128 2070
"028 2016 10:11:13.1234" 39.028404 -104.484111 2075
"028 2016 10:11:14" 39.028390 -104.484000 2080
I am attempting to use regexprep to replace the time stamp portion (in quotations) with a single numerical value. If successful, the 3 lines of data would look like this:
1 39.028469 -104.484128 2070
2 39.028404 -104.484111 2075
3 39.028390 -104.484000 2080
I'm looking for a reference in the MATLAB documentation that would indicate how to account for the quotation marks, as well as all characters between them. This is my first attempt at using regexprep and I'm not even sure this is possible.
Is there a way to utilize regexprep for this instance?
Thank you.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 25 Mar 2016
Edited: Azzi Abdelmalek on 25 Mar 2016
v=importdata('file.txt')
a=regexprep(v,'\<".+"\>','')
b=regexp(a,'\S+','match')
n=numel(b);
out=[(1:n)' str2double(reshape([b{:}],n,[]))]
  3 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 25 Mar 2016
Another alternative is
v=importdata('fic.txt')
w=num2cell(1:numel(v))'
a=cellfun(@(x,y) regexprep(x,'\<".+"\>',num2str(y)),v,w,'un',0)

Sign in to comment.

More Answers (0)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!