How to filter the transaction items information

Dear Colleagues,

How can i split the information in the transaction item ?

Someone know the syntax for it ?

Hi @Lucas_Silva
use this


ashwin S

Are you talking about the Data that you added in the Specialdata collection?
Can you Share a Screenshot of this (Panel with the Special Data configuration)

What is the Intention to split? Can you please Share some more Details with ist. Thanks

Basically i want to split it inside the Process, to insert information in a site where my activity should do.

I didnt get you. Can you give more details on
What Forms the transation Item Data
What will be inserted within the Process


@ppr, I actually didn’t understand however I am trying to answer.

There can be two ways-

  1. There is only one argument and you are storing everything into it using any delimiter like comma (,) - Then you can use split command to extract all items individually.
  2. There are multiple arguments - You can use this syntax to retrieve data TransactionItemName.SpecificContent("ArguementName").ToString

Hope it will help you out.


Kindly Note that @Lucas_Silva was opening the topic. I was asking on more Details only.

@Lucas_Silva vikaskulhari named a few Options. Take a Note on following: transactionitemvar.SpecificContent ist of Datatype dictionary (Of String, Object)

So even the dictionary methods as even LINQ can be used If necessary.

In Case of you need more Help please Share some more Details with US. Thanks

1 Like

@vikaskulhari @ppr

Let me explain my intire Process.
I will read an excel file, and them extract some information there, like name / id and some another information.

The way i built it basically, it reads the excel file, apply some filters to only process the information that i want to, after it the information from excel is gathered in a TransactionData, and them i want to have the individual information, like name, correctly syncronized , so i need to somehow split the information, which when transformed in a transationItem it comes like "Lucas, 15 years old, high school " i want to split and storage the information like:

NameVariable : “Lucas”
AgeVariable : “15”
SchoolLevelVariable: “high school”

do it for every simple TransactionItem, how could i do this ?

@Lucas_Silva, please use this code

NameVariable = Split(TransactionItem, “,”)(0)
AgeVariable = Split(TransactionItem, “,”)(1)
SchoolLevelVariable =Split(TransactionItem, “,”)(2)

That’s it