On 2020-01-13 21:02, Aureliano Guedes wrote:
ToddAndMargo, this should handle any kind of columns separated data (or
any table). If some column (commonly separated with a constant character
as "\t", ";", "|", ....) has different types (char, text, int, boolean,
...) in a single column, then it should be treated as a character, but
if it has only float (in all rows/lines) then the parser checks all rows
for a same column (in this example case all them are float) and assign
the column as float contain column.
Example:
NAME(long char);NICK(char);AGE(natural/positive
integer);HEIGHT(float m);WEIGHT(float kg)
John Lovegood;JoL;23;1.80;85.283
Marry Lockheart;Marry_L;35;1.68;63,125
You may see that the first line must be a header, all lines have 5
fields separated by ";" and each field has a unique type (the
specifications not aways be declared on the data or file).
How are you getting this data back? In a buffer of
DWORDS that you have to cut up? Or are they already
formatted for you?