Selecting entry from Data Table

Help Robot
,
1

Hello all, this is the data table I am having,

image
image970×278 24.9 KB

From the column name “Material”

  1. I wish to extract the value which starts from digit ‘5’.
  2. The value then extracted should exclude all preceeding 0’s from it

Regards,
Hardik Durgam.

2

Hi @Hardik_Durgam,

(from s in dt.AsEnumerable where s(“Material”).tostring.trimstart("0"c).Startswith(“5”) select s(“Material”).Tostring.TrimStart("0"c)).ToArray

This gives all required data in array of string.

Hope it helps.

3

Hey @Hardik_Durgam ,
You can try this,

image
image617×600 17.7 KB

Regards,

4

@Harshith_Adyanthaya will this give me value in string format?

5

It gives in Array of String format.

6

@Harshith_Adyanthaya ,
No According to @Harshith_Adyanthaya method it will be stored in an Array of string .
Put a for each loop for the array . there you will get the each items inside for each.

Regards,

7

@Harshith_Adyanthaya can you help me out by sending the code which gives output in string format?

8

String.Join(“,”, (from s in dt.AsEnumerable where s(“Material”).tostring.trimstart("0"c).Startswith(“5”) select s(“Material”).Tostring.TrimStart("0"c)).ToArray)

This will give all values in String. Comma seperated.

9

@Jithesh_R could you please share your workflow if possible?

10

@Hardik_Durgam ,
FilterDataTable03.zip (2.2 KB)
FilterDataTable03.xlsx (8.5 KB)

This workflow returns the values which starts with 5 Individually.
Let me know if this is not your required output

Regards,