Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Vinod
		
			Vinod
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All,
How to remove zero's after GR008JP02A and keep the last numbers.
Thanks,
Vinod
 Jacek
		
			Jacek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 Jacek
		
			Jacek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=left( [Branch Code], 10) & Num( right( [Branch Code], 5))
 Vinod
		
			Vinod
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Particularly for this Code-GR008JP02A , I wan't the result. and Upper Expression is not working also.
 Jacek
		
			Jacek
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		