How remove the keys wich empty or null value in de dictionary?

Help Activities
1

Hi guy,

How can I remove all keys in the variable dictionary of (string, string) which empty or null value?

2

Hi @VinhQuang

If you want to remove the keypair which key has empty or null value then use the LINQ Expression.

You can use the below expression in assign activity,

- Assign -> dictionaryVar = dictionaryVar.Where(Function(kvp) Not ((String.IsNullOrEmpty(kvp.Value)) andalso String.IsNullOrWhiteSpace(kvp.Value))).ToDictionary(Function(kvp) kvp.Key, Function(kvp) kvp.Value)

Check the below workflow for better understanding, It has removed Key1 key which is empty,

image
image1277×615 38.3 KB

Hope it helps!!

3

@VinhQuang

filteredDict = dict.Where(Function(pair) Not String.IsNullOrEmpty(pair.Value)).ToDictionary(Function(pair) pair.Key, Function(pair) pair.Value)
1 Like
4

Thank you very much! It works

5

It’s my pleasure… @VinhQuang

Happy Automation!!

6

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