Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text?-CodePudding

Home > other > Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text?

Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text?

Time：12-07

I am writing a T-SQL function that returns an account number from a block of text. The text is generated by the system, and has 3 colons so I need to try to find a way to use SUBSTR() on the row containing "Account:" and not just the colon itself:

Amount: $10.00

Date: 12/5/2022

Account: Mr. John Doe 83850

What would be the cleanest way to select only the line containing the account number to my function for parsing into an integer?

CodePudding user response：

I'll probably mess this up on my phone but something like this should help:

SUBSTRING(TEXT,(PATINDEX('


          
          
            Page link：https//www.codepudding.com/other/634381.html
          
          
               Prev:System.AccessViolationException Visual Studio
               Next:How to concat strings in rows groupby column and index in dataframe?


  
    
      
        
          
             Tags：  
tsqlsubstr               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


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