how to get the actual length of the data

, ,
1

Hi,

On existing map/screen, there is a field/column Email ID which is 50 characters in length get populated from one of the adabase file having filed datatype A50. If the actual data stored in the DB file is just for example only 25characters then how do I get the lenght of actual stored data.
Is there any system function/variable which will give actual data stored in DB file?

Thanks & Regards
MP

2

Assuming embedded blanks are not valid, an EXAMINE emailid for first ’ ’ giving position #position would suffice.

3

Thank you Steve Robinson for your response.

Just I have used the EXAMINE #EMAIL-ID FOR ’ ’ DELETE GIVING LENGTH #EMAIL-LEN.

and I got the desired output.

Once again thank you a lot.

Regards
Murthy

4

A more generic solution is

EXAMINE #EMAIL-ID FOR PATTERN '.' GIVING LENGTH #EMAIL-LEN