We have an agreement with another site to maintain some data for us. Because they won't make the data available via XML or give us DB accesss, I'm using CFHTTP to do some screen-scraping. However, I only want to use a few columns of the HTML table I am getting. I'm fairly new to CF and am not seeing a way that I can capture a specific number of columns (or delete a specific number of columns).
In other languages (maybe FoxPro?), there was a function that would tell me the position of the nth occurrence of a string, but I'm not seeing a similar function in CF. Can someone get me pointed in the right direction?