DIVIDE AND CONQUER
 Memorize[?]: 
  [+]   ???   =>  
LATEST UPDATE: 3/8/2023, 11:55:45 AM

A List (Re-)Organizer and Content Extractor - double-click copies
-ready-
INPUT: LIST START-INDICATOR: (!!!-linebreaks matter-!!!) LIST DELIMTER: (!!!-linebreaks matter-!!!) LIST END-INDICATOR: (!!!-linebreaks matter-!!!) OUTPUT: SPREADSHEET:

SUBDIVISION-LINE PREP
-ready-

Add/Remove Line Numbers
 

    
  
  

DOCUMENTATION - sample extraction of data items from a list of emails to a spreadsheet

- Search and highlight all relevant emails
  (e.g. same subject line, items need to be of same structure)

   


- Use [File] menu to save [Save As] selected emails
  as text file.

   


- Open text-file and copy all content

   


- In D.A.C. tool (above), paste content into [INPUT] field

   


- Find and copy LIST-DELIMITING content item
  (here: "From: SeamlessDocs ")

   


- Paste input field content into SUBDIVISION-LINE PREP field
- IMPORTANT! THEN, REMOVE FIRST DELIMITING LINE!

    


- Click checkbox ADD/REMOVE LINE NUMBERS

   


- Search and collect relevant lines in the FIRST(!) item list segment
  Enter line numbers, comma-separated in the field below

   

- OPTION 1 - Complete Spreadsheet Extraction:
  + Double-Click SPREADSHEET output field and paste content into blank spreadsheet
    (clean-up required)

 


- OPTION 2 - Supplemental Spreadsheet Extraction:
  + Double-Click on requested, individual list item the SPREADSHEET COPY field
  + Paste as supplemental record into existing spreadsheet
  

- OPTION 3 - Individual Record Extraction:
  + Double-Click on requested, individual list item - individual data segment field
  + Paste as individual data segment into existing spreadsheet or destination.



 

    
  
  


 [+]

NanoWiki - A Duct-Tape Solution [H]