mike scott wrote:
On 9 Jul 2008 at 17:08, Brian Barker wrote:
....
Since you have text values in the cells, converting them to numbers
is probably going in the wrong direction. Instead, create a new
column with the values actually as you wish to see them
exported. One way to do this would be:
=LEFT(x;3)&"."&MID(x;4;3)&"."&RIGHT(x;4)
This takes the leftmost three characters, the three central
characters starting at character four, and the rightmost four
characters, and concatenates them with the two dots in between.
This column will output to CSV as you need.
I missed the OP's note that the fields were quoted text not numbers -
apologies.
Brian's way will obviously work - but needs in an extra column, and
hence a likely extra field in the output. I don't see anything in the
save as csv dialogue that allows just selected columns to be saved -
is it there?
Otherwise, maybe the OP could convert all the quoted numeric strings
to actual numbers in a new column using decimal(), then delete the
old column and format as I described elsewhere. It depends on exactly
what the OP wants - there's obviously a fair bit of choice!
Thanx Brian & Mike,
I am back on site next Tuesday to finalise this issue. I will give
feedback also, but the way Brian does should work.
Fortunately I can add columns as I like; in the "saved as" CSV file. The
import procedure allows complete dynamic allocation of fields.
Many thanx to you both,
Al
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]