Is there a possibility to increase the maximum string length while importing a csv.
Changing the limit is currently not possible. You can use a workaround:
- Exclude the column with very long text values from the “Import from delimited text file” action (but load all other necessary columns)
- In a separate table, use the “Import plain text” action to load the file as plain text. The action has no limit on text length
- Use text functions to extract the long values from the plain text and put them in a new column
- Append the new column with long text values to the main dataset using the “Append table” action in the “Append columns” mode. It should be sufficient because both tables should have the same number of rows.
Will try that, thx!