# Linedelimiters in files included by sqlFile

**URL:** <https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353>\
**Category:** General Discussion\
**Created:** [November 15, 2009, 3:53pm UTC](https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353 "2009-11-15T15:53:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sigmundl](https://avatars.discourse-cdn.com/v4/letter/s/90ced4/32.png) [@sigmundl](https://forum.liquibase.org/u/sigmundl)\
**Post date:** [November 15, 2009, 3:53pm UTC](https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353/1 "2009-11-15T15:53:00Z")

</div>

I have insert statements containing a field storing css stylesheets; thus lots of ; characters in it.  
I have&nbsp; tried to use the endDelimter attribute on the sqlFile tag using various characters, but no success yet.

Liquibase 1.95

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [November 15, 2009, 3:53pm UTC](https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353/2 "2009-11-15T15:53:00Z")

</div>

That should work.&nbsp; Does it help to use a single char delimiter like “” ?&nbsp; or to put the delimiter on the end of a line, not on it’s own line?&nbsp; I don’t remember the regexp we use to split on the end delimiter off hand.

Nathan

---

<div class="post-metadata">

**Author:** ![sigmundl](https://avatars.discourse-cdn.com/v4/letter/s/90ced4/32.png) [@sigmundl](https://forum.liquibase.org/u/sigmundl)\
**Post date:** [November 15, 2009, 3:53pm UTC](https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353/3 "2009-11-15T15:53:00Z")

</div>

MySQL didn’t accept the GO syntax, I found no other solution than writing a groovy script  
transforming the file into a liquibase changeset

/S

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [November 15, 2009, 3:53pm UTC](https://forum.liquibase.org/t/linedelimiters-in-files-included-by-sqlfile/353/4 "2009-11-15T15:53:00Z")

</div>

the database itself shouldn’t even see the delimitar you are using. &nbsp;We use it to do a String.split() on. I’ll see if I can replicate your problem.

I’m glad you found a work around. &nbsp;Any chance the groovy script would be in a state that it could be added to the extensions portal: [http://liquibase.org/extensions](http://liquibase.org/extensions) ? &nbsp; I’m sure it would be very helpful to others as well.

Nathan