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 not
- is it possible to extract data by using regex extract function
11 Replies
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.
I've looked at your tables and unfortunately I can't understand what you're trying to achieve. Since no one else has answered your questions, I assume that I was not the only one who felt this way.
Please describe exactly what result you expect in which cell in which sheet. Then you will certainly be able to answer well-formulated, complete questions in full sentences.
I am trying to extract the range and readability from the text.
Could you please refer to this Excel sheet?
In this mode, we want to split every data.
I suppose that could help you. No guarantee of 100% hits.
=SUBSTITUTE(A2,UNICHAR(10)," ")=TRIM(MID(SUBSTITUTE(A2,UNICHAR(10)," "),MIN(IFERROR(SEARCH({" ?? hr";" ?? h ";" ? hr";" ? h ";" ??? min";" ?? min"},SUBSTITUTE(A2,UNICHAR(10)," ")),"")),1000))
- You can use textsplit textafter or textbefore formulas. Since I can't understand your data logic and from where your data requirement starts and end I can't give you exact formula
