How to add key & value to the dictionary from the text file?

[jamunatj (jamuna)]

Hi ,

I need to add Number column value as (key) & Account description column values as (value) into the dictionary from the text file. Kindly refer input text file.

Input1.txt (932 Bytes)

Can anyone guide me please, How to add into the dictionary?

Thanks,

[Gokul001 (Gokul Balaji)]

Hi @jamunatj

Have a look on the thread

Txt to dictionary

Hello. I am starting to learn UiPath. I have a problem. We have a text file of the form: Position=“pos1” Cost=“1923” Position=“pos2” Cost=“5363” Position=“pos3” Cost=“8634” Position=“pos4” Cost=“2435” You need to write this data into a dictionary: pos1, 1923 pos2, 5363 pos3, 8634 pos4, 2435 help me please.

Hope it will helps

Regards
Gokul

[jamunatj (jamuna)]

Thanks for reply @Gokul001

I will check this but my input format is differ when compare to this file.

Thanks

[MarinAlexandru]

Hey,

Can you try to convert the txt file to csv then add the key/value pairs from the csv row by row? Where the key would be YourDictionary(row(“NUMBER”).ToString.Trim) and the value row(“ACCOUNT DESCRIPTION”)

[Shivaraju (UipathLearner)]

@jamunatj , you ca use GenerateDatatable activity to create the datatable with the input of type string and then you can add it to the dictionary with the appropriate columns as a key, value pair.

[ppr (Peter)]

@jamunatj

Feel free to decompose the oneliner to part steps

File.ReadAllLines(strFilePath)
.Skip(1)
.Where(Function (x) Not String.IsNullorEmpty(x.Trim))
.Select(Function (x) Regex.Split(x.Trim,"\s{2,}"))
.toDictionary(Function (x) x.First(),Function (x) x.Last())

[jamunatj (jamuna)]

Thanks for the reply. Could you please provide any sample xaml file. It will be helpful to move further.

Thanks,

[jamunatj (jamuna)]

Thanks for the reply, Could you please provide any Sample xaml file .

Thanks,

[ppr (Peter)]

As you asked for XAML Implementation help find some starter for the decomposed version here:

import: System.Text.RegularExpressions to the Namespaces (imports panel, next to variable panel)

strFilePath | String - FullFilePath to the text
dictLK | Dictionary(Of String, String), Default Value: new DIctionary(Of String, String)
arrSplit = Regex.Split(item.Trim,"\s{2,}")
dictLK(arrSplit.First) = arrSplit.last()

[jamunatj (jamuna)]

Thanks for the reply @ppr

I have tried the code as you mentioned in the screenshot. I got error while assigning arrSplit even through imported system.Text.RegularExpressions . Could you please guide me to move on from this.
AddToDictionary.xaml (7.0 KB)

[postwick (Paul)]

A dictionary could only hold one of those rows. You can’t put multiple rows in a dictionary. Why are you trying to convert to dictionary instead of just using the datatable?

[ppr (Peter)]

@jamunatj

through imported system.Text.RegularExpressions .

we do miss the import in your xaml
and when adding it we got:

strict option binding issue

which is caused by:

and was mentioned by

in the above screenshot

[jamunatj (jamuna)]

Thanks the response, I have imported system.Text.RegularExpressions from package , still getting “Regex is not declared” error. Kindly suggest me to move further.

Thanks,

[Gangadhar_Athili]

You Can Manually Write it as

System.Text.RegularExpressions.Regex.Split(YourStringVariable,RegexQuery)

[ppr (Peter)]

@ppr

import: System.Text.RegularExpressions to the Namespaces (imports panel, next to variable panel)

which is done like:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

so we can avoid the full qualified name System.Text.RegularExpressions and work directly with Regex.Split

@jamunatj

I have imported system.Text.RegularExpressions from package , stil

please remove it again from the package manager as you can avoid side effects when not referencing unneeded packages