On 2017-11-27 11:59, Koen Piller wrote:
if you want to avoid the extra spaces at the end trim() and or
alltrim() is
your friend.
Koen
Koen,
I think there's a misunderstanding. Please tell me how using a COPY TO
MyCSVFile TYPE CSV can be manipulated with a TRIM or ALLTRIM? Are you
saying I should devise some sort of construct like the pseudo-code
following this to trim everything before the COPY TO ... TYPE CSV
command?
FOR EACH Column in Table.Columns
REPLACE Column with ALLTRIM(Column) in Table ALL
ENDFOR
I doubt that's what you would do, so enlighten me please.
Thanks,
--Mike
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
