Truncating characters

User Help for GS-Base

Truncating characters

Postby tonto » Mon Sep 05, 2011 7:15 pm

I'm wanting to truncate words in a field to 10-15 letters from the left. I've tried making a new field (field4) and using a field property like =text(field2,10) to set the left most characters in field2 to the first 10 characters and place them in field4. This results in nothing. I've tried other methods but nothing seems to work. Any suggestions. Thanks!
tonto
 
Posts: 4
Joined: Mon Sep 05, 2011 7:06 pm

Re: Truncating characters

Postby citadel5 » Mon Sep 05, 2011 9:39 pm

This should be:
=left(field2, 10)

In general, the simplest method would be the following:
1. Right-click field2 (or some other field if you don't want to perform the conversion in-place) and choose "Field Properties".
2. Enter the formula.
3. Press F9 (= "Tools > Update All Calculated Fields").
4. Remove the formula (if you don't need it any longer).

To browse all available text formulas, in the "Field Properties" dialog click "Formulas >", then choose "Category > Text".
User avatar
citadel5
 
Posts: 112
Joined: Tue Apr 20, 2010 11:58 pm

Re: Truncating characters

Postby tonto » Tue Sep 06, 2011 2:24 am

Thanks, I was neglecting to update the fields. It works fine now.
tonto
 
Posts: 4
Joined: Mon Sep 05, 2011 7:06 pm


Return to GS-Base Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron