Separate the Data

Question

Here the Instrument Description is separated into different columns.Pleaser refers to the excel attached.

hansvogelaar · Answer

ajmal_pottekattil_yoousuf&nbsp;
I think that would be difficult, since the parts can have a different number of words from row to row.
Do you have some kind of rule to determine which bits belong together?

ajmal_pottekattil_yoousuf · Answer

HansVogelaar&nbsp;if the Starting Part&nbsp; is "Digital" Other Names will be there after the "Digital"Example "Digital outside micrometer"&nbsp;"

peiyezhu · Answer

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 · Answer

peiyezhu&nbsp;Some of the instrument is only started with digital&nbsp;Other's are not started with digital.First we think to&nbsp; have to segregate the Digital Family / and Non Digital Family.

peiyezhu · Answer

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&amp;)',`Item Description`) Range,regexp2('(Digital|(?&lt;=&amp;\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&nbsp;&nbsp;

Forum Discussion

Separate the Data

5 Replies