Limit characters from a record

Hello!

I'm using Chronoconnectivity to retrieve information from a text area field, but I only want to display a portion of the text in a custom view, is there any way I can limit the characters I'm retrieving from the record, like only the first 50 characters?

I really hope you can help me!

Thanks

Hi nams09,

Have you tried setting the column as SUBSTR(column_name, 0, 50) ?

Bob

Thanks for the quick reply!

But where would that go? In the "fields" box?

You can try that in the "fields" box, but I'm not sure if the fields parsing code will be able to handle it, you can try to trim the string using php code in the view instead:

substr($row["Model"]["field_name"]0, 50);

Regards,
Max