Código MySQL:
Ver original+--------+------------+-------------+--------------------+------------+----------------+--------+--------+
| serial | idtienda
| cod_cli
| nom_cli
| fec_ini
| dir_cli
| ciudad
| estado
| +--------+------------+-------------+--------------------+------------+----------------+--------+--------+
| 26910 | J297360484 | V-11314359 | LEO RAMIREZ | 2011-03-01 | CHACAO | 02 | 17 |
| 51097 | J297360484 | V-17299706 | MARIANA LOVERA | 2011-08-30 | CHACO | 02 | 17 |
| 38481 | J297360484 | V12711577 | MARIA GABRIELA | 2011-05-12 | LA FLORIDA | 02 | 17 |
| 63683 | J297360484 | V-6902451 | CAROLIN A QUINTERO | 2012-01-14 | SAN BERNARDINO | 02 | 17 |
| 59657 | J297360484 | E-82069791. | ALEJANDRA | 2011-12-05 | CCS | 02 | 17 |
| 87586 | J297360484 | V-987990 | MARIO | 2012-12-14 | CCS | 02 | 17 |
| 61121 | J297360484 | V-15713105 | GERALDINE OCHOA | 2011-12-20 | CCS | 02 | 17 |
| 86005 | J297360484 | V-16898869 | OLIVER HERNANDEZ | 2012-11-20 | CCS | 02 | 17 |
| 69051 | J297360484 | V-10814054 | MONICA MILLAN }}} | 2012-03-21 | CCS | 02 | 17 |
| 71593 | J297360484 | V-12476593 | SUSAN USECHE | 2012-04-27 | SAN IGNACIO | 02 | 17 |
+--------+------------+-------------+--------------------+------------+----------------+--------+--------+
10 rows
in set (0.29 sec
)
alli hay un E- ... y V- ...
INcluso hay datos que no cumplen ese formato (por error del usuario no los agrego correctamente)