Build a FileMaker database that can use the ExecuteSQL to read CSV data in a Text Field

Job ID: 31202788

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.
Related categories: SQL MySQL FileMaker Database Programming