Post reply

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

  • 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?

     

  • January 8, 2020 at 5:14 pm

    #3713706

    Are you missing a + before ".TXT"?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • January 8, 2020 at 5:36 pm

    #3713712

    Thanks SSC Guru!!!!

    I did miss the + before ".TXT"?

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply