string - Help with SubString in SSIS -

string - Help with SubString in SSIS -

हेलो ऑल,

मेरे SSIS (व्युत्पन्न स्तंभ) में सबस्ट्रिंग फंक्शन के साथ थोड़ी समस्या है ।

इतने पर ..
ये संभव इनपुट स्ट्रिंग हैं:

खिलौने | श्रेणी | कार | लेगो

खिलौने | गरम और नई | लड़कियों & amp; "लाइफस्टाइल | गुड़िया

खिलौने | नया

बारबीज़ | श्रेणी | मोबाइल

मुझे दूसरा" | "के बाद शब्द को फ़िल्टर करना होगा

पहले मामले में: "कार"

दूसरे मामले में: "गर्ल्स एंड लाइफस्टाइल"

तीसरे मामले में: ""

< P> चौथे मामले में: "मोबाइल"

मेरा प्रयास था: SUBSTRING (श्रेणी, खोज (श्रेणी, "|", 2) + 1, खोज (श्रेणी, "|", 3)) < / P>

यह काम नहीं करता है क्योंकि खोज (श्रेणी, "|", 3) सूचकांक देता है, लेकिन मुझे शब्द की लंबाई की आवश्यकता है !!

आपकी मदद के लिए धन्यवाद और मेरे बुरे अंग्रेजी के लिए क्षमा करें!

सर्वश्रेष्ठ संबंध एलेक्स

यह आपको करना चाहिए ... एक स्पर्श गन्दा हालांकि!

  SUBSTRING (श्रेणी, FINDSTRING (श्रेणी, "|", 2) + 1, फाउंडिंग (श्रेणी, "|", 3) -FINDSTRING (श्रेणी, "|", 2) -1)    < / html>








03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




google chrome extension - Reason for Uncaught Error: Attempting to use
a disconnected port object -



    While retrieving the request from the content script, I get this error in the background page. Does anyone know that this error What can be the reason?   Full stack trace:    Unwanted error: Attempt to use Chrome / Renderer Extension Binding Disconnected Port Objects: 147 Chrome.port Post Message Chrome / Renderer Extension Binings: 147 ChromeHird.port DicePatchOnConnect.Connect Event Chrome / Renderer Extension Binings: 89IExtension.fu SendResponse.state background.js: 1573db.readTransaction.tx.executeSql.paramStr background.js: 1038    This only happens when Reloading extension is not being helpful for a few hours - it is not that after restarting the Chrome browser it will be a solution that becomes normal for a few hours, content script may continue to send requests for background No response can be sent from the background. Is there any way that I can catch this unwanted error and reset the listener?   I am using chrome.extension.onRequest.addListener for my communication. Bef...






visual studio 2010 - How to reinstall MVC 2 tools for VS2010? -



    I uninstalled ASP.Net MVC 2 device for Visual Studio 2010. How can I restore it? MVC2 downloads seem to include only the VS2008 device.   Whatever I said, says that MVC 2 has been included in VS2010, but the installation of an improvement did not fix it, and MVC 2 is not listed. Add VS2010 / Select a component in the Remove screen.      You will get your VS2010ToolsMVC2.msi VS2010 DVD under WCU \ ASPNETMVC - hopefully it will do!    






c# - ASP.net WebForms - Using GetRouteUrl in markup -



    I am trying to figure out how to use routing features with ASP.net 4.0 WebForms. I added a path to my path collection:    zero Application_Start () {RegisterRoutes (RouteTable.Routes); } Zero Registration route (route collection route) {routes.MapPageRoute ("Near-way", "approx /", "~ / about.aspx"); }    In my master page I tried to do the following:    & asp: hyperlink id = "asdf" runat = "server" navigateUrl = ' & Lt;% = GetRouteUrl ("Near-way", New {})% & gt; & Gt; Test & lt; / Asdf>    I got a compiler error: In the server tag, & lt;% ...% & gt; Constructs.   What is the correct way to create root URLs in a server control in a web form? I also need to include the following:    & lt; ASP: Menu id = "Navigation Menu" Runat = "Server" CssClass = "menu" EnableViewState = "false" Include Styleball = "wrong" orientation = "horizonta...








Powered by Blogger