How to remove spaces in middle of the Field ?

[madhubabum]

Hi experts

I want to remove the spaces in middle of the field values.

I am attaching the sample excel file and Application

Thanks

Madhu

[SreeniJD]

Try this,

Replace the space with let say ","

=replace(Description,' ',',')

and check the string if there are multiple commas between text then trim that...

HTH,

Sreeni

[MK_QSL]

SpaceMap:

MAPPING LOAD repeat(' ', RecNo()), ' '

AutoGenerate 125;

Employee:

LOAD Emp_Id,

     Emp_Name,

    Description as Description1,

     MapSubString('SpaceMap', trim(Description)) as Description

FROM

[Book1 (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

[tresesco]

Replace(Description, ' ','')

[sasiparupudi1]

try

Replace(Description,'  ','')  as NewDescription

hth

Sasi

[petter]

If you want to reduce multiple consecutive spaces between words and have only a single space you could:

Replace(Description, Repeat( Chr(32) , 2 ) ,'')

or if you want to remove spaces entirely:

PurgeChar( Description , ' ' )

[madhubabum]

Hi Manish

I am attaching sample Excel , Output , Application files as following

[ChennaiahNallani]

Hi,

find attachment

[sasiparupudi1]

Try

Replace(Description,'  ','')  as NewDescription

Replace(Replace(Replace(Description,'  ',''),Chr(10),' '),Chr(13),' ')  as NewDescription

hth

Sasi

[MK_QSL]

try according to my 1st reply