Filtering out the character oriented entries

Help Studio
, ,
1

Hi,
I have a column named Serial which contains integer and varchar values also.
I have to filter the values containing/starting with characters.
Please find the excel containing the enteries.
SerialNumber.xlsx (9.2 KB)
Please let me know how can we solve this?
Thanks in advance!!

2

@Kunal_Jain

you can use this

dt.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(x("Serial").ToString,"[A-Za-z]")).CopyToDataTable

cheers

3

Hi @Kunal_Jain

Try this:
For each row in excel:
To check if the value has Characters
if(System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Col_Name"),"[A-Za-z]"))
output:True or False

4

@Anil_G
I should use this in assign activity?

5

@Kunal_Jain

Yes use in assign on right and left will be your outputdt with required data

cheers

6

Hi @Anil_G
Actually the expression is giving the output as values containing characters
We need the output of the values without that values.
Thanks!!

7

Hi @Kunal_Jain

Try this
`

(?<=[A-Za-z])[\d+].*

`
image

or if you want this try

[A-Za-z].*

image

8

TEst.xlsx (7.2 KB)
We are getting this as output
Op.xlsx (9.1 KB)
We need the output like the above file I have shared

9

@Kunal_Jain

Try this

[A-Za-z].*

image

10

Hi @lrtetala
Where should I pass this expression?

11

@Kunal_Jain

dt.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(x(“Serial”).ToString,“([A-Za-z].*)”)).CopyToDataTable

12

@lrtetala
I need the output in the below mentioned format.

Please have a look at Op.xlsx sheet.
Thanks!!

13

@Kunal_Jain

Try this

dt.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(x(“Serial”).ToString,“((?<=[A-Za-z])[\d+].*)”)).CopyToDataTable

14

Hi @lrtetala
No this is not working,It is giving the same output as TEst.xlsx sheet.

15

@Kunal_Jain

It is working see this

((?<=[A-Za-z])[\d+].*)

image

16

I have used the same expression that you have provided

17

@Anil_G
Is there some way by which we can make a change in the same expression and get the desired output?

18

@Kunal_Jain

Use this:
dt.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(x(“Serial”).ToString,“((?<=\n)[\d+].*)”)).CopyToDataTable

19

@supriya117
Assign: The source contains no DataRows.
This is the Error

20

@Kunal_Jain

Then you need to include a Not as below. that should give you expected output

dt.AsEnumerable.Where(function(x) Not System.Text.RegularExpressions.Regex.IsMatch(x("Serial").ToString,"[A-Za-z]")).CopyToDataTable

Hope this helps

cheers