Загрузка данных


"df_full": "select iddataxmlexternalsource, idapplication, idapplicationparty, datein, appid, typesource, concat('<root>', regexp_replace(regexp_replace(regexp_replace(regexp_replace(inxml, '<адрес[^>]*>', 'адрес'), '</адрес>', 'адрес'), '(?i)<p[^>]*>|</p>', ''), '(?is)<documenttext>.*?</documenttext>', '<documentText></documentText>'), '</root>') as inxml, date_part from s_rr_verif.sm_replica_dbo_indataxmlexternalsource where typesource = 'SSVDJurisdText' and trim(inxml) like '<%' and lower(trim(inxml)) like '<courtcategory%'",