sql - tsql function split string -

-

I wonder if someone can help me.

I need a tsql function to split a fixed value as: 

  1) 00 is not specified 3) 01-05 Global WM and BB | Operations 2) 02-05-01 Global WM & BB | Operations | Operation n / a

I need to get a result like this: 

  cat1 cat1descr cat2 cat2descr cat3 cat3descr ------- --- ----------------------------------------------- ------ 00 not mandatory redundant nonsense nonsense 01 Global WM & BB 05 Operations Blank blank 01 Global WM & BB 05 Operations 01 Operations N / A

The result is always 6 columns

Choose funcX ('00 is not specified '); 

  cat1 cat1descr cat2 cat2descr cat3 cat3descr ------------------ ---------------- ------------------------------ 00 Not Specified Null Null Null
< P>

This will work on SQL Server 2005 and SQL Server 2008. I have assumed that the sequence 1, 2, or 3 of the first digits of points has been set in groups. You can do it with less Cascading CTE but I think reading and debugging SUBSTRING / CHARINDEX / LEN syntax has become very difficult. 

  DECLARE @ FE TABLE (Bar VARCHAR (4000)); INSERT @foo (bar) SELECT '00 is not specified 'Select Unions All '01 -05 Global WM & BB | Operations 'Union All Select' 02-05-01 Global WM & BB Operations. Operation N / A '; With split1 as (SELECT n = SUBSTRING (bar, 1, CHARINDEX ('', bar) -1), w = SUBSTRING (bar, CHARINDEX ('', bar) +1, LAN (bar)), RN = ROW_NUMBER (From order to free order), Split 2 AS (Select RN, Cat 1 = Left (N, 2), WL = RTRIM (Sublrastring (W, 1, Coleys (Nalleif (Charundex ('' '', W ) 0) -1, LAN (W))), wr = LTRIM (SUBSTRING (w, NULLIF (CHARINDEX ('|', w), 0) + 1, LAN (W)), cat 2 = Nalif N, 4, 2), '', cat3 = NULLIF (SUBSTRING (n, 7, 2), '') 1) split3 as (SELECT rn, cat1descr = wl, cat2descr = RTRIM (SUBSTRING (wr, 1) C OALESCE (NULLIF (CHARINDEX ('|', wr), 0) -1, LAN), cat 3 dec = LTRIM (SUBSTRING (wr, NULLIF (CHARINDEX ('|', wr), 0) + 1 , 2) Selection of s2.cat1, s3.cat1descr, s2.cat2, s3.cat2descr, s2.cat3, s3.cat3descr from split2 as S2 inder split 3 as S3 ON S2.rn = s3.rn;

Comments

Post a Comment

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

-
This is my first time working with asp.net and javascript, so I do not know very good web resources, or Much about javascript debugging I have to find out that on line oFormObject.submit (); Microsoft JScript Runtime Error: Object does not support this property or method I am using the link to work as a button because I am terrible in aesthetics and I think That link will look more professional than a table of 50 buttons. I have read that this solution can cause problems with browsers due to pre-rendering of my links and many additional traffic and problems, but CSS gives me a button like a link, which has issues of alignment and difference seemed to. & lt ;! DOCTYPE HTML PUBLIC "- // W3C // DTD HTML 4.01 // N" "http://www.w3.org/TR/html4/strict.dtd"> & Lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Head & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "defect differen
Read more

sockets - Delphi: TTcpServer, connection reset when reading -

-
I am trying to implement one for Delphi, but there are some problems with communication. Fitnesse will start my process, and give me a portmember as a command line argument. Then I should make a socket on the port number given to me, and fitness will connect to that port I am using a TCPCP server for the job: < Pre> TcpServer1.LocalPort: = ParamStr (ParamCount); TcpServer1 Active: = true; On OnEXEPT () -Event, I send the protocol version to use as specified in the protocol. Process TForm1.TcpServer1Accept (From: TOBject; ClientSocket: TCustomIpClient); Var s: ansistring; Start clientSocket. Syndrome ('slim - v 0.0', # 10); SetLength (S, 6); ClientSketts Receavebook (S, 6); End; When I call ReceiveBuf (), the process ends, and fitness throws an exception: java.net.SocketException: connection Reset I have seen what sent and received. It shows that my code sends the protocol version, fitness sends back a message, and when I try to get this message
Read more

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -

-
I have a strange problem that I really do not know. In addition to developing a new ASP.NET site, I have to support the old "classic ASP" site. It is written in VBScript with a batch of JavaScript functions. Many of the JavaScript functions include 'files' Everything is fine on our production system (which security is controlled by another group - this is a military installation) Debugging them once did not work I). However, I have a fix for a vague bug that needs to be fully tested and some functions do not run under the "local" copy of the website that runs on my PC. For the record, I am running IIS 5.1 on XP. The problem is that some Javascript functions are running "OK" on the production server, but when they use it as a server, they are not defined on my PC what is happening that last Programmer, for some reason, has decided to put some functions in a series of files, which according to the observations, imitate the "need_once
Read more