Catch text before symbol

Question

Post reply

Catch text before symbol

davdam8

Hall of Fame

Points: 3620
More actions
July 30, 2013 at 10:15 am

#276381

Hi geniuses,
consider:
create table #mytable
(
Value varchar(50)
)
INSERT INTO #mytable
(Value)
SELECT 'First.Second'
I need to isolate what's before the symbol: '.'
I was able to catch whats after the symbol:
SELECT
Value,
(substring(Value,charindex('.',Value)+1,LEN(Value))) AS 'beforedot'
FROM #mytable
Thanks in advance!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

You mean this?

LEFT(Value,charindex('.',Value)-1)

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

davdam8 Hall of Fame Points: 3620 More actions · Answer 2

Luis Cazares (7/30/2013)
You mean this?
LEFT(Value,charindex('.',Value)-1)

Exactly!

Thanks buddy!

davdam8 Hall of Fame Points: 3620 More actions · Answer 3

Need to adapt to this:

(substring(Value,charindex('.',Value)+1,LEN(Value)))

in order o get what's before the 'dot'.

Thnaks

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

I don't understand your last comment.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

You could also use PARSENAME for this.

select PARSENAME(Value, 2) as FirstPart, PARSENAME(Value, 1) as SecondPart

from #mytable

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/