
批處理如何實現(xiàn)從文本指定位置到文本指定位置的替換如何實現(xiàn)把同目錄下a.txt的第3行的第1到8個字符替換掉b.txt的第2行第34到第41個字符,謝謝!a.txt:
b.txt:nclick="copycode($('code0'));">復制代碼
- REPLACE(ARGVALUE,'-','')
- --------------------------------------------------------------------------------
- 0530
就是想把b.txt里的路徑換下,謝謝。nclick="copycode($('code1'));">復制代碼
- load data
- infile E:XINHANETLsource8033_0529_CUSTOMER.txt
- truncate
- into table etl.mid_customer
- fields terminated by ,optionally enclosed by ''
- (BRANCH_ID,
- base_DATE,
- FULL_NAME,
- ID_TYPE,
- ID_NO,
- CIF_NO,
- NATIONALITY,
- CIF_TYPE,
- TEL_NO,
- ADDRESS,
- CONTACT_METHOD,
- CIF_CLASSIFIED,
- CAPITAL_AMT,
- CEO_NAME,
- CEO_ID_TYPE,
- CEO_ID_NO,
- OPEN_ORGAN,
- OPEN_DATE,
- CLOSE_DATE,
- CUST_TYPE,
- CO_TEL_NO,
- CO_FAX_NO,
- CO_RESIDENT_CODE,
- CO_INDUSTRY_CODE,
- COMPANY_SIZE,
- CO_SP_ZONE_YN,
- TAX_CODE,
- INVEST_NATION_ID,
- CO_EMAIL_ADDRESS,
- CO_DECLARATION,
- RE_EMAIL_ADDRESS,
- INF_LAST_CORC_BUSS_DT)

