How to copy files with ^ character

Salomon Henriquez 106 Reputation points Microsoft Employee
2022-12-01T16:03:29.82+00:00

Hello!
I'm trying to copy files from Azure blob to the on-prem location and these files contain ^ characters.
I run one ADF pipeline to rename the files but I get this error:
Error code: UserErrorWildcardEscapedCharNotSupported
Failure type: User configuration issue
Details:
ErrorCode=UserErrorWildcardEscapedCharNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The escaped character ^. is not recognized for wildcard filter (*, ?). If you want to use ^ in file name, specify ^^ to escape. Index: 8.,Source=Microsoft.DataTransfer.DataContracts,'
Any idea on how to solve this problem or what is the best way to copy the files to the on-prem side?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,487 questions
0 comments No comments
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2022-12-02T20:16:44.267+00:00

    Hello @Salomon Henriquez ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is copy the file with the name having the character "^" , please do let us know if its not accurate.
    I tried this with the file 1^.paraquet file . I was able to copy this file use ADF copy activity . The trick is to use ^^ in the wildcard expression as shown below .

    266744-image.png

    please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful