How to read CSV with Directory. GetFiles

Help Studio
1

I’m working on a project where I download a data file without the extension to the “test” folder on my desktop. Then I read data file to CSV with UTF-8

The data start with CSPD004 and another data start with CSPD005, and I want to output those data each to a different CSV for use to
total after filter data.

I use the For Each activity
For Each “item " in “test folder. where(function (file) file. Contains (” CSAPD005”)). ToArray"

Type Argument changes "String "

I checked it with "Message Box "
It’s function.

This is where the problem lies.

How do I go about creating “read csv”

This is my first job and really this problem isover my head.
I hope you understand my explaion is sometime unclear because I’m a beginner.

Thanks for your time!

2

@tesoro

Welcome to community

I didn’t understand download data file without extension?

Can you share few screenshots and errors you are facing?

Thanks

4

@tesoro - You mean, just to *.CSV files? if so, you can try the below

Directory.GetFiles(Filepath,“*.CSV”)

6

@tesoro - It working fine for me. Something wrong with your setup.

7

Put “*.CSV” Not “*”.CSV

8

Thank you .I did it just now!!!

9

Thank you .I did it.

10

@tesoro…great… please mark my as solution so that this thread will be closed.