Extract and transfer file assistance

[jnolfo]

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.

1. 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?

2. 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 solution]

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!

[jnolfo]

Thanks for this.  Let me inform that group and see if they can fix on their end.

[Sukrity_Wadhwa]

Hi @jnolfo,

Were you able to fix this issue with the help of the given solution? Do let us know.

Thanks!

[jnolfo]

Yes, this did.

[Sukrity_Wadhwa]

Thanks for the update. 🙂