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 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))
Now I am trying another instrument Pressure Gauge.
I have been facing some issues.
I highlighted it in red colour.
Could you please help me to solve this issue?I have changed the formula for this task slightly. If several hits occur in a text, the first hit from my comparison list is used. In the previous formula, the first match found in the text was used.
=LET(txt,SUBSTITUTE(A1,UNICHAR(10)," "),hli,IFERROR(SEARCH({"0 to";"0 to";"0-";" ?? bar";" ???? bar";" ???? mbar";"? t???? psi";" ???? psi";" ????? psi"},txt),""),sep,XLOOKUP(TRUE,hli<>"",hli),TRIM(MID(txt,sep,1000)))Furthermore, there is no guarantee that all text snippets will be found 100% correctly.