sort alphabetically characters within a field

[#1]

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

[sunny_talwar]

Yes, you should be able to use order by to sort a text field

[#3]

I apologize for not having properly explained. I would do this:

"ADC130" -> "013ACD"

for each occurrence of the field

[adamdavi3s]

=keepchar(yourfield,'0123456789')&purgechar(yourfield,'0123456789')

[sunny_talwar]

This alone will not work because ADC -> ACD and 130 -> 013

May be using SubField() and then Concat()

[adamdavi3s]

Sorry yes my misunderstanding of the requirement

[Anonymous]

Hi,

The only solution i see is to make, for each character you have in your field the following function and concatenate, like below:

IF(SubStringCount(Test,IF(SubStringCount(Test,0)<>0,Repeat('1',SubStringCount(Test,1)))1)<>1,Repeat('1',SubStringCount(Test,1)))&...&IF(SubStringCount(Test,'A')<>0,Repeat('A',SubStringCount(Test,'A')))

I can not figure out how to use a loop to not have to insert with concatenation.

Best regards,

Cosmina

[swuehl]

Maybe something like

LOAD In, RecId, Concat(Char) as Out

GROUP BY In, RecId;

LOAD *, Recno() as RecId,

  Mid(In,Iterno(),1) as Char

WHILE iterno() <= Len(In);

LOAD * INLINE [

In

"ADC130"

];

[adamdavi3s]

This is awesome, but how does it sort... I just can't get my brain to process it!

[sunny_talwar]

If you don't provide a sort order to the Concat, it will sort by the ascending order