hi experts,
I have a column of type string containing Amount + Currency values. How can I sort with respect to Amount only.
say 100 USD could be sorted based on 100 and USD field will not considered for sorting.
thanks in advance.
nikhil