title: I want to use part of the source file name as the file name in the sink folder. "Azure Synapse Analytics"
body: <p>I am trying to unzip a Zip folder with 21 files in the Synapse pipeline and create a folder with each file name and put each file in there.
  Example
  sorce: zipfolder/zipfiles(SRI W 01 maker メーカー.zip and SRI W 02 product_name 製品名.zip)/files(SRI W 01 maker メーカー.csv and SRI W 02 product_name 製品名.csv)</p>
  <p>I tried the below answer but the error occurred.
  I attached the screenshot of error messeage.
  <a href="https://i.stack.imgur.com/yNZjn.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>*&quot;メーカー&quot;,&quot;製品名&quot; are Japanese.</p>
  <p>sink: SRI W 01 maker(folder)/SRI W 01 maker.csv
  SRI W 02 product_name(folder)/SRI W 02 product_name.csv
  *I want to remove the Japanese part.</p>
  <p>This is an example of file structure, and the actual file names contain Japanese characters.
  The actual file name is
  &quot;SRI W 01 maker maker&quot;, which has a space and Japanese characters at the end, resulting in garbled characters.
  I would like to remove this Japanese part and create the folder and file names dynamically.</p>
  <p>Sorry for the poor explanation.
  If necessary, I can give you screenshots and other information.</p>
  <p>Source dataset is here:
  1.Zipped folder.(It has 21 zip files.)
  <a href="https://i.stack.imgur.com/OG4j9.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>2.21 zip files under the Zip folder.
  (Each of them has one file containing Japanese.)
  <a href="https://i.stack.imgur.com/5MjBa.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>3.Example of a file containing Japanese.
  <a href="https://i.stack.imgur.com/EBpt6.png" rel="nofollow noreferrer">enter image description here</a></p>