Search For Spefic character in a string & Password Encryption

[srikanthkotha]

Hi All,
1.Could you please let me know how to find a character in a string in Progress 4GL?
I have email id screen field where user enters email id, I need to validate the same by searching for '@' and .com in the given input. Please let me know any built in function exists to find a char/string in a string.

2. I have password field, when user enters some value it should be converted like "****".I am handling this scenario, when submit button is clicked I am moving "*****" to this field and displaying on screen. Could you pls let me know how to handle this before pressing submit button itself.

Thanks & Regards
Srikanth

 

[TomBascom]

INDEX function
Returns an INTEGER value that indicates the position of the target string within the source string.
Syntax

INDEX ( source , target [ , starting ] )​

source
A CHARACTER or LONGCHAR expression.
target
A CHARACTER or LONGCHAR expression whose position you want to locate in source. If target does not exist within source, INDEX returns a 0.
starting
An integer that specifies at which left-most position in the string to start the search. For example, INDEX("abcdefabcdef","abc",6) returns 7.

 

[TomBascom]

PASSWORD-FIELD attribute
Displays password data in a field as a series of fill characters.
Data type:
LOGICAL
Access:
Readable/Writeable
Applies to:
FILL-IN widget
If TRUE, the current value of a fill-in field or any character value typed into the fill-in field is displayed as a series of fill characters. The default value is FALSE.
In Windows GUI platforms, the default fill character is the asterisk (*). On non-Windows GUI or character platforms, the default fill character is a blank.​

 

[TomBascom]

You might want to spend a bit of quality time with the documentation. If you are running windows the "?" icon in your Progress or OpenEdge program group is a good place to start. Or you can get all the docs online at http://communities.progress.com/pcom/docs/DOC-16074

 

[Rob Fitzpatrick]

Hi All,
1.Could you please let me know how to find a character in a string in Progress 4GL?
I have email id screen field where user enters email id, I need to validate the same by searching for '@' and .com in the given input.

Are you assured that the e-mail addresses being validated will only use the "com" top-level domain?

 

[srikanthkotha]

TomBascom, Thank you for your reply. Post was really helpful to me.