How to validate if column name's value start from the column name itself

[Rohit_Patil1 (Rohit Patil)]

Hi, I want to validate if values of columns starting from column name itself. Say suppose I have diffirent column names like A, D, R etc. and their values like A1, D1, R1. So I want to validate that value of respective column are exactly below of their column.
For Ex.

In above Image, the values of respective columns are exactly starting from column name itself. If it is not then it should throw an error.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Check the inputstring.startswith(column name) inside for each of column

[Rohit_Patil1 (Rohit Patil)]

Thanks for the reply Sangeetha. Let me try with this way

[Yoichi]

Hi,

If you need just validation result (True or False) the following condition will work.

dt.AsEnumerable.All(Function(r) dt.Columns.Cast(Of DataColumn).All(Function(dc) r(dc.ColumnName).ToString.StartsWith(dc.ColumnName)))

Regards,

[Rohit_Patil1 (Rohit Patil)]

Thanks Yoichi, Will try this one also.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Main.xaml (14.0 KB) @Rohit_Patil1