Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Concatenate syntax
 Login/Join
 
Member
posted
What is a difference in using | vs || to concatenate two columns?


WebFOCUS 7.7, iWay Data Migrator, Windows
Excel, PDF, HTML, XML
 
Posts: 19 | Registered: March 19, 2012Report This Post
Member
posted Hide Post
Found the difference:
|| trims the column while | does not: for instance:
var1 = 'cat '
var2 = 'dog'
var1 | var2 => 'cat dog'
var1 || var2 => 'catdog'

Please let me know if there are other differences.


WebFOCUS 7.7, iWay Data Migrator, Windows
Excel, PDF, HTML, XML
 
Posts: 19 | Registered: March 19, 2012Report This Post
Expert
posted Hide Post
A single | is a soft concatenate, a || is a hard concatenate.

e.g.
Text1 = 'text     '
Text2 = ' more    '

Text3 = Text1 | Text2
Text3 will contain 'text      more    '

Text4 = Text1 || Text2
Text4 will contain 'text more         '


With a hard concatenate, the trailing spaces are shifted to the end of the expression. If you start using parentheses, you can control where the hard and soft concats happen.

e.g.
Text1 = 'text     '
Text2 = 'more     '

Text3 = Text1 || Text2
Text3 will contain 'textmore          '

Text4 = Text1 || (' ' | Text2)
Text4 will contain 'text more          '


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders