Search This Blog

Tuesday, February 22, 2011

Single Quote Issue in Config Builder in Excel based Grids

In the Config Builder 2.0 Excel grids, when concatenating values with columns, Excel REMOVES the apostrophe.

Code before upgrade:
 'E_'+SalesOrg

Code after upgrade:
 E_'+SalesOrg

In summary, if an apostrophe is the first character in your code, it removes it and breaks the feed.

Solution:
Double the lead apostrophe.  For example, see red

''E_'+SalesOrg

No comments:

Post a Comment