USING STRING FUNCTION INCREASING OR DECREASING THE LENGTH OF STRING

[nizamsha]

LOAD * INLINE [
Country
    IND
    AUS
    WI
    NZ
];

I need the output in the below format. Without using dual() Function and  use extra field but dont display it in the output.

its sould be in the listbox like this

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

I USED MID FUNCTION IN MY LISTBOX SO ITS WORKING FINE.. BUT I WANT TO SEE THE COUNTRY IN LISTBOX WITH OUT WRITTING CONDITION IN LISTBOX

I HAVE ATTACHED A QVW FILE

[RedSky001]

If you don't want to use an expression in a list box why don't you move the expression into the script to make a new field?  Not sure I understand your question at all in fact.

[nizamsha]

HI MARK

I TRIED IN THAT TYPE .BUT I WANT IN ANOTHER TYPE

[RedSky001]

Another type of what? (I don't understand your question, my first response was a guess)

[nizamsha]

MARK I THINK U WILL UNDERSTAND THIS ONE

THIS IS MY LOAD STATEMENT

LOAD * INLINE [
Country
    IND
    AUS
    WI
    NZ
];

I WANT THE OUTPUT LIKE THIS... IN LIST BOX

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

HOW CAN I DO THIS..

[er_mohit · Accepted solution]

TRY THIS

ADC:

MAPPING LOAD * INLINE [

nO,Country

  1,  IND

   2, AUS

    3,WI

    4,NZ

];

Map COUNTRY using ADC;

LOAD * Inline [

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

];

[nizamsha]

THANKS MOHIT

THATS WORKS PERFECT IS THERE ANY OTHER WAY

[er_mohit]

Yeah using rowno() like this

ADC:

MAPPING LOAD RowNo() as Key, * INLINE [

Country

    IND

    AUS

    WI

    NZ

];

Map COUNTRY using ADC;

LOAD * Inline [

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

];