Hi Hylton
On 10/08/2022 19:28, Hylton Conacher (ZR1HPC) wrote:
Hi Steve, et al,
On 2022/08/09 23:05, Steve Edmonds wrote:
...
Further to Johnny's question, how is the CSV delimited. Do you just
have commas between values or are some values also quoted in " ".
There are no " "'s, all comma
Dear fellow members,
My apologies for wasting your time and brain power, however the use of
Calc and VLOOKUP is NOT the right tool for the job and that INDEX(MATCH)
would have ben better, given that the downloaded .csv data file grows by
approximately 1MB per month.
I have marked this
Hi Harvey,
The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in each case "[Works in the
GUI]" - or not (e.g. CASE)
Great stuff!!
And all this translated from German Base Handbuch into English. I take
this as special compliment.
That is marvellous. Thank you, Robert!!
I must get used to visiting the Document Foundation website, as I tend
to stick with the help function and otherwise OpenSUSE. Excellent tip.
The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in
Hi Harvey,
most SQL code I create direcly without using GUI, so I don't know if all
of this could also be created through GUI.
Have a look at the Base Guide
https://nextcloud.documentfoundation.org/s/qjFkGwpEEkNrt6f.
The GUI has been created to work perfect with internal HSQLDB (very
old…),
Hi Robert,
I suppose my question could be reformulated: what version of SQL does
Base support? To what extent is that SQL supported in the BASE
query/view graphical interface?
I haven't been able to find an answer in the LO Help (yet).
Cheers
Harvey
On Wed, 2022-08-10 at 08:31 +0200, Robert
Hi Steve, et al,
On 2022/08/09 23:05, Steve Edmonds wrote:
...
Further to Johnny's question, how is the CSV delimited. Do you just have
commas between values or are some values also quoted in " ".
There are no " "'s, all comma separated.
When I import a simple CSV using Sheet>Insert sheet
Hi Harvey,
For example, I would like to extract a text string from a field in each
record and display it in an extra view and/or query field, or multiply
two field values and record the result in an extra field.
A little example will help: What is the content of the field in tehe
table, whot