Converting text to a number before sorting
Currently the only way to cast a value to an integer is through an out tag. If we have a text field that is a number we would like to convert it to numeric in the for each loop and then sort it numerically. For example if we have 01, 2, 3, 4, 05, 06 the current sort order comes out as 01, 05, 06, 2, 3, 4. We would need to convert these values to a number in the for each loop using NUMBERVALUE or CAST and then sort on these values. Currently we are only able to convert these to numeric in the out tag after they have been sorted incorrectly.
Natalie Sullo
shared this idea
Hello Reporter,
We have reviewed your request, but had some questions. What data provider are you using? If you are using XML, this problem may be solved by using a schema.
Thank you.
Adam Austin
Product Manager