Calculated field in report builder to print first word of field

Yahoo Archive
1
Try this: " substring(PartDescription,1,index(PartDescription,' '))"
It looks for the first space, then substrings the field from "1" through the
result of the "index".
HTH, Alan
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, October 22, 2002 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculated field in report builder to print first word
of field only


Does anyone know of an equation in Report Builder to make a calculated
field
print only the first work of a field, regardless of word lenth?

i.e. "Lilly Turbo" will be "Lilly", "NP Medical Valve" will be "NP"

Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
Does anyone know of an equation in Report Builder to make a calculated field
print only the first work of a field, regardless of word lenth?

i.e. "Lilly Turbo" will be "Lilly", "NP Medical Valve" will be "NP"
3
How about something like..

substring(Text,1,index(Text," "))

.. should return all up to the first blank.

-Lonnie


--- In vantage@y..., sarah.vareschi@n... wrote:
> Does anyone know of an equation in Report Builder to make a
calculated field
> print only the first work of a field, regardless of word lenth?
>
> i.e. "Lilly Turbo" will be "Lilly", "NP Medical Valve" will be "NP"