Support Questions

Find answers, ask questions, and share your expertise

Sorting on fixed width file

avatar
Expert Contributor

Hi Team,

how to sort this below output in Ascending order  by maintaining same space in both header values. I've tried using query record but couldn't able to add spaces using SPACE function. but space which i've given is considering as SPACE(numeric) value instead of INT.

input:

NO CUSTOM.;NO INCSUPB;NO ALLBPBM ;IMPORTE BRUTO;DESCUENTO;IMPORTE NETO
0000000023;123548    ;999888     ;875,92       ;176,88   ;699,04
0000000012;123547    ;777666     ;2347,04      ;591,84   ;1755,2

 

Expected Output:

NO CUSTOM.;NO INCSUPB;NO ALLBPBM ;IMPORTE BRUTO;DESCUENTO;IMPORTE NETO
0000000012;123547    ;777666     ;2347,04      ;591,84   ;1755,2
0000000023;123548    ;999888     ;875,92       ;176,88   ;699,04



0 REPLIES 0