Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
\s((?:\w|_)+\.(?:\w|_)+\.(?:\w|_)+)\s
/
g
Input 1
SELECT T.IDP_WAREHOUSE_ID, T.IDP_AUDIT_ID, T.IDP_DATA_ID, T.IDP_DATA_DATE, T.TRADESYSTEM, T.SOURCESYSTEM, T.SUBSYSTEM, T.TRADEDATE, T.VALUATIONDATE, T.TRADEID, T.TRADETYPE, T.TRADESTATUS, T.MAPPEDTRADESTATUS, T.RAWBOOKINGLOCATION, T.MAPPEDBOOKINGLOCATION, T.BOOKINGLOCREGION, T.CMCIFBOOKINGLOCATION, T.CMCIFBOOKINGLOCATIONREGION, T.COUNTERPARTYACCOUNTID, T.COUNTERPARTYSHORTNAME, T.COUNTERPARTYTYPE, T.CUSTOMERNAME, T.CUSTOMERADDRESS, T.CUSTOMERCOUNTRYCODE, T.CUSTOMERCOUNTRYNAME, T.CAMLO_RISK, T.US_BSA_RISK, T.RISKRATING, T.PRODUCTTYPE, T.PRODUCT, T.CMCIFPRODUCTTYPE, T.QUANTITY, T.PRICE, T.CURRENCY, T.CURRENCY_ISO_CODE, T.CURRENCY_DESCRIPTION, T."VALUE", T.TRADERID, T.TRANSACTIONACTIVITY, T.SOURCETRADEID, T.TRADESEQUENCENUMBER, T.BASECURRENCY, T.BASECURRPRICE, T.BASECURRQUANTITY, T.BASECURRVALUE, T.ISIN, T.CUSIP, T.RESP, T.FACILITY_GLOBAL_COMMITMENT, T.FACILITY_HOST_BANK_NET_AMT, T.MAP_TRADESYSTEM, T.MAP_ACCOUNTFIELDNAME, T.MAP_COUNTERPARTYACCOUNTID, T.MAP_CUID, T.MAP_CIF, T.MAP_UEN, RC.RA
Extraction
SELECT T.IDP_WAREHOUSE_ID, T.IDP_AUDIT_ID, T.IDP_DATA_ID, T.IDP_DATA_DATE, T.TRADESYSTEM, T.SOURCESYSTEM, T.SUBSYSTEM, T.TRADEDATE, T.VALUATIONDATE, T.TRADEID, T.TRADETYPE, T.TRADESTATUS, T.MAPPEDTRADESTATUS, T.RAWBOOKINGLOCATION, T.MAPPEDBOOKINGLOCATION, T.BOOKINGLOCREGION, T.CMCIFBOOKINGLOCATION, T.CMCIFBOOKINGLOCATIONREGION, T.COUNTERPARTYACCOUNTID, T.COUNTERPARTYSHORTNAME, T.COUNTERPARTYTYPE, T.CUSTOMERNAME, T.CUSTOMERADDRESS, T.CUSTOMERCOUNTRYCODE, T.CUSTOMERCOUNTRYNAME, T.CAMLO_RISK, T.US_BSA_RISK, T.RISKRATING, T.PRODUCTTYPE, T.PRODUCT, T.CMCIFPRODUCTTYPE, T.QUANTITY, T.PRICE, T.CURRENCY, T.CURRENCY_ISO_CODE, T.CURRENCY_DESCRIPTION, T."VALUE", T.TRADERID, T.TRANSACTIONACTIVITY, T.SOURCETRADEID, T.TRADESEQUENCENUMBER, T.BASECURRENCY, T.BASECURRPRICE, T.BASECURRQUANTITY, T.BASECURRVALUE, T.ISIN, T.CUSIP, T.RESP, T.FACILITY_GLOBAL_COMMITMENT, T.FACILITY_HOST_BANK_NET_AMT, T.MAP_TRADESYSTEM, T.MAP_ACCOUNTFIELDNAME, T.MAP_COUNTERPARTYACCOUNTID, T.MAP_CUID, T.MAP_CIF, T.MAP_UEN, RC.RA