How to remove special character?

[soha1902]

Hi All,

I want to remove last two character from my field.

I know, I need to use PurgeChar() but the problem is, I don't know how to type this character.

Please find below image for clarification.

Please help me regarding this.

[tresesco · Accepted solution]

To exclude last two chararcters, try like:

=Left('ABCDE',Len('ABCDE')-2)

You can replace ABCDE by your field name.

[its_anandrjs]

You can try like below load script if in the fields it is last 2 words

Load

Mid(FieldName,1,len(FieldName)-2) as Newfield

From Location;

Or you can use purge char also.

See the small example

LOAD Site,Word, mid(Word,1,len(Word)-2) as NewWord;

LOAD * Inline

[

Site,Word

a,23fd

b,45fdsf

c,3fsdf

d,56fdsf

e,566fsdf

];

And you get in field NewWord

23

3fs

56fd

566fs

45fd