Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Unanswered: Truncate string in a cell - Help

    Greeting, Experts.

    In my table, there is one column that has the following text:

    http://domain/sub1/sub2/sub3...
    https://domain2/sub1/....
    http://domain_n/
    https://anotherdomain/
    .....


    How do I truncate the string to get only down the sub1 level in all cells of that column? so the result should be:

    http://domain/sub1/
    https://domain2/sub1/
    http://domain_n/
    .....

    Thanks
    John9569

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    This is what you need to know:
    Find Second occurence of string.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •