[CLOSED] Convert blank to zero

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/235101924

April 27, 2010, 01:03 PM

ktnj

[CLOSED] Convert blank to zero

Hello all,

I have an A10 field and I want to convert all the spaces in the field to 0's. What is the simplest method??

Thanks!

This message has been edited. Last edited by: Kerry,

April 27, 2010, 01:33 PM

GinnyJakes

CTRAN is one function that can be used.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

April 27, 2010, 06:16 PM

Waz

STRREP will also do the job.

Do your self a favour and check out the documentation on functions.

Using Functions

Also can you update your signature.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!