XLSX file column ETL error

Importing a XLSX file, one of the columns is > 32,676 varchar allowed in my Oracle table.
Trying to Trim or just insert NULL if row column has too many characters.
Mapping section of VI editor for that column, 'If Error' = 'Set to Null' not working, can not get that one row to load and have VI ignore the problem column.

What is field type in oracle? 

We had to expand to Varchar2 Max (32762 Byte). Tying to either append Null, or just trim.

The best way to tackle it is to use calculation.  We will provide an example later. 

Here is an example

Copy([FIELDNAME],1,10)