1. 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

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
  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
  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
  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.