Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want concatenate fields using chr(39)
how like
field1 &chr(39) &filed2 like this how ?
Hi,
Expression is correct try this in any list box expression or in load script
Ex:-
=Year &chr(39)&Month
Or
Load
Year &chr(39)&Month as New
From Source;
chr(39) returns ( ' ) symbol
Regards
Anand
Yup, that is the way to do it.
Is there any specific problem you are facing ?
For better you can use chr(45) this returns ( - )
Load
field1 &chr(45)& field2 as New
From Source;
Regards
Anand
I prefer pipe (chr124) myself , dash I find in data to often