Unanswered

CSV UTF-8 Comma delimited or CSV Comma delimited Check

(0) Share

Report

Posted on by sree813

Dear,

How to find whether the CSV file format is either Comma delimited UTF-8 or just CSV comma delimited?
My flow works only on CSV Comma delimited and I would like to check the format so that the flow will not fail.
Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @sree813 ,

Based on my test, if it's a file with CSV UTF-8 format, the file content starts with "77u/":

otherwise, there isn't:

So, you can use a condition the check the content:

outputs('Get_file_content')?['body']['$content']

or

outputs('Get_file_content_using_path')?['body']['$content']

according to previous action you use in the flow.

Best regards,

Was this reply helpful? Yes No
sree813 77 on at

Like (0)

Report

Hi @v-jefferni,

Thanks for the idea. It works.

Cheers.

Was this reply helpful? Yes No