Possible to filter row by number of character

[Anneng]

Hi Expert.

I would like to filter out all this not a comment in the comments field. Some are not standard english words and it is not efficient to filter word 1 by 1 and it will end up 100 filter remove row condition in the uipath. I wonder if there is way to filter away the cell contain less than 5 characters?

[prasath_S]

Hi @Anneng

Please try this

dtTable - datatable

dtTable = dtTable.asenumerable.where(function(d) d(“comments”).tostring.length <5).copytodatatable

Thanks

[Anneng]

It doesn’t work, now i only left with rows that contain less than 5 characters. I want to remove them not keep them. I know what to keep comments that is meaningful. Should i use > 5 in the script instead of < 5?

[prasath_S]

@Anneng

Yes please use > 5

[Anneng]

I’m sorry, it didn’t work in previous reply, what it does is, it sorted out the character <5 or >5 to be in the front rows. I tot is work but after i check the number of row with the source file, it look the same. It didn’t delete. let me add delete range and test it out. BRB

[Anneng]

Thanks for your help. It works after i insert delete range.

Regards
Anne

[Pankaj.Patil (Robot Master)]

@Anneng,

I like to suggest other solution apart from provided by @prasath_S’s,
Use For Row activity and use activity to validate it.

1. Create intIndex variable that property is of For each row activity
2. provide intIndex to Insert/Delete row activty in position property, and also select Remove from Change mode property of same activity.

[Anneng]

Thanks, i will try them out later.