Jump to content

Recommended Posts

Hello,

I need some help to parse the Green highlighted value with from below text:

RESISTOR  THICK FILM 4.64K ±1% 1/4W ±100PPM/°C 1206 SMT
RESISTOR  THICK FILM 3.83K ±1% 1/4W ±100PPM/°C 1206 SMT
RESISTOR CARBON FILM 22K ±10% 1/2W AXIAL THT
RESISTOR  WIREWOUND  22 ±5% 3W ±30PPM/°C AXIAL THT
RESISTOR  METAL OXIDE 4.7K ±5% 2 W ±300PPM/°C AXIAL THT
RESISTOR  THICK FILM 0   1/8W  0805 SMT

I am using positive look behind.:

(?<=FILM|WOUND|OXIDE).+

Can only pull this off:

4.64K ±1% 1/4W ±100PPM/°C 1206 SMT
3.83K ±1% 1/4W ±100PPM/°C 1206 SMT
22K ±10% 1/2W AXIAL THT
 22 ±5% 3W ±30PPM/°C AXIAL THT
4.7K ±5% 2 W ±300PPM/°C AXIAL THT
0   1/8W  0805 SMT

I'm trying the \b word boundary to no avail at this point. Appreciate if anyone would guide me on this?

Share this post


Link to post
Share on other sites

@guner7

You don't need to use lookbehind (even if you could), and since you are trying to extract digit(s) only, plus the character K (which could be replaced as \w* if you have any other engineering unit), you could use a pattern like this one:

'(?:FILM|WIREWOUND|OXIDE)\s*(\d+\.?\d*K?)'

:)


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites
9 minutes ago, FrancescoDiMuro said:

'(?:FILM|WIREWOUND|OXIDE)\s*(\d+\.?\d*K?)'

That works like charm. Thank you.

Why \s* able to tell regex not to capture?

Share this post


Link to post
Share on other sites

@guner7
You're welcome.

1 hour ago, guner7 said:

Why \s* able to tell regex not to capture?

Everything that is in a pair of round parenthesis is captured, as long as there's no captouring groups, atomic groups, or lookaround.
Since the \s* is outside the round parenthesis, it is not captured :)


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites

think you can also pull it off focusing on the K (or lack thereof)

#include<array.au3>

$s = "RESISTOR  THICK FILM 4.64K ±1% 1/4W ±100PPM/°C 1206 SMT" & @LF & _
"RESISTOR  THICK FILM 3.83K ±1% 1/4W ±100PPM/°C 1206 SMT" & @LF & _
"RESISTOR CARBON FILM 22K ±10% 1/2W AXIAL THT" & @LF & _
"RESISTOR  WIREWOUND  22 ±5% 3W ±30PPM/°C AXIAL THT" & @LF & _
"RESISTOR  METAL OXIDE 4.7K ±5% 2 W ±300PPM/°C AXIAL THT" & @LF & _
"RESISTOR  THICK FILM 0   1/8W  0805 SM"

$a = stringregexp(stringstripws($s , 4) , "(?m)(\d+\.*\d*?K*)(?:\s+).*" , 3)
_ArrayDisplay($a)

 


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

Share this post


Link to post
Share on other sites

Don't forget resistors of high and low values: MΩ, GΩ (if working with very high voltage), mΩ and even µΩ (e.g. current sense resistors). Also, kilo is k, not K but that is possible to cope with this.

It's probable that a BOM can refer to "CAPACITOR MKP X2", hence digits in designations may occur, depending on the nomenclature used.

Provided fractional values have a leading zero (e.g. 0.27 = 270mΩ):

#include <array.au3>

Local $sRes =   "RESISTOR  THICK FILM 4.64K ±1% 1/4W ±100PPM/°C 1206 SMT" & @LF & _
                "RESISTOR  METAL STIRP 4.7m ±0.5% 3 W ±100PPM/°C AXIAL THT" & @LF & _
                "RESISTOR  THICK FILM 3.83K ±1% 1/4W ±100PPM/°C 1206 SMT" & @LF & _
                "RESISTOR CARBON FILM 22K ±10% 1/2W AXIAL THT" & @LF & _
                "RESISTOR  WIREWOUND  22 ±5% 3W ±30PPM/°C AXIAL THT" & @LF & _
                "RESISTOR  METAL OXIDE 4.7K ±5% 2 W ±300PPM/°C AXIAL THT" & @LF & _
                "RESISTOR  METAL OXIDE 1.13G ±1% 1/2 W ±50PPM/°C AXIAL THT" & @LF & _
                "RESISTOR  THICK FILM 0   1/8W  0805 SM"

