Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
i Have an text format Like the "nam , gpa , 11 "
i want to Remove the commas convert that text format into normal form Like nam pga 11
May be this:
PurgeChar(FieldName, ',')
Try: Replace(Field, ', ', '')
- Marcus
use purgchar(name,',')
or
Subfield( Mid( MyField, Len(MyField) ), ',' )
I want to Remove the Double Quotes also ... this one " "
Try this:
PurgeChar(FieldName, Chr(34) & ',')
give one Example
Here is one:
Table:
LOAD Field,
PurgeChar(Field, Chr(34)&',') as NewField;
LOAD * Inline [
Field
'"nam , gpa , 11 "'
];
if you want to remove both the " &,
purgechar(' "nam , gpa , 11" ','," ')
try this one also
keepchar(Fieldname,'abcdefghijklmnopqrstuvwxyz0123456789') as NewField