Skip to content

Instantly share code, notes, and snippets.

@ebermudezGit

ebermudezGit/Instructions

Forked from arreisGit/Instructions
Created September 25, 2017 17:13
Show Gist options
  • Save ebermudezGit/be0c8cb71a33fd932bd43c47faa1dd92 to your computer and use it in GitHub Desktop.
Save ebermudezGit/be0c8cb71a33fd932bd43c47faa1dd92 to your computer and use it in GitHub Desktop.
Download ZIP
INTELISIS new Exp to old Exp
Raw
Instructions
Use any plain text editor ( vim , notepad ++) that allows you to seek and replace regular expresions, then look and replace the next
regex for <BR>.
REGEX: /(\(Inicio\)|=\(Fin\)|=(,?<?\w+>?(\.|\,|\ )?)+)\r?\n?/ig
The above instruction would turn:
[Table.tbl/Tabla.SQL]
(Inicio)=SELECT
SELECT=Campo1,
Campo1,=Campo2,
Campo2,=Campo3,
Campo3=FROM Tabla
FROM Tabla=JOIN Tabla2 t2 ON t2.Campo1 <IGUAL> Tabla.Campo1
INTO
[Table.tbl/Tabla.SQL]
<BR><BR>SELECT<BR>Campo1,<BR>Campo2,<BR>Campo3<BR>FROM Tabla<BR>JOIN Tabla2 t2 ON t2.Campo1 <IGUAL> Tabla.Campo1<BR>
From this point it becomes way easier to transform the new ESP files to the old sintaxis.
Feel free to test it on:
http://regexr.com
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment