Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Junk Characters validations - Data Window Field

  1. How-to
0
Votes
Undo
  1. Narayanamoorthy Thangavel
    Narayanamoorthy Thangavel
  2. PowerBuilder
  3. Wednesday, 14 August 2024 12:24 PM UTC

Hi,

 

Can we able to set junk character validation in data window filed? Because whenever customer copy and paste the text from some other forms or PDF to PowerBuilder data window it can accept and save it but later it causes the problem to other interfaces when we are transferring the data to target system via xml. Its failed xml validation at target system. So to avoid this issue we need set junk character validation for each field in particular data window screen in PowerBuilder.

If possible can any one let me how to set and all.  Attached sample junk character which was in bold.

 

 

Br,

Moorthy

  1. PowerBuilder (Appeon)
Title color
Getting the filter expression from a datawindow
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 14 August 2024 12:52 PM UTC
  2. PowerBuilder
  3. # 1

Hi Moorthy;

  Are looking for more than the standard EditMask or Validation Rule features can provide?

Regards ... Chris 

Comment
Load more comments
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Wednesday, 14 August 2024 14:47 PM UTC
I would have though that you could do this with the Match() Function within the DW Validation. You can check that it has Values A-Z, 0-9 and any other characters that are allowed. Certainly developing a global function to put in the DW validation would allow you to check each character for values that you will accept.
  1. Helpful
Narayanamoorthy Thangavel
  1. Narayanamoorthy Thangavel
  2. Wednesday, 14 August 2024 18:14 PM UTC
Hi,



Let me try this and would accept only varchar datatype(numbers.characters,special characters) values not other junk values.
  1. Helpful
Narayanamoorthy Thangavel
  1. Narayanamoorthy Thangavel
  2. Wednesday, 14 August 2024 18:15 PM UTC
If the user enter other than this values then window should not allow to save the values in the particular data window.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.