work around 1024 character limit for text fields

6 posts / 0 new
Last post
Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37
work around 1024 character limit for text fields

Hi, 
is there a way to work around the 1024 character limit during the import?
For example split the field with more than 1024 characters into two or mor fields.
 
Background:
I have to import Log-Files and some fields are definitive longer than 1024 characters.
Due to the amount of files I'm not able to split them manually.
 
Thx in advance
Norbert

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Currently you would have to do this with a script.  The script could check the size of the field and then split it up if needed.  You might make a feature request to CaseWare to increase the size of the character field.

Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37

Brian, thank you for your Answer.
Can I solve it with one of your scripts for example the multi file import?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Unfortunatley no but I could probably create a demo.  What format are you using?

Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37

It is in UTF-8, if its that what you are meaning.

Norbert_L's picture
Norbert_L
Offline
Joined: 09/03/2014 - 10:37

The File is using space as seperator and " as encapsulator