Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sort alphabetically characters within a field

is it possible, in the process of loading data, sort alphabetically characters within a field (alphanumeric)?

12 Replies
aveeeeeee7en
Specialist III
Specialist III

Honestly speaking, this solution is the best & master class.

you're sunny right sunny. But, I've a question here - How does Alpha numeric gets sorted out. Numbers can be sorted in ascending or descending order. But, how to do that with Alphabets. I've tried the solution with customized strings and it's not giving the desired output. I'll try & come back with modified solution.

Sunny, if I'm missing something than please correct me. I came here for the basics & concepts clarity.

 

aveeeeeee7en
Specialist III
Specialist III

Perfect Solution & Master Class...........!!

aveeeeeee7en
Specialist III
Specialist III

Even my brain got jammed... I'm not able to figure out the sorting part that how does it sorted the Alphanumeric string using Order By which is meant for the Number values.