我需要从文本field.The中提取数字保护字段不一致。
我尝试写入子字符串,但不起作用,因为文本不一致。
CASE WHEN position ( 'CNTRL ', ACTVY_NOTE_TXT) > 0
THEN SUBSTRING ( ACTVY_NOTE_TXT,position ( 'RECORD ID ', ACTVY_NOTE_TXT)+6, position ( ' [', ACTVY_NOTE_TXT) - position ( 'RECORD ID ', ACTVY_NOTE_TXT) -6)
ELSE NULL END as DisputeID,
输入
RCVD 2019-05-06 BOR DISPUTED VIA MAIL- - STATES VICTIM OF IDENTITY THEFT SENT 10030 LIDB LETTER -FRANK CHICK - 525 STELLAR CT 525 - KODAK TN 37764 - -STEP FAILED- CBR DISPUTE CODED IN LAST 6 MONTHS-C106 05 15 2019 13:33:42 MWZ OPEN ACCT DISPUTE RECORD ID 999703 [PJR748:5 21 2019 12:00:00 AM]
输出应为
999703
https://stackoverflow.com/questions/56519130
复制相似问题