Number of characters in a string?(urgent)

[susan]

Hi all,

If a have a string of length 20.
And if i want to count no.of characters in it?
which is the easiest approch?

Thnks,
Susan.

[jamief]

Re: Number of characters in a string?(urgent)

mystringlength = %len(%trim(myfieldof20));

[susan]

Re: Number of characters in a string?(urgent)

Jamief,

I too approached in the same way,
but when my String contains "abc def ghi"(i mean spaces between letters),how can i achieve it??

[bryce4president]

Re: Number of characters in a string?(urgent)

You don't want to count the spaces as characters?

If this is the case then do a %xlate to remove the strings and then continue as Jamie suggested...

I'll double check the %xlate for an example....brb.

[bryce4president]

Re: Number of characters in a string?(urgent)

I believe this would work...

mystringlength = %len(%trim(%xlate(' ' : '' : myfieldof20)));

If not, something verrry similar... you could probably use %replace as well.


P.S. This is untested...

[jamief]

Re: Number of characters in a string?(urgent)

well ya didnt say ignore the spaces

d fnd             s              3  0                                    
d string          s             22    inz('Special Care Assistant')      
 *                                                                       
 *                                                                       
 /free                                                                   
                                                                         
       dou fnd = %len(string);                                           
       fnd = %scan(' ' : string:fnd+1);                                  
       STRING = %replace('' : string:fnd:1);                             
       enddo;                                                            
       dsply string ' ' ;                                                
                                                                         
      *inlr = *on;                                                       
                                                                         
 /end-free

[mjhaston]

Re: Number of characters in a string?(urgent)

Is there a way to move any posts with "urgent" in them to the bottom of the list? just kidding of course!

[Marc_d]

Re: Number of characters in a string?(urgent)

I Know for sure Birgitta has some SQL ?

= the number of chars in a string without spaces !

I think you can do it with: LEN and TRANSLATE !

[susan]

Re: Number of characters in a string?(urgent)

well ya didnt say ignore the spaces

d fnd             s              3  0                                    
d string          s             22    inz('Special Care Assistant')      
 *                                                                       
 *                                                                       
 /free                                                                   
                                                                         
       dou fnd = %len(string);                                           
       fnd = %scan(' ' : string:fnd+1);                                  
       STRING = %replace('' : string:fnd:1);                             
       enddo;                                                            
       dsply string ' ' ;                                                
                                                                         
      *inlr = *on;                                                       
                                                                         
 /end-free

This doesnt work.....
Is there a way to replace only one character??

[mjhaston]

Re: Number of characters in a string?(urgent)

I think Jamie's does the same thing as mine, but here's another snippet ...

http://www.code400.com/forum/showpost.php?p=33066&postcount=6

[B.Hauser]

Re: Number of characters in a string?(urgent)

I Know for sure Birgitta has some SQL ?

Sure I have

Exec SQL  Set :MyLength = Length(Trim(Replace(:MyText, ' ', ''))); 

Birgitta