i want remove space in two parameters

[Srinivas]

Hi Friends,

I have one list box in that parameters have space, So i want remove those spaces in that listbox.

ABI  PF LATEX

ABI  STERILE

AMBI  SYNTHETIC (EXC VINYL)

AMBI  VINYL

AMBIS LATEX NON STR P.FREE

CDMS   OEM

CDMS  RETAIL BRANDED

CDMS  TENDERS NON BRANDED

Please help on this i am waiting for your reply.

Regards

Munna

[its_anandrjs · Accepted solution]

In your load script write like

Replace(FieldNameHere,' ','') as NewField;

Eg:-

LOAD List,Replace(List,' ','') as N;

LOAD * Inline

[

List

ABI  PF LATEX

ABI  STERILE

AMBI  SYNTHETIC (EXC VINYL)

AMBI  VINYL

AMBIS LATEX NON STR P.FREE

CDMS   OEM

CDMS  RETAIL BRANDED

CDMS  TENDERS NON BRANDED

];

[Srinivas]

Hi Anand,

Thanks a lot, It's working.

Advance Thanks

Munna