https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59538#M13164 The Replace function expects literal values, not wildcards or regex patterns, eg Replace(""Anything"", ""Any"", ""Some"") = ""Something"" You could try combining the Mid and InStr functions, eg Mid([MyText], InStr([MyText], ""$"") + 1, Len([MyText])) If you want to use a regular expression then you'll need to use a code stage. Tue, 14 Nov 2017 13:47:00 GMT John__Carter 2017-11-14T13:47:00Z https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59537#M13163 I capture a Text from command line output,I need replace all characters after '$',I tried following ways,but both not work. Replace([output], "\$.*", "\$") Replace([output], "\\$.*", "\\$") Can we use regular expression in the replace function? how to use? Thanks Tue, 14 Nov 2017 12:14:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59537#M13163 JunTan 2017-11-14T12:14:00Z https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59538#M13164 The Replace function expects literal values, not wildcards or regex patterns, eg Replace(""Anything"", ""Any"", ""Some"") = ""Something"" You could try combining the Mid and InStr functions, eg Mid([MyText], InStr([MyText], ""$"") + 1, Len([MyText])) If you want to use a regular expression then you'll need to use a code stage. Tue, 14 Nov 2017 13:47:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59538#M13164 John__Carter 2017-11-14T13:47:00Z https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59539#M13165 Thanks Wed, 15 Nov 2017 14:27:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-use-pattern-in-replace-function/m-p/59539#M13165 JunTan 2017-11-15T14:27:00Z