Search Data in CSV-File and show in a table and later in a form

[JOTHA]

Hi forum,

i have a little problem, maybe someone can help me. :sign0085:

I want to search Data out of a CSV-Table and show them first in a table and later on the form. This application should have the following features:

1) Searching over a mask in the CSV-File. It should be possible to search for fragments in the text in all fields ("*").

2) Show the found data in a table, sorted by ABC or Numbers (sort.asc)

3) Should be able to choice one dataset out of the table (maybe the best way is to use "listview.dll" from Filippo for that?)

4) show dataset in the form1

I attached a small example.

If there is anybody who can give me tips - THANK YOU in advance!

 

[Erel]

How large is the CSV file?
You can load it to a table and then use Table.Filter and Table.TableSort to arrange the data.
You can also convert the CSV file to a SQLite db which is more powerful.

 

[JOTHA]

Hello Erel,

thank you for your fast reaction.

How large is the CSV file?

The CSV file is about 10.000 datasets (lines) in 10 rows.

You can load it to a table and then use Table.Filter and Table.TableSort to arrange the data.

I know about this solution, but it would take too long time to load the file and to search the "one" data which is needed.

You can also convert the CSV file to a SQLite db which is more powerful.

1) The data could change every week or every 14 days, because there is a pricing list which includes welding-metal and the prices are different sometimes. So I had to convert the data all the time and it this would be not very comfortable.

2) For SQL-Programming i need more knowledge ...

I think, the way to search the data and fill a table, then select one out of it might be the best way for the moment, isn´t it?

THANKS!

 

[Erel]

I recommend you to learn the basics of SQL. It is not too complicated and will allow you to do many things with your data.
There are many resources available online about SQL. Here is one: SQL Syntax