Hi,
I have excel sheet .ı found each of length ın rows. I want to remove (using filter data table) row.lentgh<20
Can u help me please?
Have a good day.
The length is for single column right?
If you check length for single column then use this syntax,
dtTable = dtTable.asenumerable.where(function (d) d(“columnname”).tostring.length < 20). copytodatatable
it will remove the value which is more than 20 characters
1 Like
THANK YOU IT WORKED
Happy to hear 
please mark it as solution if the issue is resolved…
new issue my write line consist of 55,1 euro but when ıt write range 551 euro (there is no comma) ı didn,t understand it.
that is output.
Write line or datatable…
Hi,
Can u help me please?
My output panel consist of
VEGETABLES
tomato
patato
pipper
FRUITS
apple
orange
banana
DRINKS
water
mıneral water
COLOURS
whıte
blue
red
and so on
I have excel sheet VEGETABLES(A1CELL),FRUITS(B1CELL),DRINKS(C1CELL),COLOURS(D1CELL)
how can my robot write excell sheet ?
Have a good day.