OPRAG-OPREG

Somehow i need to do merge cell of my datagridview, and below script is how to do that Public Class MERGE_CELL_DGV Private Sub MERGE_CELL_DGV_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim Meja As New DataTable Dim CekBox As New DataGridViewCheckBoxColumn With Meja .Columns.Add("DEPT") .Columns.Add("SEKSI") .Columns.Add("NAMA") .Rows.Add("TCI", "C&N", "ALFIAN") .Rows.Add("TCI", "C&N", "YAKUB") .Rows.Add("TCI", "AF", "WIRAD") .Rows.Add("FIN", "CCA", "WULAN") .Rows.Add("FIN", "CCA", "DIAN") .Rows.Add("TCI", "AF", "TAUFIQ") .Rows.Add("TCI", "AF", "IRLON...

This is the way how to catch digit before a specific symbol, for this case the symbol means (desc "-"). situation would be as follows : "XXXXX-NAME" we would need to catch all "X" before desc "-", so value would be "XXXXX". even "X" is only 4 digits or more less we will get that all digit. VB Script would be as below to support our case : Click below picture for more clear preference