Importing delimited data convoluted with commas
Tue, 05/17/2011 - 03:28 pm
Here is the twist. The data is tab delimited, but the numeric values greater than 1000 has a comma in it, e.g. 1312 is written as 1,312. How do I bring this data in and rid the damn commas.
What I have tried thus far:
1. Use only tab delimiters in the tweaks dialog and "treat all columns as numeric. Does not work only gives me the data before the column.
2. Load as a notebook and do a search and replace on comma. Then re-save data and open again Beachballs Igor and I must force quit.
Any other hints.