Hi Friends.
Instead of Print command, by using String.So that we can get each and every row one time in either CSV/HTML/XML output format.
Example:
Print $Name(,)
Print $Name (,)
Print $Address2(,)
Print $State (,)
Print $Country(,) /* Use Strings here to remove multiple duplicate rows of data*/
STRING $Name $Address1 $Address2 $State $Country BY ',' INTO $ST1
STRING $N ,............................................................ BY ',' INTO $ST2
STRING $ST1 $ST2 BY ',' INTO $ST3
PRINT $ST3 (+1,1)
Regards,
Mahendra
| Title | Under | Posted on |
|---|---|---|
| how to send hyperlink with email in application engine program. | PeopleSoft Technical | 06/13/2013 - 12:55am |
| Saving records | PeopleSoft Technical | 06/04/2013 - 11:11am |
| can we alter a trigger in DB2 to add a new column | SQL & PL/SQL | 05/29/2013 - 1:31am |
| Required Peoplesoft HRMS Functional Training | PeopleSoft Functional | 05/07/2013 - 10:29pm |
Recent comments
2 weeks 4 hours ago
7 weeks 14 hours ago
7 weeks 6 days ago
7 weeks 6 days ago
8 weeks 2 hours ago
8 weeks 1 day ago
8 weeks 1 day ago
9 weeks 3 hours ago
9 weeks 2 days ago
9 weeks 4 days ago