SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by bitbucket / PARSENAME / Latest Posts

RE: PARSENAME

Hugo Kornelis — Mon, 19 Nov 2012 10:23:06 GMT

[quote][b]marlon.seton (11/19/2012)[/b][hr]Now is somebody going to tell me function a exists with this capability? If so, I suggest PARSENAME is redundant as its functionality is already present. If not, why make something as restricted as PARSENAME?[/quote]There is no such function. The limited functionality of PARSENAME is because it is actually intended for a very specific use: to parse tablenames. Since they can use one, two, three or four parts (**), divided by dots, that's what PARSENAME supports.(**) In case you're not aware: just the tablename, prefixed by schema (schema.table), in another database on the same instance (database.schema.table), or on another instance using a linked server (server.database.schema.table).

RE: PARSENAME

marlon.seton — Mon, 19 Nov 2012 09:15:15 GMT

[quote][b]Michael Riemer (10/25/2012)[/b][hr]Another great question to learn from - thanks. I had heard of the function, but never knew what it did.[/quote]I hadn't heard of it (so naturally didn't know what it did). Now I've heard of it and know what it does but I'm struggling to think of a situation where I'd need to use it. If it was a general parser that took a string as a parameter and parsed it by a character that was also a parameter, e.g.SELECT PARSESTRING('Mary had a little lamb', 4, ' ')returns 'little' as the fourth value from the start delimited by ' ' with PARSESTRING being the name of this (as far as I know) fictitious function,I could see a use for that. Now is somebody going to tell me function a exists with this capability? If so, I suggest PARSENAME is redundant as its functionality is already present. If not, why make something as restricted as PARSENAME?Edited for grammar

RE: PARSENAME

Hardy21 — Mon, 05 Nov 2012 23:55:35 GMT

