Hi,
I have a report of 20000+ rows. I need to extract certain data from one of the column. For the example below, I need to extract the 9 digits that comes after 'SN#'.
May I know if this is possible, given the complexity of the data..
[6 rows under same column]:
[R1]Record - DN No. 98765421 SO# 1343434 for CUSROMER 1 - SN# - 07/29/2011'
[R2]Record - DN No. 12345677 SO# 1222222 for CUSTOMER 2 - SN# - 07/29/
[R3]Hardness Test Results SN# - SN# 133449982-1, PO , HEAT# - 07/29/2011'
[R4]Inspection for Main Part SN# - SN# 123456098-1 TO 4, PO , HEAT# - 07/29/2011'
[R5]Dimensional for Main Part SN# - SN# 119221033, PO# HN# - 07/29/2011'
[R6]Dimensional for Sub Part SN# - SN# 120012999-1 TO 5, PO# HN# - 07/29/2011'
I should be getting in another column:
[R1]
[R2]
[R3] 133449982
[R4] 123456098
[R5] 119221033
[R6] 120012999
Bookmarks