Jump to content

stringregexpreplace question

MrCheese

By MrCheese,
in AutoIt General Help and Support

 Share Followers 0

Recommended Posts

MrCheese

MrCheese 1

Posted
Posted

argh, pulling my hair out.

considering this post: 

 

say for a string = "03a", how can I strip out the leading 0 and the a.

I have tried:

$new = StringRegExpReplace($string, '[^1-9][^0-9]', '')

 

and various combinations:

^0+[^0-9]

[^[:digit:]]

"[^0].*"

"^0*(d+)"

 

I'm going loopy!

 

 

Link to post
Share on other sites
mikell

mikell 1,140

Posted
Posted (edited)

This one will remove leading zero(s) and trailing non digit(s) - if exist 

$new = StringRegExpReplace($string, '^0*|\D*$', "")

Edit : comments
 You want your regex to have 2 different actions, so an alternation is needed
^0*  : zero or more "0" at the beginning of the string
|       : alternation
\D*$   :  zero or more non-digit characters at the end of the string

Edited by mikell
Link to post
Share on other sites
caramen

caramen 71

Posted
Posted (edited)

@mikell& @FrancescoDiMuro I am sure a single file that resuming all delimiter whould be apreciate from everyone. I know the help file is already here but... even for people who want to learn this part is hard.  

 

So yeah comment like this is realy appreciated.

 

In help file it is like that : 
  

^0*  : zero or more digit at the beginning of the string

(?: ... )   Non-capturing group. Does not record the matching characters in the array and cannot be re-used as backreference.
\D

Matches any non-digit.
[^ ... ]    Matches any character not in the set: "[^0-9]" matches any non-digit. To include a caret (^) in a set, put it after the beginning of the set or escape it (\^).

But we dont got that with exemple at each delimiter : 

^0*  : zero or more "0" at the beginning of the string
|       : alternation
\D*$   :  zero or more non-digit characters at the end of the string

