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...
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.