377493_zh-TW

liliconcom

提取逗號前後的數字

你好，

我正在努力從字串中提取逗號前後的數字。

如何從字串中取得 0.98 和 0.97？

string = "A_BD_CEEE:0.98,0.975620708";

first_number = Num( Regex( string, "(\d\d?\d?):", "\1" ) );

預期結果

first_number = 0.98

第二個數字 = 0.975

thanks</CODE></P> <BR /> </LINGO-BODY> <LINGO-LABS id="lingo-labs-377493" slang="en-US" mode="UPDATE"> <LINGO-LABEL>品質與工藝工程</LINGO-LABEL> </LINGO-LABS> <LINGO-SUB id="lingo-sub-377518" slang="en-US" mode="NONE">Re: 提取逗號前後的數字</LINGO-SUB><LINGO-BODY id="lingo-body-377518" slang="en-US" mode="NONE"><P>除了解決<A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366" target="_blank">@jthi</A> ,</P><P>關於正則表達式有很好的文檔：</P><P><A href="https://www.jmp.com/support/help/en/16.0/jmp/regular-expressions.shtml#" target="_blank" rel="noopener noreferrer">https://www.jmp.com/support/help/en/16.0/jmp/regular-expressions.shtml#</A></P><P>您最初的方法的問題是，在 : 之前沒有數字，只有在之後。</P><P>你需要包括 .進入字符串以獲得第一個數字。 請參閱下面的更改。</P><P>正則表達式值得學習，因為它真的很強大。</P><P>&nbsp;</P><PRE><CODE class=" language-jsl">string = "A_BD_CEEE:0.98,0.975620708"; first_number = Num( Regex( string, ":(\d.\d?\d?)", "\1" ) );

 

Re: 提取逗號前後的數字

如果數字不能為負，這應該有效：

 

Names Default To Here(1);

string = "A_BD_CEEE:0.98,0.975620708";
numString = Regex Match(string, "(\d+.\d*),(\d+.\d*)");
first_number = Num(numString[2]);
second_number = Num(numString[3]);
Show(first_number, second_number);

 

Re: 提取逗號前後的數字

這是我會怎麼做

names default to here(1);
string = "A_BD_CEEE:0.98,0.975620708";

first number=num(word(2,string,":,"));
second number = round(num(word(3,string,":,")),3);