Forum Discussion

ajmal_pottekattil_yoousuf's avatar
ajmal_pottekattil_yoousuf
Iron Contributor
Feb 20, 2023

HansVogelaar 

if the Starting Part  is "Digital" Other Names will be there after the "Digital"

Example "Digital outside micrometer"

 

"

peiyezhu's avatar
peiyezhu
Bronze Contributor
Feb 20, 2023
Ultrasonic Thickness Gauge Defelsko Positector STD (Indicator) /UTG-M (Probe) 0 to 125 mm & 0.01 mm/0.1 mm


there is no "Digital" in above string?
only separate starting with "Digital" + first capital letter as instrument name?
  • ajmal_pottekattil_yoousuf's avatar
    ajmal_pottekattil_yoousuf
    Iron Contributor
    Feb 21, 2023

    peiyezhu 

    Some of the instrument is only started with digital 

    Other's are not started with digital.

    First we think to  have to segregate the Digital Family / and Non Digital Family.

    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Feb 21, 2023

      take below regular expression for reference. select *,regexp2('^(Digital\s.*)(Fluke|Mitutoyo)\s(\S*)\s(\S*)\s(\S*)',`Item Description`,1) 'Instrument Name',regexp2('^(Digital\s.*)(Fluke|Mitutoyo)\s(\S*)\s(\S*)\s(\S*)',`Item Description`,2) Make,regexp2('^(Digital\s.*)(Fluke|Mitutoyo)\s(.*?)(?=\sDiff|\s0\sto)',`Item Description`,3) Model,regexp2('\sDiff.*\s|0\sto.*(?=\s&)',`Item Description`) Range,regexp2('(Digital|(?<=&\s).+)$',`Item Description`) Resolution from regular_expression_separare_instrument; or try this online tool http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=regular_expression_separare_instrument

       

       

       

Resources