How do I ignore delimiter inside quotation marks using regexp?

4 次查看（过去 30 天）
Kilian Brandt
Kilian Brandt 2020-11-4
评论： Ameer Hamza 2020-11-6
Hi everyone,
I'm writing a script to import data. The size (coloumns) of the data can vary. The main delimiter is a semicolon.
My data looks like the following:
Header ; Value ; Data
Example1; 12 ; "air"
Example2; 24 ; "water"
For this usecase I'm using
filebyfield = regexp(filebyline, ';', 'split'); %filebyline- textfile including my data
Unfortunately the data I try to import isn't uniform and could look like the following:
Header ; Value ; Data
Example1; 12 ; "air;fire"
Example2; 24 ; "water"
Is there any way to ignore the delimiter (";") if its inside of quotation marks? I thought about textscan, but I don't have the same number of coloumns every time and therefore cant specify the data format.
Any help would be appreciated! Best regards

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-11-4
sometimes the easiest way is to detect the quoted delimiter and replace them with some special character such as ¡ and then do the split and then fix-up the results.
  4 个评论
显示 2更早的评论
Kilian Brandt
Kilian Brandt 2020-11-6
Thanks alot! It works perfectly.
I have an additional question about the first line:
filebyfield = regexprep(filebyfield, '("\w*);(\w*")', '$1@$2');
Could you please tell me if my assumptions about the terms
'("\w*);(\w*")' % finds the quoted ";" | "/w*" means characters with undefined length
and
'$1@$2' % "$1" stands for the first "("\w*)" and $2 for the second "("\w*)"
are correct?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by