I am trying to extract data for Event, Time, and Points from a college swimming database. I scraped the table just like normal and got the result I wanted except the scrape is yielding unwanted text
I don’t want the Event column to include the meet at which the event was swam (the second line). I tried to scrape the table differently so that it won’t include the meet name but it’s still yielding it even when i specifically drag the event name only.
Once the table is scraped its exported to a data table (duh) in the format I would like except the Event column has the unwanted text. I’m trying to remove that text. I’ve looked around at splitting the string by Environment.NewLine and whatever other advice is out there but it isn’t working.
I’m wondering if splitting a string inside a data table requires different syntax but all I could think to do was add a .ToString to the end.
I’m glad you found a solution to your problem. If you could kindly mark the appropriate response as the solution to close this question and help people in the future.