Peter Hudson Peter-Hudson

## RegEx
let testString = 'aaabbbbaa';
testString.match(/.+?(a+|b+|c+|d+|e+|f+|g+|h|i+|j+|k+|l+|m+|n+|o+|p+|q+|r+|s+|t+|u+|v+|w+|x+|y+|z+)/igm).map(c => c.length + c[1]).join('');

## updated bash?
. !$

## MySQL load infile CSV.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                Peter-Hudson
                / MySQL load infile CSV.md
            
            
              Last active
              September 30, 2015 11:19
            
              
                Testing the import of a CSV file into MySQL
              
          
        
      
        
  
      
    mysql -utest -p test --local-infile
CREATE TEMPORARY TABLE IF NOT EXISTS `tempy` (
    `tempy_id` INT(21) AUTO_INCREMENT,
    `tempy_value` INT(21) DEFAULT NULL,
    PRIMARY KEY (`tempy_id`)
)ENGINE = InnoDB;

LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE `tempy`
	let testString = 'aaabbbbaa';
	testString.match(/.+?(a+\|b+\|c+\|d+\|e+\|f+\|g+\|h\|i+\|j+\|k+\|l+\|m+\|n+\|o+\|p+\|q+\|r+\|s+\|t+\|u+\|v+\|w+\|x+\|y+\|z+)/igm).map(c => c.length + c[1]).join('');