Feb 20 2023 02:30 AM
Here the Instrument Description is separated into different columns.
Pleaser refers to the excel attached.
Feb 20 2023 03:56 AM
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?
Feb 20 2023 04:34 AM
if the Starting Part is "Digital" Other Names will be there after the "Digital"
Example "Digital outside micrometer"
"
Feb 20 2023 11:19 PM
Feb 21 2023 02:32 AM
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.
Feb 21 2023 02:33 PM - edited Feb 21 2023 02:34 PM
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