adding a space to a concat

[Kevin Crist]

I know this is going to be an easy one but am drawing a blank.

I am concating two different fields into one but i want to add a blank space in between. How would i do that.

Here is what i have:

|1|ST|PRBCXM1^CROSS MATCH RESULT^LAB

Here is what i want:

|1|ST|PRBC XM1^CROSS MATCH RESULT^LAB

Thanks for any help.

Topic

[Ryan Spires]

Kevin,

You have a couple options..

on the options tab when you are looking at the concat action is a box for separator.  you can add the space there.

Or

You can hardcode a space by using

field1

=

field2

in the input source

where the =  is actually  =

the other option involves using tcl… and is really not needed in most cases.

Ryan

[Kevin Crist]

Thanks a bunch Ryan. Exactly what i was looking for.

[Author]

Replies