Changing Case on Chart of Accounts Descriptions

Yahoo Archive
1
Hi Todd,
> From your suggestion though....
> Ctrl-C in Vantage
> Ctrl-V in a cell in Excel
> Adjacent cell refers to paste cell with Proper() function
> Copy the value in function cell (or have a thrid cell refer to the value
> only of the function cell)
> Ctrl-V in Vantage
>
> Significantly fewer steps and no single letter selection mouse action.

That would change it in Vantage. I was thinking of just running the =proper()
in your FRx Excel sheets. Just a thought...

Mark W.
2
I have been asked to see if there might be a fairly painless way to change our currently all CAPS descriptions on the Chart of Account to be normal form (first letter Caps, rest lower case). Apparently our CFO is finding all caps makes FRx reports hard to read and would rather change the chart of accounts than play with it in FRx (if FRx can even do that).

So a couple questions:
1. Any known impact from using a program to cosmetically change a field's value? Especially a description field that is part of an index? Does case matter in an index?

2. Assuming someone had the type of Progress tool required to write to the DB does said tool have a "Caps" or "LC" type function as well as a "Substring" type function? Or, with ODBC set to write could I use an Access query? Of course I would test this on a test database.

Worst case....a half dozen of us split up the chart and start re-typing but we were looking for something faster/easier.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
> I have been asked to see if there might be a fairly painless way to change
> our currently all CAPS descriptions on the Chart of Account to be normal
> form (first letter Caps, rest lower case). Apparently our CFO is finding
> all caps makes FRx reports hard to read and would rather change the chart of
> accounts than play with it in FRx (if FRx can even do that).

If you don't mind just changing until it hits Excel, you can use the =proper()
function to capitalize the first character of each word in a cell.

Mark W.
4
Good idea. I was playing around with Word and Shift-F3 as in:
Ctrl-C in Vantage
Ctrl-V in Word
Ctrl-A to select all
Shift-F3 (change case to all lower)
Select first letter and Shift-F3 to capitalize first letter (multiple Shift-F3 won't caps only first word)
Ctrl-A
Ctrl-X (cut)
In Vantage Ctrl-V

All this does is save typing and assure no typos worse than present but this sure is tedious still. I can type faster than I can do the above if the description is small.

From your suggestion though....
Ctrl-C in Vantage
Ctrl-V in a cell in Excel
Adjacent cell refers to paste cell with Proper() function
Copy the value in function cell (or have a thrid cell refer to the value only of the function cell)
Ctrl-V in Vantage

Significantly fewer steps and no single letter selection mouse action. Thanks,
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Mark Wonsil
Sent: Wednesday, April 12, 2006 7:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Changing Case on Chart of Accounts Descriptions


> I have been asked to see if there might be a fairly painless way to change
> our currently all CAPS descriptions on the Chart of Account to be normal
> form (first letter Caps, rest lower case). Apparently our CFO is finding
> all caps makes FRx reports hard to read and would rather change the chart of
> accounts than play with it in FRx (if FRx can even do that).

If you don't mind just changing until it hits Excel, you can use the =proper()
function to capitalize the first character of each word in a cell.

Mark W.



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



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]