Build a FileMaker database that can use the ExecuteSQL to read CSV data in a Text Field
Budget: $15 – $25 AUD
As the name reveals, I would like to read a CSV text and find data (as a list) from a column based on a search criteria from the "table" created from this data. Of course, I could import the CSV into FileMaker as separate records in a table and use the ExecuteSQL command. But I am curious to know whether it is possible to store the CSV data in a text field and read from it by creating a temporary table and find data in a column/field.
I have seen ideas like,
Let ([
csv = "CREATE TEMPORARY TABLE csvtable
LOAD DATA INFILE '~/Desktop/test.csv'
INTO TABLE csvtable
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;"
[SQL query applied here]
];
ExecuteSQL ( csv; ""; "" )
)
However, executing the idea in practice within FileMaker Pro is not always easy.
If you are comfortable and can easily do this, feel free to express your interest.
Thanks.
I have seen ideas like,
Let ([
csv = "CREATE TEMPORARY TABLE csvtable
LOAD DATA INFILE '~/Desktop/test.csv'
INTO TABLE csvtable
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;"
[SQL query applied here]
];
ExecuteSQL ( csv; ""; "" )
)
However, executing the idea in practice within FileMaker Pro is not always easy.
If you are comfortable and can easily do this, feel free to express your interest.
Thanks.