Extract and transfer file assistance

Question

I have a extract and transfer of a delivery log that I am needing help with.

The workflow that I have works correctly and the file is being pushed into an Azure Blob (I can see the file there). There are two issues that seem to be ACS related that I need help with.

The output file is a CSV (Excel) format. Each field has a set of double quotes around it. Unfortunately, the process after the Blob is messed up with these. Any way to not include those?
ACS seems to be adding an additional "blank" record (shown by the cursor in the screenshot). This is making the the process after the Blob to fail. Thoughts to prevent a blank record?

SatheeskannaK · Accepted Answer

Hi @jnolfo,

If you open the CSV file on text editor it will show extract with double quotes and same thing goes for additional blank line at the end. Try open the file using excel and it should be formatted properly with blank line.

Thanks!

Sukrity_Wadhwa · Answer

Hi @jnolfo,Were you able to fix this issue with the help of the given solution? Do let us know.Thanks!

Sign up

Login with SSO

Login to the community

Login with SSO