Expression escape character for hyphen (-) and ampersand (&)

• ec082018mp

  SSC Enthusiast

  Points: 173

  More actions

  January 8, 2020 at 5:11 pm

  #3713704

  Hello,

  I'm trying to create an expression for the filename to import into SQL Server.

  The filename is as follows:  transport_01_08_2020.TXT

  The current expression logic I have is:

  "C:\\Drops-MIS\\F&F Import - dropShip\\transport_" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2) + "_" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + "_" + (DT_STR, 4, 1252) DATEPART("yyyy" , GETDATE()) ".TXT"

  I tried this expression but received the following error:

  

  Do I need an escape character for hyphen (-) and ampersand (&)?  If so,  how do I add it to the logic I have?

   

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  January 8, 2020 at 5:14 pm

  #3713706

  Are you missing a + before ".TXT"?

  ---

• ec082018mp

  SSC Enthusiast

  Points: 173

  More actions

  January 8, 2020 at 5:36 pm

  #3713712

  Thanks SSC Guru!!!!

  I did miss the + before ".TXT"?