怎么使用存储过程和游标截取空格字符串

如何使用存储过程和游标截取空格字符串
数据库中已存在一个BB表格，该表格显示为(省略号代表下面还有很多同样的数据）
电缆线编号            路径顺序号        路径类型             路径
   A1                                                1DU2E 1DU2A

  A2                                                 1DU2E 1DU2A

  A3                                                 1EA/B 1E205
 ...                                                    .....
如何使用存储过程和游标将表格生成为
电缆线编号            路径顺序号        路径类型             路径
   A1                   1                             1DU2E 
                        2                            1DU2A

  A2                    1                            1DU2E 
                        2                            1DU2A

  A3                    1                             1EA/B 
                        2                             1E205
 ...                                                   ...