GitHub user ossDataEngineer added a comment to the discussion: Truncate data as per field size using Select values
@liosc, @dmainou, @hansva, @bamaer - I noticed one behaviour with "String cuts" transform - it does not take NewLines into consideration when cutting strings to confine to Oracle VARCHAR2(4000) limit. Hop's formula -> LEN([short_string_after_string_cut]) suggests that it is 4000, but when ingesting these strings to Oracle it complains with ORA-12899 "Value to large for column". Data inspection in notepad editors suggest that data after string cut is bigger than 4000. Can you help on how to perform string cut treating newlines as characters? GitHub link: https://github.com/apache/hop/discussions/5467#discussioncomment-15079788 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
