How to ignore ';'

[vanderson009]

Hi Community,

I have values in my field like Anderson; Villyee but i want display it on text box as Villyee Anderson,

How could i revert it by ignoring semicolon.

Regards,

Villyee

[simenkg]

In your script you can do this:

Load *,

     trim(Subfield(Name,';',2)) &' '& Subfield(Name,';',1) as FullName

from Source......;

If you want to do it in the front end you can just use the same expression directly, but this will be slower:

=trim(Subfield(Name,';',2)) &' '& Subfield(Name,';',1)

[alexandros17]

Purgechar(myString,';')

if you do:

purgechar('abcd;',';') it will return abcd

[PrashantSangle]

Hi,

Use PurgeChar()

Regards

[sunny_talwar]

To ignore the you can use Replace or PurgeChar.

Replace(FieldName, ';', '')

HTH

Best,

S

[sunny_talwar]

And to get exactly what you are trying to get, you can use the following expression:

=Trim(SubField('Anderson; Villyee', ';', 2)) & ' ' & SubField('Anderson; Villyee', ';', 1)

this will take you from Anderson; Villyee to Villyee Anderson

Best,

S