Extract value from the Column INVNO and VNAME

Help
1

DailyInput.xlsx (8.5 KB)

Hi Team
I need to extract value from INVNO and VNAME and input it in the screen.In the INVNO for Example
GIV480595,GIV484913,GIV484917 need to extract value from one row individually and show output.
A/C:5.22603.00.00.100002S(0193901763061235)-Need to extract value (0193901763061235) from the complete account.

2

Need quick support.
Thanks
ArjyaDailyInput.xlsx (8.5 KB)

3

HI @arjyadas,

Use Read Range activity to get the data.

using for each row activity loop through it.

row(“INVNO”).Tostring()
row(“VNAME”).Tostring()

you can get the all values.

Regards,
Arivu

4

Hi @arjyadas,
By using following command we can get value from DataTable using Loop by increment count value
DataTable.Rows(count).item(“Column_Name”).ToString
Or
By using For Each Row we can iterate the dataTable to get valueForEach

Regards,

5

Hi Team
I want to split value GIV480595,GIV484913,GIV484917 after commas and value within bracket A/C:5.22603.00.00.100002S(0193901763061235).Do mention how to achieve it.

Thanks
Arjya

6

Hi @arjyadas,

use the below code

strValue.Split("("c)(1).replace(")","")

before using this code in if condition check the “(” is present or not

if exists only you need to use this code else use strValue only.

regards,
Arivu

7

Hi Team
I have used the function
strINVNO.Split({“,“C}).Last.ToString.Replace(”,”,“”)
the out put is coming if two values GIV484913,GIV484917 then only last value GIV484917 is coming.How to get the two or multiple output from same row.Also also need to loop if mutiple value.Please confirm.

8

Hi Arjydas

       I attached my solution.Please let me know if you have doubt .<a class="attachment" href="/uploads/default/original/3X/b/9/b964a72cf9d4632b354324b7128f5a835797f373.zip">DailyInput.zip</a> (2.1 KB)