> I did try both of your suggestions, but RS threw the following error in
> both cases:
>
> "lookbehind assertion is not fixed length"
>
> Any idea what that means?
Ah yeah, that's an annoying restriction many regex implementations
have - they don't allow the lookbehind to match a variable length of
characters (or some allow variable length, but must have a maximum
length).
I did "(?<=CREATE\s+TABLE\s+)" to allow for multiple spaces and/or
tabs, newlines, etc at where the "\s+" appear there.
The simple fix is to change "\s+" to just " " (space), but that of
course only matches a single space (might be good enough, depending on
input text).
You could also try "\s{1,99}" to allow upto 99 whitespace characters,
but I suspect the message would have said "maximum length" instead of
"fixed length" if that were allowed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/regex/message.cfm/messageid:1249
Subscription: http://www.houseoffusion.com/groups/regex/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/regex/unsubscribe.cfm
