How to remove certain characters from a field?

[neerajthakur]

Hi, How can I remove <span> and </span> from a field.

Example: Innovative Activities <span>(Optional)</span> , it should display Innovative Activities (Optional)

[Vegar · Accepted solution]

You could try to use mapsubstring() with a mappingtable like this.

MapTable:

MAPPING Load * [

FromString, ToString

<span>,""

</span>,""

];

[neerajthakur]

Hi, Thanks it worked, 

MapTable:

MAPPING Load * Inline [

FromString, ToString

<span>,""

</span>,""

];