To Insert Proper Spaces in Data displayed in Smartform

[Former Member]

hi all,

I am getting data like this in my smartform : -

CHEESE HD. SCREW DIN-EN-ISO 4762 M3X6 GA

I need to remove those extra spaces coming between " CHEESE " and " HD "

Pls assist.

[Former Member]

Data is coming like this :-

CHEESE HD. SCREW DIN-EN-ISO 4762 M3X6 GA

i got a logic :-

Can we calculate the Length of whole string and then put a check that if if more than One Space comes then delete the remaining Spaces ?

[Former Member]

wef