News:

Happy New Year!

Main Menu

concatenating strings in shapesheet

Started by david, December 03, 2008, 06:45:12 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

david

December 03, 2008, 06:45:12 AM
how can i concatenate strings in shapesheet? there's no such function "concatenate" and i didn't find any similar function.

anyone knows?

Michael Dag

#1
December 03, 2008, 08:44:05 AM
use &               =Sheet.1!Prop.Text1&" My Text 123 "&Sheet.1!Prop.Text2

is a valid shapesheet formula (if Prop.Text1 and Prop.Text2 are present  ;))

david

#2
December 03, 2008, 08:54:04 AM
thanks.
it worked :).
Print
Go Up Pages1
User actions
Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 165 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1062KB.
Tokens: post-login.
Cache hits: 14: 0.00208s for 26,589 bytes (show)
Cache misses: 4: (show)
Queries used: 18.

[Show Queries]