<div>
Wouldn't it be like this<br />
<br />
firstName = result.GetValue( &quot;NameAH&quot; )<br />
lastName = result.GetValue( &quot;LastNameAH&quot; )<br />
doc.NameAH = lastName + &quot;,&quot; + firstName <br />
<br />
<br />
~Hemanth
</div>


Wouldn't it be like this

firstName = result.GetValue( "NameAH" )
lastName = result.GetValue( "LastNameAH" )
doc.NameAH = lastName + "," + firstName


~Hemanth

<div>
Hey I will try that out<br />
<br />
Thanx<br />
<br />
james
</div>


<div>
Yupp<br />
<br />
I am using ODBC to import one time into Notes
</div>


Yupp

I am using ODBC to import one time into Notes

<div>
wasn't that the same answer that I gave you James.. are you going blind here ??
</div>


wasn't that the same answer that I gave you James.. are you going blind here ??

<div>
No, Hemanth, you deserved much of the points. &nbsp;I corrected the order, that's all. &nbsp;You had &quot;ln, fn&quot; where James wanted &quot;fn ln&quot;. &nbsp;if James had asked, I would have suggested 130 to you, 120 to me.
</div>


No, Hemanth, you deserved much of the points.  I corrected the order, that's all.  You had "ln, fn" where James wanted "fn ln".  if James had asked, I would have suggested 130 to you, 120 to me.

<div>
<div class="content wysiwyg-content">
Hi Guys<br />
<br />
I am doing an import from excel<br />
Normally I would use :<br />
doc.NameAH = result.GetValue( &quot;NameAH&quot; )<br />
<br />
However in this case the excell spreadsheet contains First Name Last Name<br />
<br />
I would like to concatenate those into one field at import<br />
Can this be done;<br />
<br />
James
</div>
</div>


Hi Guys

I am doing an import from excel
Normally I would use :
doc.NameAH = result.GetValue( "NameAH" )

However in this case the excell spreadsheet contains First Name Last Name

I would like to concatenate those into one field at import
Can this be done;

James

Script Question, How do I concatenate two fields

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.