Jan 11 2006, 10:28 AM
I used to know how to do this and I am pretty sure I use the mid function but:
I have the above in a field. I need everything to teh left of the % and I nee to trim off the O and 1 space so I am only left with the #'s. What is the syntax of my mid statement?
Thanks in advance
Jan 11 2006, 10:36 AM
Mid([YourField],Start Position, How many positions)
o it would be something like:
Is that what you want?
Jan 11 2006, 11:08 AM
I know how to do that it may have been a ltrim or rtrim function. I want to get everything from the left of the %.
Jan 11 2006, 11:10 AM
I thought you asked about the mid function?
for all functions listed and explained!
Jan 11 2006, 11:54 AM
That site is not helpful at all. As I stated I do not remember if it was the mid function but I think it is. But how ouwl d you or anyone look at data in a field such as:
And make the field end up with 10 in it after an update query?
Jan 11 2006, 12:13 PM
Why is that site not helpfull. It explains all string manipulation functions and you just have to go through it and pick the one you think will work.
There are many options, but you are not being clear on what you want. First you said you wanted to use the mid functio
The mid function example I provided would result in only the numbers being left "10.0"!
Then you are saying you want You could use the mid function or the left function or a combination of instr and left function or...!
Now you are saying you just want:
So again something else and again you could just easily use the mid function!
Jan 11 2006, 12:22 PM
I don't understand what is not clear?
need the syntax on how to use the mid function when looking for the % symbol in a field.
Ocannot simply say mid([test],3,4) because the % symbol is not always going to be at the 3rd position in the field so the field may have the following:
Thus each time i need what is to the let of the %. So how do I tell the mid function to look for the % symbol instead of saying start inposition 3
Jan 11 2006, 12:31 PM
Jan 11 2006, 12:35 PM
Thank you sooooo much!
Jan 11 2006, 12:35 PM
Now that is a clear description of what you need. You have never mentioned any of this before. As mentioned use the mid and instr function together. Truit also gave you a sample!
Jan 11 2006, 12:43 PM
You are welcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here