We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

cncatenation problem 2

Thread ID:





22487 Dec 14,2004 12:43 PM UTC Dec 15,2004 05:15 PM UTC WinForms 1
Tags: Calculate
Michel T Dallaire
Asked On December 14, 2004 12:43 PM UTC

dim g1 as string = "toto2" dim g2 as string = "toto4" calc("a")= "=""" & g1 & """" calc("b")= "=""" & g2 & """" calc("c")= "=concatenate(""toto1"",[a],""toto3"",[b])" msgbox calc("c") it returns: "toto1"toto2"toto3"toto4"" it seems to concatenate the quote with the answer. It should have return: "toto1toto2toto3toto4" and then agani, whe I use that, I still have the problem to remove the leading and ending quotes because it creates me problem. I would prefer it return: toto1toto2toto3toto4 In the code below, my problem is that G1 and G2 comes from a database and that will creates me the right variable name at the end. If you try with Excel, it does not return any quotes and it return the exact answer I would need. So I would think it we try does function with an Excel sheet with ExcelRW, we will have a big problem. Thank you.

Administrator [Syncfusion]
Replied On December 15, 2004 05:15 PM UTC

In the upcoming release, using concatenate will still give this problem, but using the ampersand instead will give you the string without the interior quotes. This is how the first release will work unless the release build slips until the concatenate fix gets done.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon