|
Home > Archive > Visual FoxPro SQL Queries > September 2005 > too much space in field...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
too much space in field...
|
|
| Dawid.Federowicz@gmail.com 2005-09-29, 7:25 am |
| Hello,
I have VFP6.0.
In table, which I made, I have some columns.
One of them is CHAR(100), and in field I have:
"Name Surname Street"
In the next field I have:
"Name2 Surname2 Street2"
I want change every records in this table on that:
"Name Surname Street"
As you see, I want ONLY one space beetween any text, which I have in
field.
I found function, which called REDUCE() - it's exactlly this function
which I need, but in other hand - I can't used it...
Coul you help me with this problem?
Regards,
David
| |
| Anders 2005-09-29, 7:25 am |
| SET LIBRARY TO Foxtools
UPDATE Table SET column = ALLTRIM(REDUCE(colum
n))
The recommended design would be each thing in column of its own.
-Anders
<Dawid.Federowicz@gmail.com> skrev i meddelandet
news:1127983950.744112.28690@o13g2000cwo.googlegroups.com...
> Hello,
>
> I have VFP6.0.
> In table, which I made, I have some columns.
> One of them is CHAR(100), and in field I have:
>
> "Name Surname Street"
>
> In the next field I have:
>
> "Name2 Surname2 Street2"
>
> I want change every records in this table on that:
>
> "Name Surname Street"
>
> As you see, I want ONLY one space beetween any text, which I have in
> field.
>
> I found function, which called REDUCE() - it's exactlly this function
> which I need, but in other hand - I can't used it...
>
> Coul you help me with this problem?
>
> Regards,
> David
>
| |
| Dawid.Federowicz@gmail.com 2005-09-29, 7:25 am |
| It's work!!!
SET LIBRARY TO 'C:\Program Files\Microsoft Visual
Studio\Vfp98\Foxtool
s'
UPDATE Table SET Column = ALLTRIM(REDUCE(Colum
n))
That's all!
Great!!!
Thanks, Anders!
|
|
|
|
|