| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract text from text string
Hello,
I would like to extract the X-coordinate from a string of NC programming code for a CNC machine. A typical line of code might look like this: (M72) G0G54X202.819Z54.5 #590=2(RECOVER_FACE TURN) G1X167.751F#101M26 G0Z61.398 X163.682 G1 X 153.873 Z 62 X147.873 G0X162.375Z62.394 My preference would be a formula. I would like the adjacent cell to contain only the value for "X" ie. in the first line "G0G54X202.819Z54.5", the X-coord is 202.819. Please note sometimes the text may have a space after the X or after the coordinate. It is not consistent. I have tried "find" and "mid" with limited success. I was wondering if it's possible to analyze each character in the string after the "X" and verify if it's a number or a period. Thank you in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract value from a text string | Excel Worksheet Functions | |||
| Need to extract certain text from text string | Excel Worksheet Functions | |||
| Extract text from a string | Excel Worksheet Functions | |||
| Extract text string using MID | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
Threaded Mode
