Skip to content

Instantly share code, notes, and snippets.

@blackymetal
Created January 24, 2013 03:15
Show Gist options
  • Save blackymetal/4617346 to your computer and use it in GitHub Desktop.
Save blackymetal/4617346 to your computer and use it in GitHub Desktop.
Convierte a SQL
Regexp ^([\w\W]{8})\s{3}([^\n]+[^\s]+)\s+([A-Z\s]{2})\s{10}$
Replace INSERT INTO proveedores(id, nombre, pais_id) VALUE ('$1', '$2', '$3');
AT001825 ELIMPEX A
HK004391 HIMALI ELECTRONICS INTERNATIONAL H
AD000014 CILINDROS Y CROMADOS S.A. AD
AE000010 AL KEDDAH TRADING CO. LLC. AE
AE000029 GEOGAS TRADING S.A. AE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment