Hi António Subject to testing, that's it! Many thanks.
Paul On 12/12/2022 13:54, António Tavares Lopes wrote:
Paul, An implementation of the NumberAtEnd method using Regular Expressions (changed the pattern to give a bit more robustness): m.acid1 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)" m.acid2 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid" ? NumberAtEnd(m.acid1) && 2.13 ? NumberAtEnd(m.acid2) && FAIL FUNCTION NumberAtEnd (Test AS String) AS String LOCAL Regx AS VBScript_RegExp_55.RegExp LOCAL Matches AS VBScript_RegExp_55.MatchCollection LOCAL Result AS String m.Regx = CREATEOBJECT("VBScript.RegExp") m.Regx.Pattern = "(\(([0-9]+(\" + SET("Point") + "[0-9]+)?)\))$" m.Matches = m.Regx.Execute(m.Test) IF m.Matches.Count == 1 m.Result = m.Matches.Item(0).SubMatches.item(1) ELSE m.Result = "FAIL" ENDIF RETURN m.Result ENDFUNC On Mon, Dec 12, 2022 at 1:10 PM Paul Newton<[email protected]> wrote:Hi all I've been very quiet for a while so I thought it was about time I chimed in again. I have come across the use of a regex expression in another language which works like this: acid1 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)" acid2 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid" NumberAtEnd:= proc(S::string) description "Extract a parenthesized number, possibly containing periods, from the end of a string": local r; if StringTools:-RegMatch("\\(([0-9.]*)\\)$", S, r$2) then r else FAIL fi end proc: NumberAtEnd(acid1) returns "2.13" NumberAtEnd(acid2) returns "FAIL" How can this be done in VFP? Many thanks Paul Newton *** *
[excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