$a = StringRegExp($sRes, "(?m)^[\w\s]+\s(\d+\.?\d*[GMKmµ]?)\s", 3)
_ArrayDisplay($a)

 


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)

Share this post


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

  • Similar Content

    • By BlueBandana
      Is there a way to output the regex matches into a file?
      I have a script to compare two files and check for regex matches.
      I want to output the matching regex of 'testexample.txt' to another file.
      #include <MsgBoxConstants.au3> #include <Array.au3> $Read = FileReadToArray("C:\Users\admin\Documents\testexample.txt") $Dictionary = FileReadToArray("C:\Users\admin\Documents\example.txt") For $p = 0 To UBound($Dictionary) - 1 Step 1 $pattern = $Dictionary[$p] For $i = 0 To UBound($Read) - 1 Step 1 $regex = $Read[$i] If StringRegExp($regex, $pattern, 0) Then MsgBox(0, "ResultsPass", "The string is in the file, highlighted strings: " ) Else MsgBox(0, "ResultsFail", "The string isn't in the file.") EndIf Next Next  
    • By junichironakashima
      Im creating a code that will work in this sequence:
      1. Copy the text (question) in one atea of the screen
      2. Catch the 2 strings (number)
      3. Multiply the 2 strings ( $1*$2)
      4. Click the next area to put the answer
      5. Paste the answer
       
      This is my code
       
      MouseClick($MOUSE_CLICK_LEFT, 479, 802, 3, 1) ;Clicking all of the text
      Send("^c") 
      $x = StringRegExpReplace(ClipGet(), 'What is (\d*) x (\d*) \?$', "$1*$2")
      MouseClick($MOUSE_CLICK_LEFT, 480, 844, 1, 1)
      ClipPut($x)
      Send("^v")
       
      However the output is this
      $1*$2
       
      How can I make it solve itself? Because I tried this code:
      MouseClick($MOUSE_CLICK_LEFT, 479, 802, 3, 1) ;Clicking all of the text
      Send("^c")
      MouseClick($MOUSE_CLICK_LEFT, 480, 844, 1, 1) $x = Execute(StringRegExpReplace(ClipGet(), 'What is (\d*) x (\d*) \?$', "$1*$2"))
      ClipPut($x)
      Send("^v")
      Output is just blank text

    • By gruntydatsun
      I have an XML file and every time there are three lines in a row with only <null/> in them, i want to insert a fourth line with <null/>.   Each line starts with 3 white spaces, followed by <null/> and ends with a white space followed by CR LF.   The presence of the three lines as described is unique to the points where I want to insert a line in this document.
       I'm trying to figure out how to apply the repeating part of a regex  {1,4} but apply it to this whole segment. 
      So far I have the below which picks up an individual line ok:
      ^\s{3}<null/>\s\r\n I tried wrapping it all in braces () then adding {3} but I'm obviously getting something wrong. 
      Attached is a section from the xml file with a block of nulls that should be matched if anyone would like to have a look.
      Help_From_Forum.xml
    • By milkmoron
      I am trying to search in a web browser dates XX/XX/XXXX that are also links. I want to click them after and remove them from the array. This is all I have so far. Nothing shows up. What am I doing wrong?
      ControlFocus ("Customer Center", "", "")
      Local $aArray = StringRegExp('(..)/(..)/(....)', '(..)/(..)/(....)', $STR_REGEXPARRAYFULLMATCH)
      For $i = 0 To UBound($aArray) - 1
          MsgBox($MB_SYSTEMMODAL, "RegExp Test with Option 2 - " & $i, $aArray[$i])
      Next
       
    • By WoodGrain
      Hi All,
      I'd like to replace 'COMMA' with ',' for example:
      $myString = "COMMA" StringRegExpReplace($myString, 'COMMA', ',') Now I've tried escaping the ',' in various ways unsuccessfully, such as:
      '[,]'
      "[,]"
      '\,'
      [,] seems to work in the pattern, I just can't figure out how to use it in the replace, and it seems everyone online is only interested in removing/replacing commas lol.
      I also tried creating and using a variable as the replacement but also didn't work:
      $myComma = "," $myString = "COMMA" StringRegExpReplace($myString, 'COMMA', $myComma) I'm sure it's super simple if someone could point me in the right direction - thanks.
×
×
  • Create New...