从特定字符和数字中提取文本从同一行提取时间， [英] Extract text from Specific Character and Number & Extract time from same line,

问题描述

从特定字符和数字中提取文本&从同一行提取时间，

下面是格式.

  19979158:DAM"  

 2.在同一行中提取":"直到提供输出的空格 "04:06 ET"  
解决方案
 
在:DAM之前是否总是8个数字，我的意思是我们可以找到:DAM然后读取之前的七个数字字符吗?并且总是在:DAM之后然后是时间吗?
 
 
Extract text from Specific Character and Number & Extract time from same line,
Below is the Format.


05/15/2015 04:03:44 :   :  It took Nvidia the better part of a decade to gain acceptance as a global automotive supplier


05/15/2015 04:07:31 :   :  ram paged to CR : 19979158:DAM at 04:06 ET


05/15/2015 04:12:44 :   :  Though the Flipkart listing did not give away many details about the third-gen Moto G at 04.06 ET


05/15/2015 04:17:01 :   :  Once among the top display suppliers to Apple In



Output required
Dim A  = 19979158:DAM
dim B = 04.06 ET.
The Common factor for the above put is ....
1. 1st find Greater then 7 Digit Number and Character ":DAM" , then Extract "19979158:DAM"
2.In Same line extract " : " until Space which gives the output "04:06 ET"
解决方案
Is it always 8 numeric digits before :DAM, I mean can we find :DAM and then read the seven numeric chars before? and is it always at after :DAM then time?


                        
这篇关于从特定字符和数字中提取文本从同一行提取时间，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！