Convert comma seperated text to a dictionary

Help Studio
, ,
1

i am having a textfile which contains key values with comma seperated. how can i convert it into dictionary without using generate datatable activity.

example data in text file –

Name,Value,Description
logF_BusinessProcessName,Mobility,
Process Related,
BotName,MasterBot,
Case_Limit,3000,
Initialization Email List,

I need to read this text file and convert it into dictionary

2

Hi @Sree_Krishnan_vellinezhi

May I know the expected output.

3

DIctionary need to assign as key value pair

for example

keys-- logF_BusinessProcessName,Processrelated,Botname,CaseLimit,Initializationmaillist
values-Mobility,Masterbot,3000

4

In your example text there is no equal pairs of key and value. Check once @Sree_Krishnan_vellinezhi

5

yeah some keys are having blank values , that we have to ignore

6

looks like CSV data

so we can do:

  • Read CSV Activity - out: dtData

Assign Activity:
dictData | Dictionary(OF String, String) =
dtData.AsEnumerable.ToDictionary(Function (x) x(0).toString, Function (x) x(1).toString)

grafik

7

Give me the pairs properly @Sree_Krishnan_vellinezhi

8

@ppr any way to avoid Datatable ?
this one i have already done

9

leave it bro u cant … thanks for your response

10

grafik

11

Even we can use generate datatable using comma seperation and convert it but am trying to convert it without datatable involvement.

12

You said it is text and you provided input is wrong. There is no spaces between some of the commas. How can I validate in which place there is spaces. @Sree_Krishnan_vellinezhi

13

how u r reading a text file using read csv activity ??? this comes in a text file

14

grafik

15

image
image1447×229 15.6 KB

Can we avoid duplicates in the linq ?

16

grafik
grafik1087×61 26.2 KB

17

Yes

Just redefine in detail and at complete base the use case along with representative sample data.
We will have a look at the revised description

18

You mean i need to try the latest query ?

19

See here @Sree_Krishnan_vellinezhi

If your input as below

logF_BusinessProcessName,Mobility,
Process Related,,
BotName,MasterBot,
Case_Limit,3000,
Initialization Email List,,

Then here is the output,
image

If you don’t know how to do it check the below workflow,

_2024
_2024884×1682 114 KB

2024.xaml (19.3 KB)

Hope you understand!!

20

how this will work for dictionary of string,object