Order

[pgalvezt]

Hi,

I have an Excel file. with format in text What I want is convert to Number.

And the Order the example. Or Order directly the example. How can I get this?:

14

CF

26

36

Thanks.

[fosuzuki · Accepted solution]

HI,

I'm not sure if this is the best solution, but you can use a Dual field.

In the script, create only one field like:

Example:

load dual(Code, Number) as Code;

Load * Inline [

Number,Code

1,14

3,26

4,36

2,CF

];

And then on the listbox or other object, use the Code field and sort it by a Numerical value.

Hope this helps you.

Regards,

Fernando

[pgalvezt]

Its works!!

Many Thanks!