Delete Space in Data

[Esneider]

Hi,

In one of my fields, I have data like '    XXXX   YYY   ZZ' and I want them as 'XXXX YYY ZZ'

How can I do that?

[#2]

While loading your data in script editor, You can use ltrim() function to remove leading spaces.

example: 

from xyz.......

similary rtrim() to remove spaces from the end.

Below will remove leading and trail spaces from column name Relation and alias name of that column will be rel

ltrim(rtrim(Relation)) as rel 

LOAD

ltrim(Relation) as rel

[#3]

While loading your data in script editor, You can use ltrim() function to remove leading spaces.

example: 

LOAD

  ltrim(Relation) as rel

from xyz.......

similary rtrim() to remove spaces from the end.

Below will remove leading and trail spaces from column name Relation and alias name of that column will be rel

ltrim(rtrim(Relation)) as rel 

[sujeetsingh]

If the trend is constant then we can do it.

let the field be Name

expression can be like this

=Subfield(Name,'  ')

may it work

[sivarajs]

This might helps you

Replace(LTrim('   XXXX   YYY   ZZ'),'  ',' ')

[rwunderlich]

One solution would be to use a MAPPING TABLE wih MapSubstring().

SpaceMap:

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

AutoGenerate 10  // up to 10 spaces

;

And in your LOAD statement:

MapSubString('SpaceMap', trim(x)) as y

-Rob

[Anonymous]

That's an excellent solution!

Regards

MultiView

[sujeetsingh]

Rob ,

will you please explain how it works

?

[Esneider]

Hi Rob,

Please can you send a example in qvw?

Thanks,

[Esneider]

Hi,

You have the example in qvw?