Look up specific csv values through jquery ajax

Question

Is it possible to use jQuery ajax to look up specific values from a csv file as needed, on say a button click?

For example, say the CSV has the following structure:

country, capital, population, currency,
france, paris, 65950000, euro,
italy, rome, 59685227, euro,

Could I return only the population count for italy?

I have seen a couple examples where the entire csv file is converted into js arrays before any value is returned, though would prefer avoiding this method if possible as the csv file is likely to be very big.

Software Engineer · Accepted Answer · 2013-10-21 08:25:53Z

1

You don't need to convert entire csv into js arrays:

Make a country dropdown in your HTML
On button click, pass POST parameters such as country, population to your server-side script (php, asp.net, whatever)
```
data: { country: "italy", find: "population" }
```
Read csv file on server
Find row that contains italy as country and extract your desired values, for example population
Only return your desired values back to client and read them in $.ajax() response

See Examples at the bottom of jQuery ajax page

answered Oct 21, 2013 at 8:25

Software Engineer

3,9861 gold badge28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

edith Over a year ago

is their no client side alternative? was hoping the csv file could be accessed in the same way as you would json

Collectives™ on Stack Overflow

Look up specific csv values through jquery ajax

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related