Good question. We have used the function in proc but I always face issue about what would be the order - left to right or right to left.. :(

RE: PARSENAME

asifkareem — Mon, 29 Oct 2012 14:17:55 GMT

Good Function Related Question!Thanks

RE: PARSENAME

Kenneth.Fisher — Mon, 29 Oct 2012 10:57:50 GMT

Awsome question! Learned something new and that always brightens my day!

RE: PARSENAME

KarenM — Mon, 29 Oct 2012 08:48:53 GMT

Thanks.

RE: PARSENAME

Raghavendra Mudugal — Sun, 28 Oct 2012 02:40:02 GMT

[quote][b]Hugo Kornelis (10/27/2012)[/b][hr]... to access the elements of a dot-seperated string. ...[/quote]ahhh..... now I am relieved...Thank you Hugo. :cool:

RE: PARSENAME

Hugo Kornelis — Sat, 27 Oct 2012 05:07:38 GMT

Definitely a good question.I regularly use PARSENAME to access the elements of a dot-seperated string. And yet, I still always have to check the documentation to recall which part each number refes to; I keep getting confused about counting from the left or the right, and counting from 1 or 0.

RE: PARSENAME

Lynn Pettis — Fri, 26 Oct 2012 07:39:37 GMT

Nice easy question. Thanks, Ron.

RE: PARSENAME

SQLRNNR — Thu, 25 Oct 2012 21:13:21 GMT

Thanks Ron.

RE: PARSENAME

L' Eomot Inversé — Thu, 25 Oct 2012 20:51:34 GMT

[quote][b]Revenant (10/25/2012)[/b][hr]Thanks for a nice question. BTW, reversal of the order is a frequent pitfall for people who are parsing IPs and do not read the doc carefully enough.[/quote]Yes, it is a nice question.Not realising that 1 delivers the LS portion (ie right hand end) is maybe something that intelites suffer from? The way I always, in the days when reading core dumps was a common passtime, had to remind my brain to work upside down when looking at an x86 core dump? I always found it hard to remember that hex 00FF meant not 255 but 65280, so of course I have no difficulty at all in understanding the order in this function!

RE: PARSENAME

Meow Now — Thu, 25 Oct 2012 12:26:31 GMT

Seems like a nearly useless function, but at least I know about it now. It seems amazing to me that they can put this stuff in but leave out common functions like SPLIT, LPAD, and RPAD.

RE: PARSENAME

KWymore — Thu, 25 Oct 2012 11:43:53 GMT

Interesting function. Not sure when I would use it but good to know anyways. Thanks for the question!

RE: PARSENAME

Revenant — Thu, 25 Oct 2012 10:44:51 GMT

Thanks for a nice question. BTW, reversal of the order is a frequent pitfall for people who are parsing IPs and do not read the doc carefully enough.

RE: PARSENAME

mtassin — Thu, 25 Oct 2012 08:00:02 GMT

[quote][b]Koen Verbeeck (10/25/2012)[/b][hr]Great question about a function I didn't even know it existed :-D[/quote]I knew it existed, but never had much use for it. A guy who I help with SQL problems on occasion was using it to split a manager heirarchy string I had built.Still personally don't have much use for it. And one day I'll get him to use Jeff's Delimited8k split function I have available instead, but at least I knew what this was.

RE: PARSENAME

sestell1 — Thu, 25 Oct 2012 07:24:57 GMT

Interesting question. I did run into this function once before when looking for a simple way to parse a short delimited string. Unfortunately my string had five elements. :(

RE: PARSENAME

Dana Medley — Thu, 25 Oct 2012 06:31:58 GMT

Thank you for the great question. I learned something new today and I already can think of a few applications I can use it with. :-)

RE: PARSENAME

(Bob Brown) — Thu, 25 Oct 2012 04:57:31 GMT

Thank you for the great question. Enjoyed an easy one.

RE: PARSENAME

Stewart "Arturius" Campbell — Thu, 25 Oct 2012 04:32:41 GMT

Interesting question, thanks Ron

RE: PARSENAME

DugyC — Thu, 25 Oct 2012 04:09:54 GMT

Learned something new today, not sure I'll ever need to use it, but you never know.Thanks for the good question. :-D

RE: PARSENAME

matthew.flower — Thu, 25 Oct 2012 02:54:27 GMT

A new one on me too, I would probably have ended up with really messy instr and substr or perhaps xpath functions to achieve the same.There is an interesting example of use of PARSENAME with IP addresses which shows a practical application: http://www.sql-server-helper.com/tips/sort-ip-address.aspx

RE: PARSENAME

Michael Riemer — Thu, 25 Oct 2012 02:31:32 GMT

Another great question to learn from - thanks. I had heard of the function, but never knew what it did.

RE: PARSENAME

mickyT — Thu, 25 Oct 2012 01:21:59 GMT

Thanks for the question ... also didn't know it existed

RE: PARSENAME

BrainDonor — Thu, 25 Oct 2012 01:20:07 GMT

[quote][b]Lokesh Vij (10/25/2012)[/b][hr]I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012![/quote]Indeed it does.

RE: PARSENAME

Iulian -207023 — Thu, 25 Oct 2012 01:17:19 GMT

Thanks for the question. I did not knew it exist.Iulian

RE: PARSENAME

sule99 — Thu, 25 Oct 2012 01:10:23 GMT

Nice question, new function for me :) It might be very useful. Thx

RE: PARSENAME

Lokesh Vij — Thu, 25 Oct 2012 00:37:37 GMT

[quote][b]Jamsheer (10/24/2012)[/b][hr]Thanks for Good question.."Eid Mubarak" to all my SQL Friends.. :)[/quote]"Eid Mubarak" Jamsheer :-)

RE: PARSENAME

Lokesh Vij — Thu, 25 Oct 2012 00:36:43 GMT

Thanks for this question Ron. I was little confused when I saw this phrase "USING SQL SERVER 2012" :-)I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012!

RE: PARSENAME

kalyani.k478 — Thu, 25 Oct 2012 00:32:12 GMT

new for me..Leant n got +1:)

RE: PARSENAME

Koen Verbeeck — Thu, 25 Oct 2012 00:22:06 GMT

Great question about a function I didn't even know it existed :-D

RE: PARSENAME

demonfox — Wed, 24 Oct 2012 23:52:23 GMT

[quote][b]Jamsheer (10/24/2012)[/b][hr]Thanks for Good question.."Eid Mubarak" to all my SQL Friends.. :)[/quote]Eid mubara Jamsheer..I knew of the PARSENAME ..there is a wonderful use of this for taking out the dot separated values, although with limits..good question..thanks

RE: PARSENAME

Jamsheer — Wed, 24 Oct 2012 22:26:41 GMT

Thanks for Good question.."Eid Mubarak" to all my SQL Friends.. :)

PARSENAME

bitbucket-25253 — Wed, 24 Oct 2012 20:47:26 GMT

Comments posted to this topic are about the item [B]PARSENAME[/B]