Forum Discussion
Extract the text value
Exacting the range and readability from the instrument type How to extract it please guide me i filter the data( please refer the other sheet) and try to extract. In this method is correct or no...
You may extract with regex, but you need to be on Beta version of Excel 365.
In any case, as dscheikey mentioned logic is not clear.
I use this function but I didn't extract the full date
That could be like
=REGEXEXTRACT(A2:A64, "(?x) #lookahead 1 to 3 digits: (?=(\d{,3} # followed by any of combinations below: (hr|\shr|\sh\s|\smin)) ) # end of not captured match # and starting from it return all characters # including LF and CR (.|\n|\r)* ", 1,1)Please check attached file.
It's better to avoid or minimize comments in pattern - text in formulae is limited by 255 characters, or we need to contact texts.