Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Text conversion: INITCAP
I'm having difficulty finding a download for PROPER(). I have downloaded one for LEADINGCAPS(). But it converts a string: (X) but the contents of the field is unknown to me. I need a function which will be used against a field. Sample syntax: INITCAP({fieldname}) Does PROPER() work this way...- sfarr
- Post #3
- Forum: Business Objects: Seagate Info
-
Text conversion: INITCAP
In my work, I have found the need to convert text string from uppercase to initial capitalization. Many other reporting tools or database extraction tools have a function known as INITCAP or Sentence Case. Does anyone have some advice for me regarding the conversion of text which has been...- sfarr
- Thread
- Replies: 3
- Forum: Business Objects: Seagate Info
-
PivotTables and dates
In Office 97, this was true with Excel pivottables (reformatting the date field to text to have column heading appear MMM-YY). Please note that in Office 2000 this is not the case.- sfarr
- Post #3
- Forum: Microsoft: Office
