How to delete space and delete up to space

[ramrongala]

Hi

Here i have 2 doubts 1)  delete space between the names

                                 2)  delete up to space from right side or left side

below is sample code

1) combine into single name without space like "murthy rongal" into murthyrongala

2) delete up to spaces like "murthy rongal" into either "murthy" or "rongala"

i tried in scrpit level  left() ,len() ,Trim(),ltrim() and rtrim() but no use

please help me on this

i attached QVW file also. so we can modify and send it if possible

[sunny_talwar]

May be like this:

LOAD name,

    sal,

    PurgeChar(name, ' ') as name_option1,

    SubField(name, ' ', 1) as name_option2

FROM

[left.xlsx]

(ooxml, embedded labels, table is Sheet1);

[ramrongala]

Bro its working fine