Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Converting Txt to table

    Dears,

    hopfuly to find some help in here, i need to convert a txt file as below;

    HTML Code:
    NESTING REPORT OF
    TASK NAME : PL6
    
    STOCK               STOCK  #1           STOCK  #2           STOCK  #3           
    QTY                 1                   1                   1                   
    
    STOCK SIZE          2000.00x8000.00     2000.00x8000.00     2000.00x8000.00     
    ENCLOSING RECT      1999.82x7990.00     2000.00x7960.00     1969.78x6000.00     
    
    ENCLOSING RECT/     15978561.80/        15920000.00/        11818680.00/        
    STOCK AREA          16000000.00         16000000.00         16000000.00         
                        99.87%              99.50%              73.87%              
    
    TOTAL PART AREA     15662094.00/        15517860.00/        10976400.00/        
    ENCLOSING RECT      15978561.80         15920000.00         11818680.00         
                        98.02%              97.47%              92.87%              
    
    TOTAL PART          
    PERIMETER           188358.49           305190.49           49702.49            
    
    PART NAME           
    CL1-2-CL1-2(44)     44/44               0/44                0/44                
    CL1-3-CL1-3(27)     27/27               0/27                0/27                
    CL1-7-CL1-2(6)      6/6                 0/6                 0/6                 
    CL1-8-CL1-8(10)     10/10               0/10                0/10                
    COL1-10-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-11-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-12-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-13-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-14-ST-2(2)     2/2                 0/2                 0/2                 
    ...
    ...
    to input it in to a table as in

    HTML Code:
    Profile	CSN	Qty	PL	   Part Name	Part Qty
    PL6	1	1	2000.00x8000.00	CL1-2-CL1-2	44
    PL6	1	1	2000.00x8000.00	CL1-3-CL1-3	27
    PL6	2	1	2000.00x8000.00	RF1-1-CL-1A	28
    PL6	2	1	2000.00x8000.00	RF1-12-CL-1A	8
    PL6	3	1	2000.00x8000.00	RF1-1-CL-1A	36
    thank you for the support on this issue, it's going the save me time. A LOT of time indeed.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Could you please provide the rules explaining which data from the text file must be inserted into the table? It's going the save us a lot of time too.
    Have a nice day!

  3. #3
    Join Date
    May 2012
    Posts
    2
    Thanks for the response,
    the first thing is that the source file will be repeated for many times as per below i include only up to STOCK #6
    for how it supposed to be arranged in the table I attached a jpg file hope it will be clear for you.
    HTML Code:
    [SIZE="1"]
    NESTING REPORT OF
    TASK NAME : PL6
    
    STOCK               STOCK  #1           STOCK  #2           STOCK  #3           
    QTY                 1                   1                   1                   
    
    STOCK SIZE          2000.00x8000.00     2000.00x8000.00     2000.00x8000.00     
    ENCLOSING RECT      1999.82x7990.00     2000.00x7960.00     1969.78x6000.00     
    
    ENCLOSING RECT/     15978561.80/        15920000.00/        11818680.00/        
    STOCK AREA          16000000.00         16000000.00         16000000.00         
                        99.87%              99.50%              73.87%              
    
    TOTAL PART AREA     15662094.00/        15517860.00/        10976400.00/        
    ENCLOSING RECT      15978561.80         15920000.00         11818680.00         
                        98.02%              97.47%              92.87%              
    
    TOTAL PART          
    PERIMETER           188358.49           305190.49           49702.49            
    
    PART NAME           
    CL1-2-CL1-2(44)     44/44               0/44                0/44                
    CL1-3-CL1-3(27)     27/27               0/27                0/27                
    CL1-7-CL1-2(6)      6/6                 0/6                 0/6                 
    CL1-8-CL1-8(10)     10/10               0/10                0/10                
    COL1-10-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-11-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-12-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-13-ST-2(2)     2/2                 0/2                 0/2                 
    COL1-14-ST-2(2)     2/2                 0/2                 0/2                 
    
    
    SUB TOTAL           290/1306            934/1306            39/1306             
    
    
    STOCK               STOCK  #4           STOCK  #5           STOCK  #6           
    QTY                 1                   1                   1                   
    
    STOCK SIZE          2000.00x8000.00     2000.00x8000.00     2000.00x8000.00     
    ENCLOSING RECT      1950.00x6000.00     1987.75x7235.73     1900.00x7507.00     
    
    ENCLOSING RECT/     11700000.00/        14382822.31/        14263300.00/        
    STOCK AREA          16000000.00         16000000.00         16000000.00         
                        73.13%              89.89%              89.15%              
    
    TOTAL PART AREA     10800000.00/        8975825.00/         11193825.00/        
    ENCLOSING RECT      11700000.00         14382822.31         14263300.00         
                        92.31%              62.41%              78.48%              
    
    TOTAL PART          
    PERIMETER           39622.49            32814.94            41935.95            
    
    PART NAME           
    CL1-2-CL1-2(44)     0/44                0/44                0/44                
    CL1-3-CL1-3(27)     0/27                0/27                0/27                
    CL1-7-CL1-2(6)      0/6                 0/6                 0/6                 
    CL1-8-CL1-8(10)     0/10                0/10                0/10                
    COL1-10-ST-2(2)     0/2                 0/2                 0/2                 
    COL1-11-ST-2(2)     0/2                 0/2                 0/2                 
    COL1-12-ST-2(2)     0/2                 0/2                 0/2                 
    COL1-13-ST-2(2)     0/2                 0/2                 0/2                 
    COL1-14-ST-2(2)     0/2                 0/2                 0/2                 
    
    
    SUB TOTAL           3/1306              3/1306              5/1306                         
    
    
    NESTING SUMMARY
    
    PART NAME           BASIC QTY           FILLER QTY          PART AREA           
    CL1-2-CL1-2(44)     44/44               -                   28560.00            
    CL1-3-CL1-3(27)     27/27               -                   28480.00            
    CL1-7-CL1-2(6)      6/6                 -                   31680.00            
    CL1-8-CL1-8(10)     10/10               -                   27840.00            
    COL1-10-ST-2(2)     2/2                 -                   19367.00            
    COL1-11-ST-2(2)     2/2                 -                   19367.00            
    COL1-12-ST-2(2)     2/2                 -                   19367.00            
    COL1-13-ST-2(2)     2/2                 -                   19367.00            
    COL1-14-ST-2(2)     2/2                 -                   19367.00            
    
    TOTAL PARTS NESTED  1306/1306           -                   
    
    STOCK               TOTAL               
    2000.00x8000.00     13
    
    TOTAL               13[/SIZE]
    Attached Thumbnails Attached Thumbnails 1.JPG  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •