--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.
Martin and Ettore, yes I have 64-bits Java. Which text editor you recommend for that large file? Yes, it’s comma separated.
Tks Ettore.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.
Thanks to Thad, Ettore and Martin,
I did as instructed by Ettore to open the CSV file and save it as xlms. That solved my problem of loading and seeing the columns in Open Refine. It’s a parsing issue from the source when the CSV file it was generated. Thanks a million for aiding me.
import re
regex = re.compile(r'("(?:[^"]|"")*"|[^,"\n\r]*)(,|\r?\n|\r)')
return re.sub(regex, r"\1|||", value)
value.replace(/(^"|"$)/, '').trim()
Hi Ettore,
Your solution worked like a charm. Now the file is 99.5% clean. You are the man!