Extracting string and number pairs from a mixed string
現在この質問をフォロー中です
- フォローしているコンテンツ フィードに更新が表示されます。
- コミュニケーション基本設定に応じて電子メールを受け取ることができます。
エラーが発生しました
ページに変更が加えられたため、アクションを完了できません。ページを再度読み込み、更新された状態を確認してください。
古いコメントを表示
Dear all,
I have read in material data and have gotten an array of chemical compositions of the type (chr):
'Fe61Zr8Co7Mo15B7Y2' sometimes even '(Fe0.5Co0.5)58.5Cr14Mo6C15B6Er0.5' wherein Fe and Co have a percentage of 29.25 (58.5*0.5...).
How do I extract the chemical composition so that I receive an array (or two) like
['Fe', 'Zr', 'Co', 'Mo', 'B', 'Y'; 61, 8, 7, 15, 7, 2]?
I am somehow failing to use sscanf correctly, e.g. numbers = sscanf('Fe61Zr8Co7Mo15B7Y2', '%f') won't do anything since I need to omit varying strings :(
Thanks a lot in advance!
Greetings
Lukas
採用された回答
The two lines marked with %%% are used to convert substrings like '(Fe0.5Co0.5)58.5' into 'Fe29.25Co29.25', after which the designator+number matching and extraction is easy:
>> str = '(Fe0.5Co0.5)58.5Cr14Mo6C15B6Er0.5';
>> baz = @(s,b)regexprep(s,'(\d+\.?\d*)','${num2str(str2double($1)*str2double(b))}'); %%%
>> tmp = regexprep(str,'\((([A-Z][a-z]*\d+\.?\d*)+)\)(\d+\.?\d*)','${baz($1,$2)}'); %%%
>> out = regexp(tmp,'([A-Z][a-z]*)(\d+\.?\d*)','tokens');
>> out = vertcat(out{:})
out =
'Fe' '29.25'
'Co' '29.25'
'Cr' '14'
'Mo' '6'
'C' '15'
'B' '6'
'Er' '0.5'
>> str2double(out(:,2)) % optional
ans =
29.25
29.25
14
6
15
6
0.5
The code uses two layers of dynamic regular expression, the first calls baz for each each '(AxBy...)N' substring, then inside baz each of x, y, etc. is multiplied with N. The result is converted to char for reinsertiion.
6 件のコメント
LukasJ
2020 年 2 月 14 日
Thank you so much for this solution!
I am unfortunately not on a Matlab-level to comprehend it (also the first time i tried to use regexp) :(.2nd line creates a function, baz, with the variables (s,b), I guess. Then baz is called in executing regexprerp again?
Is there any tutorial I could use, to be able to write code like this myself? Regexp and regexprep appear to be very powerful but the inputs look kind of chaotic...
"2nd line creates a function, baz, with the variables (s,b), I guess"
Yes, it defines an anonymous function with two input arguments:
"Then baz is called in executing regexprerp again?"
The function |baz| is called by |regexprep| on the third line. For your example string its two inputs will be 'Fe0.5Co0.5' and '58.5'.
"Is there any tutorial I could use, to be able to write code like this myself?"
Read the documentation, try the examples.
"Regexp and regexprep appear to be very powerful but the inputs look kind of chaotic"
Regular expressions are a language unto themselves. They require practice and reading the documentation again and again and again and again and again...
In this case I also used dynamic regular expressions to call |baz| and to recalculate those numeric values:
Here is a breakdown of the regular expressions:
'(\d+\.?\d*)' % match integer or decimal number
( % start group 1
\d+ % one or more digits
\.? % optional period character
\d* % zero or more digits
) % end group 1.
'\((([A-Z][a-z]*\d+\.?\d*)+)\)(\d+\.?\d*)' % match e.g. '(Fe0.5Co0.5)58.5' % FIXED
\( % literal left parenthesis
( % start group 1
( % start group 0
[A-Z] % match one A-Z character
[a-z]* % match zero or more a-z characters
\d+\.?\d* % like 1st regex, match integer or decimal % FIXED
)+ % one or more of group 0
) % end group 1
\) % literal right parenthesis
( % start group 2
\d+\.?\d* % like 1st regex, match integer or decimal
) % end group 2
'([A-Z][a-z]*)(\d+\.?\d*)' % match e.g. 'Cr14' or 'Fe29.25'
( % start group 1
[A-Z] % match one A-Z character
[a-z]* % match zero or more a-z characters
) % end group 1
( % start group 2
\d+\.?\d* % like 1st regex, match integer or decimal
) % end group 2
You can see that the regular expressions always match the numbers and the element symbols in the same way, just group them in slightly different ways. The groups are referred to using |$1| and |$2| in the replacement expressions.
You might also like to download my interactive tool IRGEXP:
LukasJ
2020 年 2 月 14 日
Thank you so much!
I was hoping for an easy way, as the api examples will never completly match any applications I get but I guess there is only the hard way then... and your breakdown of regular expressions! Thanks again!
LukasJ
2020 年 6 月 15 日
Dear Stephen,
unfortunately I have run into trouble again and I am (still) not on a level to adjust the code you created. Multiple errors occur in my data, e.g.:
(Fe71.2B24Y4.8)92Nb8 is giving me
"Fe" "71.2"
"B" "24"
"Y" "4.8"
"Nb" "8"
wherein apparently Fe, B, Y haven't been multiplied by 92 or rather 0.92. I suppose that's because baz only takes two inputs (str2double is called twice in baz).
Another issue are compositions which contain more "subcompositions" and are separated by other brackets.
e.g. I read in
str = '{[(Fe0.6Co0.4)0.75B0.2Si0.05]0.96Nb0.04}96Cr4'
expecting it to not work since there are {, } and [,] I simply replaced those by ( and )... Well that didn't work either :D. For str I get
"Fe" "0.45"
"Co" "0.3"
"B" "0.2"
"Si" "0.05"
"Nb" "0.04"
"Cr" "4"
:(
Also when I try to modify the regexp like
regexp = '(\(|\[|\{)(([A-Z][a-z]*\d+\.\d*)+)(\}|\]|\))(\d+\.?\d*)'
that won't match anything more than before since there are brackets within the outer curly or edgy brackets.
Thanks a lot for your help so far!
Best wishes,
Lukas
Off-Topic: Is that Cheburashka in your profile picture?
The reason is that I missed a question mark here:
tmp = regexprep(str,'\((([A-Z][a-z]*\d+\.?\d*)+)\)(\d+\.?\d*)','${baz($1,$2)}')
% ^ missing
which meant that the regular expression did not match integer numbers, only numbers with a decimal point.
With that question mark in place (I have now corrected the question and comments), this is the output:
>> out = regexp(tmp,'([A-Z][a-z]*)(\d+\.?\d*)','tokens');
>> out = vertcat(out{:})
out =
'Fe' '6550.4'
'B' '2208'
'Y' '441.6'
'Nb' '8'
"Another issue are compositions which contain more "subcompositions" and are separated by other brackets."
Regular expressions alone are not really suitable for this. For parsing arbitrarily nested brackets like that you will probably have to write your own string parser, e.g. based on a recursive function which uses regular expressions or other string manipulation inside it. Have you worked with recursive functions before?
Чебура́шка, да!
But this output is also wrong! The numbers should sum-up to 1 or 100 and the proportion of Fe should then be 0.65504. The complete output should be:
out =
'Fe' '0.65504'
'B' '0.2208'
'Y' '0.04416'
'Nb' '0.08'
The issues come from the inconsistent notation in the dataset I guess :(.
"Have you worked with recursive functions before?"
I vaguely remember writing the Fibonacci-series as a function during my bachelor studies... But I don't think I'm capable of applying any of that on this problem in a finite amount of time :D
I will probably just iterate over all the "unclear" cases where { and [ occur, extract whats inside and then apply your function.
e.g. match
regexp = '\{.+\}'
And then check what's inside.
At least that would be feasible for me to do :)
その他の回答 (1 件)
LukasJ
2020 年 2 月 13 日
ok so
numbers = str2double(regexp(myString,'[\d.]+','match')); does give me the numbers
but
words = regexp(myString,'[\w*]+','match')); does not give me the chemical notations, probably because those aren't "words" :/
カテゴリ
ヘルプ センター および File Exchange で Characters and Strings についてさらに検索
参考
Web サイトの選択
Web サイトを選択すると、翻訳されたコンテンツにアクセスし、地域のイベントやサービスを確認できます。現在の位置情報に基づき、次のサイトの選択を推奨します:
また、以下のリストから Web サイトを選択することもできます。
最適なサイトパフォーマンスの取得方法
中国のサイト (中国語または英語) を選択することで、最適なサイトパフォーマンスが得られます。その他の国の MathWorks のサイトは、お客様の地域からのアクセスが最適化されていません。
南北アメリカ
- América Latina (Español)
- Canada (English)
- United States (English)
ヨーロッパ
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
