Extract rows items from Column data

Help Studio
, ,
1

Hi All,

For my column name “Parameters” , I am getting in following below value for each row. How can I extract both the datas separately. Each row has multiple values as 1, 2 etc
I want to extract 1. “As of” value and 2 "Subsdiary Context: value

The image is a table with financial parameters including account names and statement dates, where some text is obscured or redacted. (Captioned by AI)
The image is a table with financial parameters including account names and statement dates, where some text is obscured or redacted. (Captioned by AI)531×589 83.8 KB

2

@dutta.marina try to split each row by environment.newline

currentRow.split(environment.newline)
3

Hi @dutta.marina

Can you try like below

A workflow diagram depicting the process of reading data from an Excel file, iterating through each row and column, and displaying the content in message boxes. (Captioned by AI)
A workflow diagram depicting the process of reading data from an Excel file, iterating through each row and column, and displaying the content in message boxes. (Captioned by AI)1147×748 31.7 KB

Regards,

4

Hii,@dutta.marina

under for each data row item use this one
currentRow(“Parameter”).ToString.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)

hope this will be helpful!!

5

@lrtetala

I have read the excel in get Transaction data. If I want to use this way how can i do ?

This image shows a segment of a workflow where a variable 'str_reportParameters' is being assigned the value of 'in_TransactionItem("Parameters").ToString'. (Captioned by AI)
This image shows a segment of a workflow where a variable 'str_reportParameters' is being assigned the value of 'in_TransactionItem("Parameters").ToString'. (Captioned by AI)838×177 19.9 KB

The value of str_reportParameter is coming as:I want to get the value of 1 “As of” 2. “Susbdiary Context”:

A screenshot showing a list of status updates for a transaction process, including steps like getting the transaction item, processing transaction number 1, and report parameters with some text redacted. (Captioned by AI)
A screenshot showing a list of status updates for a transaction process, including steps like getting the transaction item, processing transaction number 1, and report parameters with some text redacted. (Captioned by AI)478×225 20.1 KB

6

@Somanath1

I have read the excel in get Transaction data. If I want to use this way how can i do ?

This image shows a segment of a workflow where a variable 'str_reportParameters' is being assigned the value of 'in_TransactionItem("Parameters").ToString'. (Captioned by AI)
This image shows a segment of a workflow where a variable 'str_reportParameters' is being assigned the value of 'in_TransactionItem("Parameters").ToString'. (Captioned by AI)838×177 19.9 KB

The value of str_reportParameter is coming as:I want to get the value of 1 “As of” 2. “Susbdiary Context”:

A screenshot showing a list of status updates for a transaction process, including steps like getting the transaction item, processing transaction number 1, and report parameters with some text redacted. (Captioned by AI)
A screenshot showing a list of status updates for a transaction process, including steps like getting the transaction item, processing transaction number 1, and report parameters with some text redacted. (Captioned by AI)478×225 20.1 KB

7

@dutta.marina

You need to give like below

This image shows a flowchart-like UI automation sequence that begins with a "Comment Out" action, followed by an assignment operation to save specific data, iterates through the items with a "For Each" loop, and ends by displaying each item in a message box. (Captioned by AI)
This image shows a flowchart-like UI automation sequence that begins with a "Comment Out" action, followed by an assignment operation to save specific data, iterates through the items with a "For Each" loop, and ends by displaying each item in a message box. (Captioned by AI)1164×564 24.5 KB

Regards,

1 Like
8

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