Solved

Script Question, How do I concatenate two fields

Posted on 2003-11-28
6
266 Views
Last Modified: 2013-12-18
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
0
Comment
Question by:adspmo
  • 2
  • 2
  • 2
6 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9840620
Wouldn't it be like this

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


~Hemanth
0
 

Author Comment

by:adspmo
ID: 9840728
Hey I will try that out

Thanx

james
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 250 total points
ID: 9844033
Or rather,

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

Or

doc.NameAH = firstName & " " & lastName

I take it you are using LotusScript to access Excel via OLE Automation?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:adspmo
ID: 9846218
Yupp

I am using ODBC to import one time into Notes
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9850355
wasn't that the same answer that I gave you James.. are you going blind here ??
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9854859
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Missing Rules 1 294
Resolving notes group email address to old name with subdomain 10 148
Lotus notes VB code 4 205
Lotus Notes – Domino Document Manager 4 103
For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now