script help!!!

• THE ONE

  Valued Member

  Points: 66

  More actions

  October 18, 2005 at 9:54 am

  #89488

  Hi guys,

  Need your help

  I a database column called FILE_EXT and holds file data eg intra_005561.pdf

  What i would like to do in a script is strip the contents of this column and place into two additonal columns.  So in one field would be the file name intra_005561 and the other field would be the file extension eg .pdf

  I have no idea how best to do this so any of you that have done this feel free to post a response.

   

  Cheeers

  Les

• noeld

  SSC Guru

  Points: 96590

  More actions

  October 18, 2005 at 9:58 am

  #597986

  Update Yourtable

  Set FName = Left(File_ext,Charindex('.',File_ext)-1),

      EXt = right( Rtrim(File_ext),3)

  

  
  * Noel

• THE ONE

  Valued Member

  Points: 66

  More actions

  October 18, 2005 at 10:25 am

  #597996

   Noel

  Works a treat!

  Thanks

  Les