N
Niklas Östergren
Hi!
I know that I can use Trim(), LTrim(), RTrim() and so on to remove spaces
from a field but this only works on leading and ending spaces of a string.
But how do I get rid of spaces in the middle of a string?
I have a field, in an old db, which I now want to import to a new db but the
users have stored the value with spaces in between on some values, like
this:
ZipCode
542 02
244 23
53 543
As you can see some of the values have the psaces as the 3 charcter and some
have it as the fourth charcter. The only thing I know is that the result
allways should contain of 5 charcters, like this:
ZipCode
54202
24423
53543
Anyone know who I do this?
TIA!
// Niklas
I know that I can use Trim(), LTrim(), RTrim() and so on to remove spaces
from a field but this only works on leading and ending spaces of a string.
But how do I get rid of spaces in the middle of a string?
I have a field, in an old db, which I now want to import to a new db but the
users have stored the value with spaces in between on some values, like
this:
ZipCode
542 02
244 23
53 543
As you can see some of the values have the psaces as the 3 charcter and some
have it as the fourth charcter. The only thing I know is that the result
allways should contain of 5 charcters, like this:
ZipCode
54202
24423
53543
Anyone know who I do this?
TIA!
// Niklas