Want to Use Environment.NewLine.ToArray but ignore 1 occurrence of carriage return line feed

HI,

I am using below functions in UI path to get the sql query from email body. Some of the queries are too long and split by carriage return line feed.

strFromEmail.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries).Where(Function(x) x.Contains(“SQL” ))

How can i use same function and just ignore one occurrence of carriage return line feed?

Hi,

Ca you share specific data? I suppose perhaps you should use regex matches method/activities.

Regards,

SQL: SELECT SUM(DQT0_D.COL30_) AS COL3,SUM(DQT0_D.COL41_) AS COL4,SUM(DQT0_D.COL52_) AS COL5,SUM(DQT0_D.COL63_) AS COL6,SUM(DQT0_D.COL74_) AS COL7,COALESCE(DQT0_D.COL85_,DQT1_D.COL812_,DQT2_D.COL819_) AS COL8,COALESCE(DQT0_D.COL96_,DQT1_D.COL913_,DQT2_D.COL920_) AS COL9,SUM(DQT0_D.COL107_) AS COL10,COALESCE(DQT0_D.COL118_,DQT1_D.COL1114_,DQT2_D.COL1121_) AS COL11,SUM(DQT1_D.COL1215_) AS COL12,SUM(DQT1_D.COL1316_) AS COL13,SUM(DQT1_D.COL1417_) AS COL14,SUM(DQT1_D.COL1518_) AS COL15,SUM(DQT0_D.Unit_Retail__Regular9_) AS Unit Retail: Regular,SUM(DQT0_D.DC_On_Hand_Units10_) AS DC On-Hand Units,SUM(DQT0_D.Store_On_Hand_Units11_) AS Store On-Hand Units,SUM(DQT2_D.Permanent_Markdown22_) AS Permanent Markdown FROM (SELECT SUM(Case When f_mik_dl_inv_weekly_position0_.loc_type_cde = ‘W’ then f_mik_dl_inv_weekly_position0_.f_soh_rglr_qty+f_mik_dl_inv_weekly_position0_.f_soh_prmtn_qty+f_mik_dl_inv_weekly_position0_.f_soh_clrc_qty ELSE 0.0 END) AS COL 30_,SUM(f_mik_dl_inv_weekly_position0_.f_tsf_in_trnst_cost_amt+f_mik_dl_inv_weekly_position0_.f_soh_rglr_cost_amt+f_mik_dl_inv_weekly_position0_.f_soh_prmtn_cost_amt+f_mik_dl_inv_weekly_position0_.f_soh_clrc_cost_amt) AS COL41_,SUM(f_mik_dl_inv_weekly_position0_.f_soh_rglr_rtl_amt+f_mik_dl_inv_weekly_position0_.f_soh_clrc_rtl_amt+f_mik_dl_inv_weekly_position0_.f_soh_prmtn_rtl_amt) AS COL52_,SUM(f_mik_dl_inv_weekly_position0_.f_soh_rglr_qty+f_mik_dl_inv_weekly_position0_.f_soh_prmtn_qty+f_mik_dl_inv_weekly_position0_.f_soh_clrc_qty) AS COL63_,SUM(case when f_mik_dl_inv_weekly_position0_.loc_type_cde=‘W’ then f_mik_dl_inv_weekly_position0_.f_on_ord_qty else 0.0 END) AS COL74_,d_mik_dl_skulist1_.skulist_desc AS COL85_,d_mik_dl_skulist1_.skulist AS COL96_,SUM(Case When f_mik_dl_inv_weekly_position0_.loc_type_cde = ‘S’

There is other data also in email…i have to extract the full query after SQL: