Condition required for accessing multiple file formats

I have to automate sales process. I have the sales order in various formats like .csv, .pdf, .xlsx etc. and i’d like to make a single bot which can access all these formats simultaneously. So, i thought to start this process by giving a condition but i’m unable to execute my thought process. So, kindly help me in this by giving some suggestions or ideas.

Thanks in advance.

1 Like

Hi
So we know the exact number of possible formats we will be getting
Because if we know that once after getting the file path from that folder with a assign activity like this
arrFiles = Directory.GetFiles(“yourfolderpath”)
Where arrFiles is a variable of type array of string

Which will be then passed to FOR EACH activity and inside that use a IF condition like this
item.ToString.Contains(“.pdf”)
If true it will go to THEN part where we can use READ PDF or READ PDF WITH OCR

Next to this IF condition we can use another If condition like this
item.ToString.Contains(“.csv”)
If true it will go to THEN part where we can use READ CSV FILE activity

Similarly for all formats we know

@Sivasees_Rajguru

3 Likes

Let me try by implementing this idea and let you know.

Thank you very much for this quick response.

1 Like

Cheers @Sivasees_Rajguru

1 Like