Get first character - xpandedreportsdocs

Join Our Discussion

Join the Discussion

Recent site activity

Memorized Reports
edited by Bonnie Nagayama
attachment from Bonnie Nagayama
Percentage Display
edited by Bonnie Nagayama
Excel Comparison
edited by Bonnie Nagayama
Known issues
edited by Bonnie Nagayama
Excel Comparison
edited by Bonnie Nagayama
View All

Computed Columns‎ > ‎Tips and Tricks‎ > ‎

Get first character

Get the first character of a text column.

SUBSTRING([Type],1,1)

Example
Input: Sales
Output: S

Sign in | Recent Site Activity | Terms | Report Abuse | Print page | Powered by Google Sites