Regex for DDL

> 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.