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.

Using RegEx to remove the first two characters

By zuladabef,
June 9, 2021 in AutoIt General Help and Support

Followers 3

Go to solution Solved by TheXman, June 9, 2021

Prev
1
2
Next
Page 2 of 2

Sign In

Using RegEx to remove the first two characters

Recommended Posts

dmob

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Browse

AutoIt Resources

Release

Beta