Data Manipulate

Help Studio
1

Hi Ui Path,

I have data as below:

ColumnName ColumnName1
Mirza 01
Mustaba 04
Hussain 10
ABC 01
XYZ 10
123 04
Mirza 05
Mustaba 09
Hussain 06
Friend1 01
Friend2 04
Friend3 10
I just want to get “Mirza” and “Friend2” and their particular code from ‘ColumnName1’, Any suggestions or help!
Thank you!

2

Hey,
you can use read range activity
for each row
strVar=row(“ColumnName”).tostring
if Split(strVar," “)(0).contains(“Mirza”) or Split(strVar,” ")(0).contains(“Friends2”)
then
strVar=row(“ColumnName”).tostring
else
continue Activity
thanks

3

Hello @Mirza_Hussain,

Is this in an Excel file? If so i would read it into a datatable and then use the Lookup data Table activity

Best,

4

Hi @Mirza_Hussain,

In order to make inferences, it is necessary to know whether the data will always come in this way and whether you will always need these two outputs. Also, are these outputs taken from an excel?

If so ;

1-Read the excel using the “read range” activity. (inputDT)
2-Filter the data by the ranges you want using the “Filter datatable” activity or “assign activity”

MirzaDT=inputDT.Select("[ColumnName]='Mirza'").CopyToDataTable
Friend2DT=inputDT.Select("[ColumnName]='Friend2'").CopyToDataTable

3-The 1st column of the output tables will give you the IDs.

Regards,
MY

5

DT=DT.Asenumerable.where(Function(r) r(0).Tostring=“Mirza” or r(0).Tostring=“Friend1”).copytodatatable

str=DT.Asenumerable.First().item(1).Tostring
str1=DT.Asenumerable.Last().item(1).Tostring

6

Hi,

This is not in excel file

7

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