DataView Sort Order

[Cincy Steve]

Id like to use the DataView Sort property to sort on a string field (i.e. "MyField ASC"), but want a different result than its giving. In particular, the strings look like "Text n" where n ranges from 1 to 20. I would like strings that start with the same the "Text" to sort in the numeric order of n (i.e. 1, 2, 3, etc). What Im getting is that "Text 10" sorts before "Text 2" because 1 comes before 2. Is there any straightforward way to get "Text 10" to come after "Text 2", short of parsing the string to get the numeric value and then sorting on it and the "Text" as separate fields?

Thx. Steve

Continue reading...