Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Tag: substring

C#

IndexOf() and LastIndexOf() in C#

- 26.09.21 - ErcanOPAK comment on IndexOf() and LastIndexOf() in C#

The IndexOf() method returns the index number of the first matched character whereas the LastIndexOf() method returns the index number of the last matched character. using System; public class StringExample { public static void Main(string[] args) { string s1 = “Hello C#”; int first = s1.IndexOf(‘l’); int last = s1.LastIndexOf(‘l’); Console.WriteLine(first); Console.WriteLine(last); } } Output: […]

Read More
SQL

Get the First and Last Word from a String or Sentence in SQL

- 11.06.18 | 20.05.22 - ErcanOPAK 2 Comments on Get the First and Last Word from a String or Sentence in SQL

You can use the query below: DECLARE @Sentence VARCHAR(MAX) = ‘The quick brown fox jumps over the lazy dog’ DECLARE @first_space_index int = CHARINDEX(‘ ‘, @Sentence) – 1 DECLARE @last_space_index int = CHARINDEX(‘ ‘, REVERSE(@Sentence)) – 1 IF @first_space_index < 0 SELECT @Sentence AS [First Word], @Sentence AS [Last Word] ELSE SELECT SUBSTRING(@Sentence, 1, @first_space_index) […]

Read More
December 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Nov    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (704)
  • Get the First and Last Word from a String or Sentence in SQL (698)
  • How to select distinct rows in a datatable in C# (559)
  • Add Constraint to SQL Table to ensure email contains @ (455)
  • Average of all values in a column that are not zero in SQL (372)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (344)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (338)
  • Find numbers with more than two decimal places in SQL (325)
  • Confirm before process with ASPxButton in Devexpress (316)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (292)

Recent Posts

  • How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
  • How to convert JPG or PNG to WebP in batch or single mode
  • How to get the first and the last day of previous month in SQL Server
  • Not Null check on LEFT function with T-SQL
  • NICE 100 YILLARA TÜRKİYEM
  • How to delete all commit history in github
  • How to display HTML components on the same line in CSS
  • How to insert results of a stored procedure into a temporary table
  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (704)
  • Get the First and Last Word from a String or Sentence in SQL (698)
  • How to select distinct rows in a datatable in C# (559)
  • Add Constraint to SQL Table to ensure email contains @ (455)
  • Average of all values in a column that are not zero in SQL (372)

Recent Posts

  • How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
  • How to convert JPG or PNG to WebP in batch or single mode
  • How to get the first and the last day of previous month in SQL Server
  • Not Null check on LEFT function with T-SQL
  • NICE 100 YILLARA TÜRKİYEM

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

© 2023 ErcanOPAK.com

Proudly powered by WordPress | Theme: Xblog Plus by wpthemespace.com