Hi,
i have an alpha field with numeric values and i want to change it to integer. I searched inside the forum and found nothing that fits.
Regards

Christian

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

A good starting point, before appealing for assistance, is a Google search.

Try "webfocus function alpha to numeric"

Christian, EDIT does a straight cast betweenalpha and integer

Hi Christian,

Here is the code:

DEFINE FILE XXXXXXX
DEF_FIELD1/D12.2=ATODBL(source_string, length, output)
END

TABLE FILE XXXXXXX
SUM
DEF_FIELD1/I10
BY PERSON_ID
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

The above procedure would change your alpha field to Double-Precision Format (in define statement)
and then while summation /I10 would change the format from double to integer.

I hope this is what you're trying to accomplish!

This message has been edited. Last edited by: Venkat-,

Christian,

What is the format of the alpha field ?

Some of the suggestions above will work, but depends on the content.

Hi Waz,

i took Venkat-,s proposal. Works good for me!!

Regards

Christian

Christian, You could just do this in a DEFINE...
I_AFIELDNAME/I9 = EDIT(AFIELDNAME);
where AFIELDNAME is A9

quote:

i took Venkat-,s proposal. Works good for me

I assume that your alpha number wasnot formatted.