Extract table problems- comma in data

[Tysonk]

I'm trying to extract a table on a website. Right now I have it set to append to a CSV file. The problem is the table contains commas within the data which throws off the CSV file.

Does anyone know an alternate method or a way to not collect commas within the table?

[forumsupport]

Hello,

Is it possible for you to provide URL of website and steps to automate the data extraction process so we can create a sample as per the requirement?

Alternatively, please submit a support case from Automation Anywhere - Open A Support Case

Hope that helps.

[trentonponder]

There are a number of possible solutions:

1 - Use an If statement within the loop to check for commas. If the comma exists you can potentially use string manipulation to remove.

2 - Place quotes around all the extracted values

3 - Use the loop to write the data in Excel and save as .CSV later

as forumsupport said we would need more detail about the URL.