March 28, 201213 yr hello everyone; i just can't seem to figure this one out. I am looking to find a certain range of chars such as A1, then strip chars before and after but don't know how. here is what i have so far. I just need it finished. * ok. while i was writing this, i saw that i figured out my own problem Here is the solution for anyone else; Let([ text = "1ASdfdA1sdjf1231123"; //string to search for ; search = "A1"; // i am looking for A1 location = Position ( text; search ; 1; 1); // where does this start @ sectionR = Right ( text; location); // find right section sectionL = Left( text; location) // find left section ]; right( sectionL ; 1) & left( sectionR ;1 ) //we know right and left so lets strip off 1 char off each and we get proper result )
Create an account or sign in to comment