You need to write some thing like this code
=Subfield(ColA,'-',1) to exclude the symbol '--' from any data from the load script or any of the object level you are able to do that.
In load script you need to write some thing like this
load * inline
Subfield(ColA,'-',1) as CleanField
or in object level you need to put Subfield(ColA,'-',1) on any object like list box any other object
You need to do some changes in your load script or in onject level where ever you want it
put this code if you want to exclue from data like
And if you want to remove it from any data which is like
See the attached sample file
use the PurgeChar (string,'-') function like this
if ur field or string is abc--cde
it will give output abccde.
If there are several types of symbols in the tring and you want to remove it you are able to remove it by the use of Purgechar( ) command like
If string are like
you have to put Put a code like =Purgechar( ColA, ' - ' )
or if string are like
you have to Put a code like =Purgechar( Purgechar( ColA, ' - ' ), ' ( ' )
if there is any type of symbol acording to that you have to use it.