It whould simplifi the life of all beginner. Since i am not strong at it i cannot do that :( 

Edited by caramen

My video tutorials : ( In construction )  || My Discord : https://discord.gg/S9AnwHw

How to Ask Help ||  UIAutomation From Junkew || WebDriver From Danp2 || And Water's UDFs in the Quote

Spoiler

 Water's UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:
ADO - Wiki

 

Link to post
Share on other sites
iamtheky

iamtheky 932

Posted
Posted (edited)

not for nothing, but if your only criteria are stripping leading zeroes and removing trailing non-number characters 

$new = number("03a")

 

Edited by iamtheky
grammar 

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Link to post
Share on other sites
mikell

mikell 1,140

Posted
Posted

iamtheky,
Very smart non-regex way  :D
I made a regex-oriented answer because ... of the title of the topic. Nothing personal  :P


caramen,
The help file provides explicit details and explanations about the syntax, and should constantly be used as reference and be read carefully to avoid confusion
Examples : 

^0*  : zero or more digit at the beginning of the string

This is false. "0" means only 0 . A digit is \d, or [0-9], or [[:digit:]]  (all the same)

Ditto for ^ , which matches "start of string" but is also used inside a character class to negate its content
So to match any non-digit, you might use \D , or [^0-9] , or  [[:^digit:]]

Link to post
Share on other sites
jchd

jchd 1,810

Posted
Posted
On 22/10/2018 at 2:19 PM, mikell said:

A digit is \d, or [0-9], or [[:digit:]]  (all the same)

Not exactly all the same.

When/if (*UCP) is used, [0-9] does exactly what it means (ASCII 0 to ASCII 9) while both other forms include codepoins that have the Nd (Numeric Decimal) properties. And that is a number of characters: from old Unicode v5.1:

Codepoint    Glyph    CharacterName
U+00030     '0'     DIGIT ZERO
U+00660     '٠'     ARABIC-INDIC DIGIT ZERO
U+006F0     '۰'     EXTENDED ARABIC-INDIC DIGIT ZERO
U+007C0     '߀'     NKO DIGIT ZERO
U+00966     '०'     DEVANAGARI DIGIT ZERO
U+009E6     '০'     BENGALI DIGIT ZERO
U+00A66     '੦'     GURMUKHI DIGIT ZERO
U+00AE6     '૦'     GUJARATI DIGIT ZERO
U+00B66     '୦'     ORIYA DIGIT ZERO
U+00BE6     '௦'     TAMIL DIGIT ZERO
U+00C66     '౦'     TELUGU DIGIT ZERO
U+00CE6     '೦'     KANNADA DIGIT ZERO
U+00D66     '൦'     MALAYALAM DIGIT ZERO
U+00E50     '๐'     THAI DIGIT ZERO
U+00ED0     '໐'     LAO DIGIT ZERO
U+00F20     '༠'     TIBETAN DIGIT ZERO
U+01040     '၀'     MYANMAR DIGIT ZERO
U+01090     '႐'     MYANMAR SHAN DIGIT ZERO
U+017E0     '០'     KHMER DIGIT ZERO
U+01810     '᠐'     MONGOLIAN DIGIT ZERO
U+01946     '᥆'     LIMBU DIGIT ZERO
U+019D0     '᧐'     NEW TAI LUE DIGIT ZERO
U+01B50     '᭐'     BALINESE DIGIT ZERO
U+01BB0     '᮰'     SUNDANESE DIGIT ZERO
U+01C40     '᱀'     LEPCHA DIGIT ZERO
U+01C50     '᱐'     OL CHIKI DIGIT ZERO
U+024EA     '⓪'     CIRCLED DIGIT ZERO
U+024FF     '⓿'     NEGATIVE CIRCLED DIGIT ZERO
U+0A620     '꘠'     VAI DIGIT ZERO
U+0A8D0     '꣐'     SAURASHTRA DIGIT ZERO
U+0A900     '꤀'     KAYAH LI DIGIT ZERO
U+0AA50     '꩐'     CHAM DIGIT ZERO
U+0FF10     '０'     FULLWIDTH DIGIT ZERO
U+104A0     '𐒠'     OSMANYA DIGIT ZERO
U+1D7CE     '𝟎'     MATHEMATICAL BOLD DIGIT ZERO
U+1D7D8     '𝟘'     MATHEMATICAL DOUBLE-STRUCK DIGIT ZERO
U+1D7E2     '𝟢'     MATHEMATICAL SANS-SERIF DIGIT ZERO
U+1D7EC     '𝟬'     MATHEMATICAL SANS-SERIF BOLD DIGIT ZERO
U+1D7F6     '𝟶'     MATHEMATICAL MONOSPACE DIGIT ZERO
U+E0030     '󠀰'     TAG DIGIT ZERO


It's a pity that most glyphs don't show up correctly. That's the extra price you pay for being born in a non-latin script area.

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Link to post
Share on other sites
jchd

jchd 1,810

Posted
Posted

It's simply that we, occidentals, are soooo used to think only within some kind of ASCII that we too often forget that the vast majority of humans don't use any form of latin scripts, letters, digits and punctuation.

Unicode tries hard (and succeeeds) to include less known (to occidentals) scripts and hence makes the less "common" scripts a tangible reality.

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Followers 0
Go to topic listing

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • RAMzor
      Extract hex number from string
      By RAMzor
      Hi everyone,
      I have this string:
      "main_lot      0x111” & @CRLF & “main_version          0xABC” & @CRLF & “main_number 0xDEAD123” & @CRLF & “main_version          0x333"
      And I'm trying to extract one specific hexadecimal number, actually main_version from this string by using StringRegExp:
      How to get 'ABC' from it?
      I'm not sure if the original string uses @CRLF, @CR or @LF as a line breaks (received from linux over ssh plink.exe) I have tried this code but it doesn't work 
      #include <Array.au3> $sLog = "main_lot 0x111” & @CRLF & “main_version 0xABC” & @CRLF & “main_number 0xDEAD123” & @CRLF & “main_version 0x333" $aVer = StringRegExp($sLog, "main_version\h*(.+)(?:0[xX][[:xdigit:]])", 3) _ArrayDisplay($aVer)  
       
    • Tosyk
      Make a metasymbol condition to make operations over the text file line
      By Tosyk
      Hi,
      Please help me to change metasymbol line. Right now I have this condition code:
      If StringInStr($_sName, 'TEXT ') Then $_sName = StringRegExpReplace($_sName, '(^.*)\TEXT (.*)$', '$2') $_sName = StringRegExpReplace($_sName, '(^.*)\ (.*)$', '$1') If Not CheckIsSave_($_sName) Then It work fine with this text file and finds each line which start from 'TEXT':
      Material B7E671143D244B ==================================== TEXT 2F3139D816C34D 1 TEXT B6A968EF2505A2 1 TEXT 35206697A04F91 1 TEXT EB485AF490D83D 1 TEXT 0DAB42294BD9B3 1 TEXT 3D6525BEE360E1 0 Material D6906B886B06E3 ==================================== TEXT 0CCECCCCFB62AE 1 TEXT 1E14CB29AB43F0 1 TEXT FB7F0DCE9B5950 1 But I have a new text file now the lines of which now are start with 0:, 1: and so on:
      sm_0 --------------- 0: dummy_gray 1: c_com_socksa_mt 2: c_com_socksa_tn 3: dummy_white 4: default_z 5: dummy_nmap 6: --- 7: --- sm_1 --------------- 0: c_com_prisoner_shoes_di 1: c_com_prisoner_shoes_mt 2: c_com_prisoner_shoes_tn 3: dummy_white 4: default_z 5: c_com_leatherb_rt 6: --- 7: --- how to change (or add) the condition code above to work with new text file?
      I'm trying to change this script: http://autoit-script.ru/threads/poisk-fajlov-rekursivno-po-dannomu-spisku.26970/post-148646
       
    • seadoggie01
      RegExp Multiline Comments
      By seadoggie01
      I'm trying to capture everything after a "#ToDo" in my scripts. I got that like this:
      (?i)[^\v]*#todo(.*) But then I thought it would be nice to use underscores to continue the ToDo... kind of like this:
      #ToDo: This is a really long explanation about something _ # that is very in-depth and needs to take up a lot of _ # space in a ToDo comment Global $variables = "Bad" I can't seem to capture everything... and maybe I'm trying to do too much with Regex... I keep trying variations of this:
      Condensed Version: (?im)[^\v]*#todo(?:([^\v]*)_\s*)*#([^\v]*) Expanded with comments (?ixm)(?# Ignore case, ignore newlines in Regex, use multiline option)# [^\v]*(?# Match leading space/s)# \#todo(?# Match the #todo)# (?:([^\v]*)_\s*)*(?# Match lines ending with _)# \#([^\v]*)(?# Last line only, no _'s)# I never seem to be able to build an array well with Regex... I saw something once about not being able to capture repeated patterns, and I think that's my issue
    • genius257
      StringRegExpSplit
      By genius257
      Inspired by PHP's preg_split.
      Split string by a regular expression.
      Also supports the same flags as the PHP equivalent.
      v1.0.1
       
      Example:
      #include "StringRegExpSplit.au3" StringRegExpSplit('splitCamelCaseWords', '(?<=\w)(?=[A-Z])') ; ['split', 'Camel', 'Case', 'Words']  
    • RAMzor
      RegExp - Remove white spaces before and after coma
      By RAMzor
      Hi guys I need your help.
      I have string like this : "TDM111A5,      RCT222Y5/ 7  ; FDT444E4 /8 , ABC222R5"
      I need find a coma or semicolon and delete white spaces before and after them
      The output should be a string and/or array 
      String : "TDM111A5,RCT222Y5/ 7;FDT444E4 /8,ABC222R5"
      Array:
      TDM111A5
      RCT222Y5/ 7
      FDT444E4 /8
      ABC222R5
×
×
  • Create New...