Converting text values to number

[cliff_clayman]

I have a field that is text that I would like to convert to a number so I can do conditional formatting. The values in the field are formatted like this:

1

1-

1+

How can I convert this to a number and strip out the -'s and +'s so I can do conditional formatting?

[Taoufiq_Zarra]

If I understood correctly, one solution :

Data:

load *,num(keepchar(Field,'0123456789')) as FormatedField inline [
Field
1
1-
1+
];

[Taoufiq_Zarra]

but if you want to keep '-'

just num(Field)