Forum Discussion
arpost
Post Prodigy
Post ProdigyHow to handle quotes within a string in Copy Activity?
Greetings, community. I have a CSV file I am trying to load into a Lakehouse using a Copy Activity and am having some trouble related to characters in the file. Here is a fake data sample: "ColumnA"...
Hi arpost ,
As I understand, without having any escape characters we cannot handle this kind of data in data pipeline. This data will be treated as bad data and make it to null. You can continue using Data flow as you were able to find a solution with the help of it.
Thank you
arpostPost Prodigy
Post ProdigyAnonymous, bummer. Thanks for the info and for looking into it, though. Dataflow really isn't ideal (if for no other reason than dataflows aren't supported in deployment pipelines), so I'll keep looking.
Hi arpost ,
Glad to know that you got some insights over your query. Please continue using Fabric Community on your further queries.