Trimm full stop

[Anonymous]

Hi All,

How to trim full stop .

Name:

Raja .

Raja

Michel .

Michel

Thanks,

Krishna

[swuehl · Accepted solution]

Maybe like

Trim( Purgechar(Name,'.'))

[trdandamudi]

May be as below:

Name_Table:

Load * Inline [

Name

Raja .

Raja

Michel .

Michel

];

NoConcatenate

Final:

Load

SubField(Name,' .',1) as Name

Resident Name_Table;

Drop Table Name_Table;

[trdandamudi]

One more way with preceding load:

Name_Table:

Load SubField(Name,' .',1) as Name;

Load * Inline [

Name

Raja .

Raja

Michel .

Michel

];

[tamilarasu]

You can also try,

Trim(Replace(Name,'.',''))