Re: Change the Delimiters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Of course, I should add that in my previous post, by 'text editor
search/replace', I was referring to doing this manually unless you have a
text editor that supports regular expression search and replace.

If you are interested, I can email you offline a Perl script that uses
recursive descent parsing to find all the delimiters in most general case.
The script can be easily modified to do the kind of replacement you want.

Again, if you are lucky that don't need to deal with any embedded double
quotation marks, you can write a much simpler script to look for pairs of
double quotation marks and do the replacement accordingly. This can be done
with a trivial regular expression.

Linchi

"Linchi Shea" <linchi_shea@xxxxxxxxxxx> wrote in message
news:%23sVEr2s0FHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
> John;
>
> Are you asking whether there is a tool to change the double quotation mark
> delimiters used in a T-SQL script to the square bracket delimiters?
>
> I'm not aware of any native SQL Server client tool for doing this. If I
> were to do it, I'd just write a script to parse the T-SQL text and do the
> replacement. Now, in its most general case, the problem may not be as
> straightforward as it may appear. Consider the case where you have double
> quotation marks embedded in a string constant and the case where you have
> double quotation marks embedded in a delimited identifier.
>
> But your particular situation could be very straightforward without any of
> the annoying cases mentioned above, and thus a simple text editor
> search/replace may suffice.
>
> Linchi
>
> "John Smith" <john9877798@xxxxxxxxxxx> wrote in message
> news:lVC4f.5075$ns3.172063@xxxxxxxxxxxxxxxxxxxxxxxx
>> Does anyone know how to change the delimiters on SQL Server 2000 SP4
>> Client software?
>>
>> From " " to [ ] ?
>>
>> For example:
>>
>> "dbo"."myTable"
>>
>> to
>>
>> [dbo].[mytable]
>>
>> Running the Client tools on Windows XP.
>>
>> John
>>
>
>


.

Relevant Pages

  • Re: Single or double " quotes?
    ... string literal delimiters. ... That would mean ending all human communication. ... They were introduced on mechanical typewriters, than transferred to early character codes on computers, lumping together opening and closing quotation marks and several other characters, even intending the quotes play, via overprinting, dual roles as diacritic marks. ...
    (comp.lang.javascript)
  • Re: Exporting from Calendar to a CSV file
    ... here's a script that will save the data to a tab delimited text file ... set {oldTIDS, AppleScript's text item delimiters} to ¬ ... {AppleScript's text item delimiters, {", "}} ... set eventData to {mysub:subject, myST:start time, myET:end time, ...
    (microsoft.public.mac.office.entourage)
  • Re: How to just grab email addresses?
    ... To get ONLY the default email address, you'd have to do it by script: ... set theContacts to ... set end of eAddresses to default email address of theContact ... set AppleScript's text item delimiters to ...
    (microsoft.public.mac.office.entourage)
  • Re: Creating an Array in KSH from output
    ... I'm aware of the quotation marks and have used them in my php script that returns a piece of data with "white space" in it. ... the secondary question is, why does it work when hard coding it in the statement but won't work when using the variable? ... Can anyone with ksh93 say if this is an issue with ksh93 as well? ...
    (comp.unix.shell)
  • Re: missing ) after argument list
    ... > W3 document: HTML comments have the following syntax: ... `script' element's content, however, is CDATA in HTML. ... that resembles delimiters of a _markup_ language. ... if the content was declared CDATA using the respective XML declaration as ...
    (comp.lang.javascript)