Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting Combobox 1
- Thread starter GrantWeb
- Start date
-
1
- #2
Hi
Instead of comparing the whole strings compare only their relevant parts.
If all numeric prefixes are 8 character long as in the example, [tt]Copy[teal]([/teal]str[teal],[/teal][purple]10[/purple][teal],[/teal]Length[teal]([/teal]str[teal]))[/teal][/tt] is enough. Otherwise just take the part after the first space : [tt]Copy[teal]([/teal]str[teal],[/teal]Pos[teal]([/teal][green]' '[/green][teal],[/teal]str[teal])+[/teal][purple]1[/purple][teal],[/teal]Length[teal]([/teal]str[teal]))[/teal][/tt] .
Feherke.
Instead of comparing the whole strings compare only their relevant parts.
If all numeric prefixes are 8 character long as in the example, [tt]Copy[teal]([/teal]str[teal],[/teal][purple]10[/purple][teal],[/teal]Length[teal]([/teal]str[teal]))[/teal][/tt] is enough. Otherwise just take the part after the first space : [tt]Copy[teal]([/teal]str[teal],[/teal]Pos[teal]([/teal][green]' '[/green][teal],[/teal]str[teal])+[/teal][purple]1[/purple][teal],[/teal]Length[teal]([/teal]str[teal]))[/teal][/tt] .
Feherke.
- Status