In excel I developed a formula to extract the second word of a text string.
Cell A1 = "The standard response"
Cell B1 = MID(A2, FIND(" ",A2,1)+1, FIND(" ",A2,FIND(" ",A2,1)+1)-(FIND(" ",A2,FIND(" ",A2,1)))) retruns "standard"
Can this be done in a select query in access. I do not have a "Find" function in access to determine the space location.
Thanks
Cell A1 = "The standard response"
Cell B1 = MID(A2, FIND(" ",A2,1)+1, FIND(" ",A2,FIND(" ",A2,1)+1)-(FIND(" ",A2,FIND(" ",A2,1)))) retruns "standard"
Can this be done in a select query in access. I do not have a "Find" function in access to determine the space location.
Thanks