3 Replies Latest reply: Jun 13, 2013 10:34 AM by sean kaiser RSS

    Set variable as seperator

    sean kaiser

      Hi all - This one is bugging me but I know one of you experts will get it straight away!

       

      I am concatenating two fields together into one new field in my load script, such as Company Code and Company Name.  i.e.

       

          

      CompCode & '-' & CompCodeDesc as CompKeyandTxt

       

       

      Which gives the user the user the key and text in one field seperated by -

       

      What I want to do is have a variable on the main tab which defines what character the seperator is so that I only need to change it once if the users decide they want a comma or space or anything else as the seperator.

       

      I've tried:-

       

      set vSeperator = '-';
          

      CompCode & $(vSeperator) & CompCodeDesc as CompKeyandTxt

       

      and numurous other variations without success.

       

      Can anyone help?

       

      Many thanks in advance.

      Sean.