How to overcome 254 character limit importing CSV or excel files 3

[linousa]

How to overcome 254 character limit importing CSV or excel files?
I have a table, I need import CSV with a few columns that are about 1000 characters long, maybe creating 4 fields for each, but how to split them?

 

[Chris Miller]

Wait,

isn't it a feature already as the csvprocessor creates a cursor or dbf with multiple fields for a csv column if values in the csv columns are longer than 254 chars?



Chriss

 

[atlopes]

isn't it a feature already as the csvprocessor creates a cursor or dbf with multiple fields for a csv column if values in the csv columns are longer than 254 chars?

Not quite. Columns larger than 254 characters are treated as memo fields. One column, one field. What the CSVProcessor does is create several cursors when there are more than 254 columns in the CSV source data.

 

[Chris Miller]

OK, then I misunderstood the feature to create cursors with several fields for one column.

Chriss