?
Solved

Script Question, How do I concatenate two fields

Posted on 2003-11-28
6
Medium Priority
?
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

762 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