Hi, I need to convert 2 lines of data to one.
This is the data I can extract from the data base: FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata2,Flexibledata3,Flexibledata4,Flexibledata5,Flexibled ata6,Flexibledata7,Neededdata2,Neededdata3,Flexibledata8 This is the data I want to use in a comma separated from: Neededdata1,Neededdata2,Neededdata3 How can I strip off the FIXEDdata and the Flexibledata so I only keep the Neededdata? There is always multiple double lines of data with some single lines, like: FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata2,Flexibledata3,Flexibledata4,Flexibledata5,Flexibled ata6,Flexibledata7,Neededdata2,Neededdata3,Flexibledata8 FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata2,Flexibledata3,Flexibledata4,Flexibledata5,Flexibled ata6,Flexibledata7,Neededdata2,Neededdata3,Flexibledata8 FIXEDdata1,Flexibledata1,Neededdata1 FIXEDdata1,Flexibledata2,Flexibledata3,Flexibledata4,Flexibledata5,Flexibled ata6,Flexibledata7,Neededdata2,Neededdata3,Flexibledata8 ......... where do I start? Bernhard L�der This electronic mail is solely for the use of the addressee and may contain information that is confidential or privileged. If you receive this electronic mail in error, please delete it from your system immediately and notify the sender by electronic mail. -- SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
