Set variable as seperator

[#1]

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.

[#2 · Accepted solution]

load X & '$(vSeperator)' & Y AS TEST

You forget the quotes !

[Anonymous]

Sean,

Try this:
let vSeperator = chr(39) & '-' & chr(39);

Regards,
Michael

Edit: I changes set to let

[#4]

Excellent!  Thanks both!