split in string RSS

• • Reply
  

  Pravind

  Member

  64 Points

  230 Posts

  split in string

  Apr 16, 2012 12:33 PM|LINK

  Hi,

  I have a Query

  I have a field where in the field have data  as F22:Stumpy, i just want F22 to store in database,hw can i do this?

  Can any1 help on this? Thanks in advance.

• • Reply
  

  navneetmitaw...

  Contributor

  2965 Points

  932 Posts

  Re: split in string

  Apr 16, 2012 12:35 PM|LINK

  hi try

  string ss = "F22:Stumpy";

  string[] s1 = ss.split(':');

  ss = s1[0];

  Remember to click “Mark as Answer” on the post, if it helps you.
  Navneet Kumar Mitawa
• • Reply
  

  shivalthakur

  Participant

  1837 Points

  531 Posts

  Re: split in string

  Apr 16, 2012 12:37 PM|LINK

  string str = "F22:Stumpy";
              Response.Write("<br />"+str.Substring(0, str.IndexOf(":")));

  if(Hard_Work && Luck)
  Response.Write("Success");
  
  
  Best Of Luck
  Shival Thakur
• • Reply
  

  ramiramilu

  All-Star

  95363 Points

  14096 Posts

  Re: split in string

  Apr 16, 2012 01:01 PM|LINK

  you can also use SubString in SQL - http://msdn.microsoft.com/en-us/library/ms187748.aspx 

  Thanks,

  Website
  JumpStart
• • Reply
  

  vijay_myl

  Contributor

  5070 Points

  1068 Posts

  Re: split in string

  Apr 16, 2012 01:05 PM|LINK

  hi..

  In case if you want in sql query try the below code.....

  declare @s varchar(50)
  set @s='F22:Stumpy';
  select substring(@s,1,CHARINDEX(':',@s,1)-1)

  
  
  

  If the post is useful don't forget to MARK as Answer
  My .NET blog
  Submit Article
  
• • Reply
  

  sriramabi

  Contributor

  4351 Points

  1277 Posts

  Re: split in string

  Apr 16, 2012 09:46 PM|LINK

  hi

  u can study and u can solve this issue.

  pls ref this

  http://www.dotnetperls.com/substring

  thank u

• • Reply
  

  vsdev

  Contributor

  2230 Points

  453 Posts

  Re: split in string

  Apr 17, 2012 04:22 AM|LINK

  Use string.Split().

  var data = "F22:Stumpy";
  var result = data.Split(':');
  var dataToInsert = result[0];

  Please remember to click “Mark as Answer” on the post that helps you.
  Blog: dotnetthoughts
  Download Capture It Plus
  • Marked as answer by Pravind on Apr 20, 2012 12:43 PM