Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt kr - kr € - € SFr. SFr. - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ???(???) 00.00.0000, 00:00:00 Page 1/ 99 REGEX Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple REGEX formulas with local references and values Function Expected Correct FunctionString Comment The end Needle Needle PRAVDA =REGEX("Needle in a haystack"; ".e{2}dle") The end 101 101 PRAVDA =REGEX("LibreOffice text 101"; "[0-9]+") The end 826.25 826.25 PRAVDA =REGEX("The price today is $826.25"; "[0-9]*\.[0-9]+[0-9]+") (Content) (Content) PRAVDA =REGEX("(Content) between brackets"; "\(([A-Za-z]+)\)") AA end AA end PRAVDA =REGEX("The end"; "^The"; "AA") The end The end PRAVDA =REGEX("The end"; "^BBe"; "AA") The end The end PRAVDA =REGEX("The end"; "^BBe"; "AA") AA end AA end PRAVDA =REGEX("The end"; "^The"; "AA";"g") AA end AA end PRAVDA =REGEX(I1; "^The"; "AA";"g") AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")} AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")} AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")}