6 Replies Latest reply: Sep 19, 2014 1:32 AM by Everardo Mancilla RSS

    RIGHT() / LEFT() Function not working in load script



      I am trying to load a column using the RIGHT() function to only take the 6 right-most characters from it's data.


      For some reason, when i try to load the script, the column can't be found.


      This is the code i am using for the column:


      "Right([Functional loc.],6) as SID"


      The following is the column in excel:



      Thew error that i'm getting:



      I do not want to make a new column in the excel spreadsheet, because i want it to be automated.


      Any help would be greatly appreciated.