How to get rid of spaces in fields? (1 Viewer)

[phinix]

I know, it sounds funny - what I need is to get rid of spaces in fields in one column. Basically it is phone numbers, some have space like 0145 8877657.
Thing is when I use replace function it crashes, cause it's 3 million records
Is there any way I could use.. don't know .. update query? Thatw ould trim those fields?

Please help

 

[DCrake]

You could do it in a query using the Replace("String"," ","") function. But also do it in chunks or apply a criteria

Like "* *"

so anything with a space in it

 

[phinix]

You could do it in a query using the Replace("String"," ","") function. But also do it in chunks or apply a criteria

Like "* *"

so anything with a space in it

Thanks, but that needs a string to be added, like exact one string from field.
What if I need to delete soemthing from the whole column, like all fields in column have AW****, where **** is a string of digits, and I need to delete those AW?