I have data that has a pattern. In that pattern, I want to trim the first two digits, if those digits start with "10" and maintain the rest of the string. For example, if the data is this: Input ==> Desired Output 1019002LP ==> 19002LP 1024001LW ==> 24001LW 1040001LP ==> 40001LP 1019001LP ==> 19001LP 1150001LP ==> 1150001LP The string is always 9 characters long. The first seven characters are always digits and the last two are always letters. Below is my starting code. Thanks Const $TEST_DATA = "Lorem ipsum dolor sit amet, consectetur adipiscing 1019002LP elit, " & _ "sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut 1024001LW enim ad minim veniam," & _ "quis nostrud exercitation ullamco 1040001LP laboris nisi ut aliquip 1019001LP ex ea commodo consequat. Duis aute " & _ "irure dolor in reprehenderit in voluptate velit 1150001LP esse cillum dolore eu fugiat nulla pariatur. " example() Func example() Local $sPattern = "(?i)\h+\b(10\d{7}\w{2})\b" Local $sOutPut = StringRegExpReplace($TEST_DATA, $sPattern, @TAB & "\1") ;Find the pattern and trim the first two digits, if those digits are 10 ConsoleWrite($sOutPut & @CRLF) EndFunc ;==>example

Maybe something like this? Const $TEST_DATA = _ "Lorem ipsum dolor sit amet, consectetur adipiscing 1019002LP elit, " & _ "sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut 1024001LW enim ad minim veniam," & _ "quis nostrud exercitation ullamco 1040001LP laboris nisi ut aliquip 1019001LP ex ea commodo consequat. Duis aute " & _ "irure dolor in reprehenderit in voluptate velit 1150001LP esse cillum dolore eu fugiat nulla pariatur. " example() Func example() Local $sPattern = "(?i)\b10(\d{5}[a-z]{2})\b" Local $sOutPut = StringRegExpReplace($TEST_DATA, $sPattern, "\1") ConsoleWrite($sOutPut & @CRLF) EndFunc ;==>example Console output: Lorem ipsum dolor sit amet, consectetur adipiscing 19002LP elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut 24001LW enim ad minim veniam,quis nostrud exercitation ullamco 40001LP laboris nisi ut aliquip 19001LP ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit 1150001LP esse cillum dolore eu fugiat nulla pariatur. Regular Expression Description Below: Your regular expression had a few issues: "(?i)\h+\b(10\d{7}\w{2})\b" Not sure why you have "\h+" in your regular expression. You didn't specify that you wanted to trim the leading spaces. If you exclude "10", then there would only be 5 remaining digits in the capture group, not 7. "10" should not be inside your capture group. You said that you only want to capture the remaining 5 digits and the 2 letters at the end. "\w" includes [A-Za-z0-9_] which means it would have also included strings with numeric digits and/or underscores at the end, not just letters. Not a significant issue but, your regular expression did not need "(?i)" because you didn't specify letters within the expression. So case was not an issue.