second screen shot
You need to separate out just the data to be used in the sort into a separate field.
If you are just sorting by the number after the X and ignoring the letter, you could set up a calculation field:
GetAsNumber ( Rightwords (YourField ; 1 ) )
And then you can sort on this calculation field.
I'd also consider permanently separating these values into separate fields and using either a calculation field or merge fields to display them in a combined row like this.
As always, thanks Phil for your response. Was there something in your post after the last line that didnt come thru?
"...I'd also consider permanently separating these values into separate fields and using either a calculation field or merge fields to display them in a combined row like this..."
Yeah I think I have to separate the data. I want to get it like the second screen shot.....brand, then last letter, with the 2 last numbers in acending order, based on the first numbers before the "X" in ascending order...if that makes sense.
Hey Phil, I left out a critical and obvious piece of information. The nozzles are in a value list (drop down in field), in the order I want them in. So a simple sort by "Custom order based on value list" was what I needed. Sorry I didnt mention that in the first place.
Thanks as always