Search these areas:
Help
Support Forums
Product Info



-Introduction
-DataWeb: What's New
-Creating an Application
-The DataWeb Designer
-Application Management
-Data Tables
-Data Tables
-Views
-Templates
-Components
-Data Analysis
-Members
-Security
-Importing
-Exporting
-FTP
-JavaScript
-Object Model
-Full-Text Search
-Domain and Email Hosting
-HotBlock Modules
-Account Management
-Glossary
-New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

KnowledgeBase


How To: Display the first 20 characters of a text field
Article TypeHow To
TitleDisplay the first 20 characters of a text field
<i>"I have a longtext field in a data table. Lets say I input into this field a message containing 100 characters. In my default.view I would only like to show the first 20 (for example) characters. How do I do this?"</i><br>
<br>
Use a <a href="/default.view?Topic=views/vbasics">calculated field</a>:<br>
<br>
Select your field (named <b>DESCRIPTION</b>, for example) and click on the "zoom" icon next to the bound field property. Set the field to:<br>
<br>
<span class="smallCode">ShortDescription=SUBSTR(Description,1,20)</span>
Last ReviewedFebruary 20, 2015 14:09:09

  
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us