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
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,
what i need to start with ?
not {“1”,“2”,“3”,“4”}.Contains(CurrentRow.ByField(“LOB”))CurrentIndex
like this?
can u help me to fix the error? can i give u the worksheet that i do?
Hi,
What error do you have?
Regards,
i tried to run, but my studio x still not finish run i think it almost 1 hrs. u have any idea?
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,
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
Hi,
The above limitation is for just to isolate cause.
Regards,
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
Can you share your input and expected output?
Hi,
There might be zombie process of excel. Can you check if it exists, using TaskManager of OS?
If exists, please kill them.
Regards,
how to do that?
also attach my input(text file) and output excel
EXAMPLE.xlsx (10.0 KB)
EXAMPLE.txt (651 Bytes)
Can assist me on this?
Hi,
It mostly seems string manipulation matter. How about the following?
NewBlankTask20221215-1.zip (62.2 KB)
Regards,
prashant1603765
V_Roboto_V
ashokkarale
mively
Yoichi
ppr
arivu96
Darshan_Sable
Anil_G
Chris.ro