
	Home > Ask the AS/400 Experts > iSeries Application Development Questions & Answers > Removing a comma from an alpha field

Ask The iSeries 400 Expert: Questions & Answers

EMAIL THIS

Removing a comma from an alpha field

EXPERT RESPONSE FROM: John Blenkinsop

		Pose a Question

		Other iSeries 400 Categories

		Meet all iSeries 400 Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 23 November 2004
Is there a built in function available that allows me to remove a comma from an alpha field so I can move the field value to a numeric field. For example, the alpha field is 10 characters long and has a value of 1,000,000. I need it to look like this: 1000000. Any suggestions would be greatly appreciated.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	iSeries ILE programming
	Tracking data changes on IBM i with triggers
	Introduction to SQLRPGLE on IBM i: Making a report
	How to use an embedded SQL statement and display the result in a subfile
	Eight steps for creating program documentation using AS/400 utilities
	Searching fields for values
	Searching part of a name or address in AS/400
	Top 10 programmer tips YTD
	How to use the binder language to manage service programs -- Part 3: Examples and pitfalls
	Top 10 programmer tips of 2005
	How to use the binder language to manage service programs -- Part 2: Understanding the binder language

RPG iSeries programming

Enhancing RPG with external SQL stored procedures

Introduction to SQLRPGLE on IBM i: Making a report

Making the most of RPG data handling on IBM i

IBM i shop boosts online sales with RPG-based Web platform

Migrating from RPG to EGL on IBM i

Allow access to data from a stored procedure result set using COBOL or RPG

EGL Rich UI on IBM i: Do you Dojo?

Programming for the Web on the IBM i, what is possible

A taste of COMMON: ILE, IBM releases, Web applications and new products

Documenting nested program structures on the AS/400

iSeries COBOL programming

Implementing a browser interface in COBOL: Displaying database fields

Implementing a browser interface in COBOL: Creating your graphic Web page

Implementing a browser interface in COBOL: Getting started

Allow access to data from a stored procedure result set using COBOL or RPG

Eight steps for creating program documentation using AS/400 utilities

Coloring source lines with COBOL and using a shortcut from within PDM

Top 10 programmer tips YTD

Slow system performance

Changing the font size

New option within the WRKSYSACT command

iSeries COBOL programming Research

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

Report Program Generator (Search400.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Use the %DEC BIF with translation to convert the string to a packed number after converting the commas to blanks. The following example is from the WebSphere(R) Development Studio ILE RPG Reference at the IBM Web site and handles the currency symbol $ and the cheque protect symbol * as well as the thousands separator:

 
D data            s             20a   inz('$1,234,567.89')
D num             s             21p 9 

Eval  num = %dec(%xlate('$*,' : '   ' : data) : 21 : 9)

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Visit the ITKnowledge Exchange and get answers to your developing questions fast.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

iSeries Networking - Printing, Remote Access, TCP/IP

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy