Manolis Christodoulou wrote:
I have already submitted an issue for ArrayOutOfString and
ReplaceString functions, look at Issue 78503.
http://www.openoffice.org/issues/show_bug.cgi?id=78503 to br replaced
by join(split(...)) calls.
You can vote for it.
Excellent, I will do that.
We went in two different directions, I was concerned with not breaking
on separator characters when they are inside paired quote characters.
Needed for bursting a line from a CSV style file for loading into a
table for instance, so added an optional parameter - the quote character
to watch for, if passed then watch for it, if missing old
functionalaity..etc.and a second optional parameter to say whether to
include quotes in the arrays field or not..
Darn MSAccess export files with booleans ( 0,1) and text fields can
looks like:
2145,0,0,0,1,"Some text, and more text / all one field",0,0,2.15
That damned embedded comma..you know. Even better, this is a valid
export from MSA also:
2145,0,0,0,1,"Some text, and I"ll make more text / all one field",0,0,2.15
A typo during data entry no doubt, but MSA takes it and exports it just
like that...arrrgh
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]