String concatenation

Bryan · Post by **Bryan** » Thu Feb 04, 2010 6:48 pm

All,
Is there a way to put a carriage return in a string concatenation.

Example:
Company
Attribute: Address1
Attribute: City
Attribute: State
Attribute: Zipcode

Employee
Attribute: Address

Process to create new Employee
ENTER NEW Employee WITH Employee.Address=Company.Address1+' Carriage Return '+Company.City+', '+Company.State+' '+Company.Zipcode

I want to take what is now at the company level as:

123 Smith St
Springfield
MS
55555

and turn it into this at the Employee level

123 Smith St
Springfield, MS 55555

kklosson · Post by **kklosson** » Thu Feb 04, 2010 6:51 pm

There may be but I don't know it. I user <10,13> in some other languages. On the other hand, if you can split them, it's very easy to put the street address on one line and the city, st zip on the next. Just a thought.

Bryan · Post by **Bryan** » Thu Feb 04, 2010 7:19 pm

What do you mean by splitting the attributes? I am guessing that you mean splitting them out into two different attributes at the Employee level.

Thanks for the assistance

kklosson · Post by **kklosson** » Thu Feb 04, 2010 7:30 pm

I just mean in your presentation, wherever you are applying the information, you can present it with two strings instead of a multi-line text field.

tford · Post by **tford** » Thu Feb 04, 2010 8:07 pm

Bryan,

If you make a new attribute: SystemSettings.CR & populate it with a Carriage Return, you can then use that attribute in your rule.

kklosson · Post by **kklosson** » Thu Feb 04, 2010 8:31 pm

But Tom,

I think the issue is that we don't know how to insert a carriage return. What's the code?

Bryan · Post by **Bryan** » Thu Feb 04, 2010 8:36 pm

Any guidance on where to start with this?

tford · Post by **tford** » Thu Feb 04, 2010 8:37 pm

No code needed. Just go into the new SystemSettings attribute and made a carriage return. You won't see anything on the form, but you will see the result in your rules.

kklosson · Post by **kklosson** » Thu Feb 04, 2010 8:46 pm

Go figure.

Bryan · Post by **Bryan** » Fri Feb 05, 2010 7:56 pm

Sure enough it worked like a charm.

Bryan · Post by **Bryan** » Tue Mar 16, 2010 1:21 pm

I thought I had this working but now I am trying to input a carriage return into a different bsv as the SystemSettings.CR attribute. Once in the application I go to the CR attribute and hit carriage return which is takes fine though it appears that the save process clears out the carriage return prior to saving. When I go back into review that it was saved correctly there is nothing in the CR attribute.

tford · Post by **tford** » Tue Mar 16, 2010 2:01 pm

Have you tried to use the attribute in a rule?

Bryan · Post by **Bryan** » Tue Mar 16, 2010 2:05 pm

I am actually using it in a process that builds the body of and email. Nothing fancy I just need some breaks between sections of text.

Bryan · Post by **Bryan** » Tue Mar 16, 2010 2:08 pm

CREATE OutgoingEmail WITH OutgoingEmail.Message='Routing Description: <<Routing.Description>> <<SystemSettings.CR>> <<SystemSettings.CR>> Item Type: <<Routing.RoutedItemSCObjectIdentifier>> Item Subject: <<Routing.RoutedItemSCSubject>> <<SystemSettings.CR>> <<SystemSettings.CR>> Item Description: <<Routing.RoutedItemSCDescription>> <<SystemSettings.CR>> <<SystemSettings.CR>>'

tford · Post by **tford** » Tue Mar 16, 2010 3:57 pm

Bryan,

For email, you can use a Test type Document. In that document, you can do any formatting you desire without using CR attribute.