Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Extract and transfer file assistance

jnolfo
Level 2
Level 2

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?

    Snag_6b14b7a3.png
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution
SatheeskannaK
Correct answer by
Community Advisor
Community Advisor

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!

View solution in original post

5 Replies
SatheeskannaK
Correct answer by
Community Advisor
Community Advisor

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!

View solution in original post

jnolfo
Level 2
Level 2

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

Sukrity_Wadhwa
Employee
Employee

Hi @jnolfo,

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

Thanks!