Splitting a row into multiple rows based on length of a field

 In the process of providing data exports for a data load from Vantive to Oracle on Demand our implementation partners have informed us that the largest text datatype is 1999 characters.  We have not fields attached to records in one database that frequently exceed this limit.  Is it possible to split a row into multiple rows based on the length of the field in the row.  For example, I have a record that has the following:

Note Id, Note Subject, Note Creator, and Note. 

If the Note > 1999 characters, I need to create a second (and third, and so on) row with each row containing the as much of the note as possible. With each additional row created, I will need to create a new row id with Note Subject and Note Creator staying the same.  In the second row, the Note field would start with character 2000 and continue to 3999 or until complete.  This would continue until the entire note has been accounted for.