Google Query Trim string data-CodePudding

Home > Blockchain > Google Query Trim string data

Google Query Trim string data

Time：04-05

I am using the following data:

cat1-001A
cat1-001B
cat1-001C
dog2-001A
etc.

the query I used is

=query(sheet1!A1:A,"select A where A is like '


          
          
            Page link：https//www.codepudding.com/Blockchain/361014.html
          
          
               Prev:Regex: matching for digits excluding some digits at a position
               Next:How do I use RegExp to test a valid String of Roman Numeral in Dart?


  
    
      
        
          
             Tags：  
regex google-sheets spreadsheet google-query-language               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding