Concat special characters?I want to add >,< symbols to 3 columns that have numbers. Trying to do something like this:
s = dt << New Column( "Added Symbols", character
Formula(
If(
!IsMissing( :A ), ">" || :A,
!IsMissing( :B ), "<" || :B,
!IsMissing( :C ), "=" || :C
)
)<BR />);
How can I cancatenate special characters to columns?
Re: Concat special characters?It worked!! Thanks
Re: Concat special characters?My data is similar. I am trying to do the exact same thing. I tried converting to char like you did, but its still not showing up an output in a new column.
Re: Concat special characters?@amy,
What are you trying to achieve ? If I understand what you have shared correctly, I made a few assumptions and did the following:
If( !Is Missing( :A ),
">" || Char( :A )
)
The formula I used is shown below. If the data in your column is numeric, you will not be able to concatenate, it will have to be cast into a character as shown above. If this is not how your data looks , please share a sample of your data
