World: r3wp
[Parse] Discussion of PARSE dialect
older | first |
BrianH 20-Dec-2011 [6075] | Updated, Henrik. |
Henrik 20-Dec-2011 [6076] | Thanks. |
Endo 20-Dec-2011 [6077] | Thanks BrianH |
BrianH 20-Dec-2011 [6078x2] | Note that that was a first-round mockup of the R3 version, Endo. If you want to make an R2 version, download the latest script and edit it similarly. |
Have you looked into the native type formatting of bcp? It might be easier to make a more precise data file that way. | |
Endo 20-Dec-2011 [6080x2] | It uses a format file, it is very strict, but no chance to set a quote char for fields. |
Native formats runs well if you export from one SQL server and import from other. | |
BrianH 20-Dec-2011 [6082] | I figure it might be worth it (for me at some point) to do some test exports in native format in order to reverse-engineer the format, then write some code to generate that format ourselves. I have to do a lot of work with SQL Server, so it seems inevitable that such a tool will be useful at some point, or at least the knowledge gained in the process of writing it. |
Endo 20-Dec-2011 [6083x2] | The biggest problem would be the different datatypes for different versions of SQL Server, if there is no good documentation for the native format. But BCP does the job quite well. I CALL it when necessary and try to FIND if any error output. There is XML format files as well, easier to understand but no functional differencies betwenn non-XML format files. |
I'm working with SQL Server for a long time, if anything I can help or test for you, feel free to ask if you need. | |
Endo 5-Jan-2012 [6085] | Any one knows how do I find rebolek's R2E2 - REBOL Regular Expressions Engine. This link is dead I think http://bolek.techno.cz/reb/regex.r I saw it on http://www.rebol.org/documentation.r?script=regset.r |
Rebolek 5-Jan-2012 [6086] | Endo, I will try to find newest version and let you know. But do not expect it to translate every regular expession. |
Endo 5-Jan-2012 [6087:last] | Thank you, I don't need an exact regexp library, but would be nice to have some regexp functionality. |
older | first |