LCWORD - Does it always work?

December 17, 2007, 08:29 AM

I have upper case text that I need to put into 'Proper' case. Looked into the function and found LCWORD. Excellent I thought. I will use that. Had a look at my extract (EXL2K) and it is doing something strange.

It is putting in extra characters and creating new words in my addresses. For example "Macclesfield CHESHIRE" changes to "Macclesfield Cheshirethtekr".

The field I am converting is set up as an A100V. Is there a limit or is it having an off day.

Regards

December 17, 2007, 08:37 AM

hammo1j

You need to assign to A100 first since the A100V has its data prefixed by a length and the result will be unpredictable since LCWORD is meant to work with fixed data.

Some of the subroutines have counterparts that are supposed to work with variable length strings - I am not sure about LCWORD.

Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo

December 17, 2007, 09:01 AM

thefoz

Thanks for that. I changed the format in the master file and removed the Variable and it has done the trick.

Cheers

December 17, 2007, 11:35 AM

Francis Mariani

This subject may be of interest to you: "Character Functions for AnV Fields". Look for it in the WebFOCUS Functions manual. There are "character functions created specifically for use with AnV fields", like LOCASV and UPCASV, but oddly enough, no Mixed Case function.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server