Each excel row activity

Nur_Amin · December 14, 2022, 12:06pm

CurrentRow.ByField(" LOB ").ToString.Is 1,2,3,4 () = false

can anyone help me on this? i want to change this coding to say that if other than numeric 1,2,3,4 is false? using above coding?

im using studio x each excel row to delete my first column that contain other than 1,2,3,4

Yoichi · December 14, 2022, 1:49pm

Hi,

How about the following condition?

not {"1","2","3","4"}.Contains(CurrentRow.ByField("LOB"))

OR

not {"1","2","3","4"}.Contains(CurrentRow.ByField("LOB").ToString)

Regards,

Nur_Amin · December 14, 2022, 2:01pm

what i need to start with ?

Nur_Amin · December 14, 2022, 2:02pm

not {“1”,“2”,“3”,“4”}.Contains(CurrentRow.ByField(“LOB”))CurrentIndex

like this?

Yoichi · December 14, 2022, 2:06pm

Hi,

Probably, like the following.

Nur_Amin · December 14, 2022, 3:20pm

can u help me to fix the error? can i give u the worksheet that i do?

Yoichi · December 14, 2022, 3:21pm

Hi,

What error do you have?

Regards,

Nur_Amin · December 14, 2022, 3:29pm

i tried to run, but my studio x still not finish run i think it almost 1 hrs. u have any idea?

Yoichi · December 14, 2022, 3:33pm

Hi,

How many rows are there in the worksheet?

For now, can you try to limit rows by setting like Excel.Sheet(“Sheet1”).Range(“A1:E20”) at InRange in ForEachExcelRow, for example?

Regards,

Nur_Amin · December 14, 2022, 3:39pm

i need to limit just to see the activity run is it?

coz, the report is daily. today the data file may be different with tomorror

Yoichi · December 14, 2022, 3:41pm

Hi,

The above limitation is for just to isolate cause.

Regards,

Nur_Amin · December 14, 2022, 3:44pm

i have done that n also i just run from activity each row to delete anything beside 1,2,3,4. but when i run it does not appear anything

Yoichi · December 14, 2022, 3:46pm

Can you share your input and expected output?

Nur_Amin · December 14, 2022, 3:46pm

this is the error

Yoichi · December 14, 2022, 3:52pm

Hi,

There might be zombie process of excel. Can you check if it exists, using TaskManager of OS?
If exists, please kill them.

Regards,

Nur_Amin · December 14, 2022, 3:55pm

how to do that?

also attach my input(text file) and output excel
EXAMPLE.xlsx (10.0 KB)
EXAMPLE.txt (651 Bytes)

Nur_Amin · December 14, 2022, 4:47pm

Can assist me on this?

Yoichi · December 15, 2022, 1:06am

Hi,

It mostly seems string manipulation matter. How about the following?

Regards,

Nur_Amin · December 19, 2022, 6:18am

May i ask why i cant find this replace activity in my UiPath studio x?

Yoichi · December 19, 2022, 6:28am

Hi,

Can you try to turn on “ShowDeveloper” at Filter in Activities panel.

Regards,