Re: Import fails on single quote.
Think Before You Click: This email originated outside our organization.
OK, it's not as straightforward as an unpaired single quote. I just had one
fail on:
"PET'1'"
So the single quote is paired, and caused the problem. So I changed it
OK, it's not as straightforward as an unpaired single quote. I just had one
fail on:
"PET'1'"
So the single quote is paired, and caused the problem. So I changed it to "PET
1"...and the whole import worked. But I got suspicious and started looking at
the data for single quotes and found things
||You might want to try escaping the single quotes in your data. Either by
doubling them up or switching double quotes for dollar-quoted strings.||
It's not my data. That's why I'm importing it.
‐‐‐ Original Message ‐‐‐
On Tuesday, May 11th, 2021 at 12:16 PM, richard coleman
wrote:
> B
Blake,
You might want to try escaping the single quotes in your data. Either by
doubling them up or switching double quotes for dollar-quoted strings.
Just a thought,
rik.
On Tue, May 11, 2021 at 3:02 PM dsbw wrote:
> Hello,
>
> Trying to import data, tab-delimited but unfortunately with q
