Hi Team, I want filter one “yyy” column if found 7 digit number start with "002"or "003 or “004” and if 5 digit start with “2” or “3” or “4” we should add in valid sheet else invalid sheet. Please help me anyone for this. I have attachment sample for your reference digit.xlsx (10.7 KB) Regards, …

[image] Raja.G: other approach to process this what was tried from your side so far? which difficulties did you face? Variables: [grafik] dtData is the result of reading in the excel (e.g. read range) [grafik] dtFiltered = (From d In dtData.AsEnumerable Let v = d(1).toString.trim Let …

How to apply filter based on row value digit count

Help Activities

Gowtham_K115 (Gowtham Krishnan) November 7, 2024, 6:57am 7

Hi @Raja.G

Try the below approach,

How to apply filter based on row value digit count.xaml (22.8 KB)

Output Excel : digit.xlsx (10.8 KB)

Regards,
Gowtham k

1 Like

Topic		Replies	Views
Help me with regular expression to filter excel based on the words present on 1st column Activities excel , activities , question	14	1255	October 16, 2023
Need to filter a column in excel that starts with same first 2 numbers Help	9	2288	August 20, 2018
How to filter state wise based on column value Activities excel , activities , question	4	78	October 23, 2024
I want to filter all the values in the column A of the excel 20 Use Cases Learning Sprint activities , studio , question	3	66	January 7, 2025
Can Someone help me with filtering excel column which has a date Studio uiautomation	10	1029	March 28, 2022

How to apply filter based on row value digit count

Related topics