Just starting out with Xojo. I have a large CSV file of 10 columns and nearly 10k rows. Whats the best way to load and manipulate the data in Xojo (sort, search, remove duplicates, edit certain cells etc)?
Thank you
People talks about reading chunk of text from the file and deal with that.
What strategy to display the loaded data do you plan to use ?
If you know SQL, read it into an sqlite database. And then you can manipulate it in any way possible with all of the tools available with SQL.
If the number of columns is fix you may as well read the data into 10 string arrays. Xojo does an excellent job at sorting (sortwith) and finding stuff in arrays. If this is a one-off thing I would probably avoid the hassle of creating a database just for that purpose.
finding stuff in arrays is really painful compared to sql no ?
Where is the pain in
dim foundAtPosition as integer=myArray.indexof(ElementImLookingFor) ?
[quote=391691:@Maximilian Tyrtania]Where is the pain in
dim foundAtPosition as integer=myArray.indexof(ElementImLookingFor) ?[/quote]
How do you do an unsharp search like “M%ller” or cobine a search across multiple Arrays with in- and excludes, for example? 
or joins ?
or find the records that satisfies 2 queries with a “and” or a “or” ?
arrays are ok only for very simple stuff, one table only with no relations.
Well the OP explicitly mentioned “sort, search, remove duplicates, edit certain cells etc”. If he had mentioned joins and unsharp searches I wouldn’t have suggested arrays.