I would place this in the "ugly hack" category, but you could just write your upc into a variable on the first iteration of the PO1 & compare it with the upc in the second iteration. If it's equal, you have one of the dupe lines you don't want and you can process it accordingly. If it's not equal, copy it's upc to the variable for the next line to test against.
Travis- -----Original Message----- From: Steven Bell [mailto:[EMAIL PROTECTED] Sent: Friday, April 06, 2007 12:19 PM To: [email protected] Subject: [EDI-L] SDQ Orders and repeating PO1 Segment We have a customer that sends in the SDQ segments for each distibution center. With that there is a duplicate PO1 segment written out with the same data (UPC). Our internal system can not handle duplicate UPCs on the same order. Is there a to write out the first PO1 and not write out the second and third PO1 segments if they repeat the same UPCs? If any one wants to contact me directly please do so. I have an example of the data if this scenario was not clear... Thanks, Steve ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
