Is there a way to extract Folder Content details : Name, Title, ...?

Help Studio
1

Dears,

Is there a way to extract Folder Content details : Name, Title, … ?

I’ve check the Directory.GetFiles, I see only some list of items as follows :

image

For Name it’s OK, I need especially Title . Thanks in Advance

2

@hsendel

Can you share me the sample output you required?
What do you mean by Title?

Thanks

1 Like
3

Hi @Srini84 , Thanks for Quick Feedback.
Title generally used for folders which contains Audio files inside a folder as shown in below screen shot:

image
image716×90 3.06 KB

Thanks

4

Hi

Hope these steps would help you resolve this

To get the name of the file

In a assign activity

Str_title = New System.IO.FileInfo(“your FilePath”).Name.ToString

I couldn’t find any method to get the title (extended properties of a file)

Even we can get size of the file in KB

Cheers @hsendel

1 Like
5

maybe this helps:

3 Likes
6

Thanks @ppr , Seems useful, but I the output is not showing detailed informations , I got only the following : System.Collections.Generic.Dictionary`2[System.String,System.String]

7

Thanks @Palaniyappan , for Name it should be fine, the option exists in GetFileName, the issue is with Title

8

Hmm
Being collections did we try to mention the index position and see what value comes in

@hsendel

1 Like
9

looks like you tried wit a toString to dumpout Dictionary Content, right?
If so, this will not work. Fastest Check of the result will be debugging along with breakpoint setting and and inspect locals panel while get paused

1 Like
10

Hi @Palaniyappan , I used same package shared by @ppr ad build the workflow as follows :

image

11

@ppr , what should be the settings for : image

Because I remove ToString, I got error image

12

Let me say it again. Both methods will not do a dumpout of the dictionary contents. Add to your development practive to use debugging when inspecting part results. This is faster and straight forward.

If we would mandatory need such a string then give a try on following

String.Join(Environment. NewLine, FileDetails.Select(Function (x) x.Key &“:”& x.Value))

1 Like
13

Thanks @ppr , I will check and revert back to you.

- → EDIT : It’s Working fine …Thanks @ppr and Team for your support.

14

@ppr , Last Question: Based on the output received, How to filter only what we need from Key&Value Collection ( Example : Title) ? Please refer to attached file for generated ListList.txt (359 Bytes)

15

Bring the list values from List.txt into an array / list - arrKeyList
then give a try on

(dictFiltered =
From k in YourDicitonary
Where arrKeyList.Contains(k.Key)
Select kvp=k).toDictionary(Function (x) x.Key, Function (x) x.Value

1 Like
16

Dear @ppr Let me try and update you :+1:

17

→ EDIT : Perfect Peter :+1:

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.