How to take out spaces

[igotit]

Hi Guys,

I have an "ItemNumber" field and some of the number & letters were entered with spaces. Like "P 335 H2" instead of "P335H2" and the spaces are not always in the same places.

How can I take out all spaces?

Thanks for your help,

Milo

[Genx]

Substitute( ItemNumber ; " " ; "" )

[igotit]

Hi Genx and how are you doing?

I see the "Substitute( ItemNbr ; " " ; "" )" but where do I put it? In the calculated Value of the field? If so what do I do with the following calc that's already there?

"Case(IsEmpty(ItemNbr); TextColor ( "Enter Info..." ; RGB ( 127 ; 127 ; 127 ) ); TextColor ( ItemNbr ; RGB ( 0 ; 0 ; 0 ) ))"

Also, my "ItemNumber" field is a Number field. When I use "Substitute( ItemNbr ; " " ; "" )" will that also strip out the letters that are in the ItemNbr field?

Milo

[David Jondreau]

1) To get all future records showing right, change the calc to:

Case(IsEmpty(ItemNbr); TextColor ( "Enter Info..." ; RGB ( 127 ; 127 ; 127 ) ); TextColor ( [color:red]Substitute(ItemNbr [color:red]; " "; "") ; RGB ( 0 ; 0 ; 0 ) ))

2) To get all the current records correct, Show All Records and Replace Field Contents with GenX's calc.