Forum Discussion
Conditional combine
I would like to combine rows based upon text in List records. E.g. All items should be combined by pipe delimiter, however when text is OPEN-O, these line items should be on new line as delimiter. Cu...
Hi,
Share some data to work with and show the expected result. Share datai in a format that can be pasted in an MS Excel file.
| MEL 3293550 EMK WAS OPENED AND USED | MEL 3294156 ATTENDANT CREW REST AIR IS TOO DRY | MEL 3295182 HUMIDITY CONTROL SYSTEM TEST FOUND FWD ZONAL DRYER HAS AN INTERNAL FAULT | DIP 9864630 PAINT PEELED FROM RIGHT WING ROOT AND SCRATCHED (3.00 I) | EA 0521-01000 OP10 GENX CUSHIONED LOOP CLAMP INSP *RIR* (22.00 L) | #2 RH DOOR SLIDE RPL *ACP RENDER SAFE CKLIST* (18.00 S) | B787-9 UMD SOFTWARE RESTORE (5.00 I) | OPEN-O 3297052 1L STUCK IN ACCESAB ILITY MODE (0|0|0|0) | OPEN-O 3303465 SCHED WORKLOAD IS ASSIGNED TO BE ACCOMPLISHED IN EWR ON 24DEC24. PERFORMING A MRD CHECK MAY BE REQUIRED TO INSURE NO OUTSTANDING WORKLOAD REMAINS, BEFORE CLEARING THIS LOGPAGE. IF WORKLOAD IS UNABLE TO BE COMPLETED, CONTACT PLANNING FOR RESCHEDULING (0|0|0|0) |
I cannot understand anything from the data that you have shared.