Find and replace formula in Excel
Hi everybody. I am forex and options trader. Options contracts look like this: ‘GOOG 121005C770″ or “GOOG 121005P770″. I need to have a formula that can lookup the cell and if contains “*******P***” to replace the whole cell with “Put” and if the cell contains “*******C***” to replace the whole cell with “Call”. Now I [...]
Answer Question
| October 8, 2012 11:48 AM
Microsoft Excel 2010, Microsoft Excel formulas
Hi everybody. I am forex and options trader. Options contracts look like this: ‘GOOG 121005C770″ or “GOOG 121005P770″. I need to have a formula that can lookup the cell and if contains “*******P***” to replace the whole cell with “Put” and if the cell contains “*******C***” to replace the whole cell with “Call”. Now I [...]
Answer Question
| October 8, 2012 11:48 AM
Microsoft Excel 2010, Microsoft Excel formulas
SQL Group by Query with aggregate function as well as detail information
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
Converting amount in character field to numeric in rpgle
Hi, How to convert the amount value in character field(Eg: ‘ 5,000- ‘) to numeric in rpgle. I used %DEC built in function, it shows decimal data error. Is there any bulit in function or opcode to convert ‘ 5,000- ‘ to numeric field in rpgle ?
Answer Question
| October 8, 2012 11:04 AM
RPGLE
Hi, How to convert the amount value in character field(Eg: ‘ 5,000- ‘) to numeric in rpgle. I used %DEC built in function, it shows decimal data error. Is there any bulit in function or opcode to convert ‘ 5,000- ‘ to numeric field in rpgle ?
Answer Question
| October 8, 2012 11:04 AM
RPGLE
SAP BI certification qualifications: 5years of Market research and analysis experience
Hi, I have 5+ years of market research experience. I would like to know if I can take up SAP BI certification programme to step up my career growth? If, yes how do I go about it? Take any specific module/tool under SAP BI?
Answer Question
| October 8, 2012 9:59 AM
Research Analysis Market research SAP NetWeaver Business Intelligence
Hi, I have 5+ years of market research experience. I would like to know if I can take up SAP BI certification programme to step up my career growth? If, yes how do I go about it? Take any specific module/tool under SAP BI?
Answer Question
| October 8, 2012 9:59 AM
Research Analysis Market research SAP NetWeaver Business Intelligence
A problem when BDAM files with key are copied by DFSMSdss.
I have a problem with my BDAM files with key when the files are copied using DFSMSdss of z/OS. If the files are copied using physical processing, everything is OK. If the files are copied using logical processing, reading existing records is OK, but writing a new record into the copied files fails with BDAM [...]
Answer Question
| October 8, 2012 9:21 AM
DFSM, z/OS
I have a problem with my BDAM files with key when the files are copied using DFSMSdss of z/OS. If the files are copied using physical processing, everything is OK. If the files are copied using logical processing, reading existing records is OK, but writing a new record into the copied files fails with BDAM [...]
Answer Question
| October 8, 2012 9:21 AM
DFSM, z/OS
Retreving source file names of a library
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]
Answer Question
| October 8, 2012 9:20 AM
CLLE, iSeries V5R4MO
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]
Answer Question
| October 8, 2012 9:20 AM
CLLE, iSeries V5R4MO
how make registry as active user registry?
hi,i created one user id for local operating system, by using same user id i tried to configure global security in websphere application server v7 with local operating system registry. but not taken that user id it shows error like bad user id or password
Answer Question
| October 8, 2012 8:41 AM
WebSphere Application Server
hi,i created one user id for local operating system, by using same user id i tried to configure global security in websphere application server v7 with local operating system registry. but not taken that user id it shows error like bad user id or password
Answer Question
| October 8, 2012 8:41 AM
WebSphere Application Server
ActiveSync error code 0×85010014
I am trying to sync my HP iPAC 111 PDA to Outlook 2010 on a laptop with 7 Home Premium. I am not hooked up to a server. When I try to sync I get the above error code on my PDA. The PDA is running on MS Mobile 6.0
Answer Question
| October 8, 2012 6:48 AM
ActiveSync error code 0x85010014, outlook 2010 64 bit, PDA, Win 7
I am trying to sync my HP iPAC 111 PDA to Outlook 2010 on a laptop with 7 Home Premium. I am not hooked up to a server. When I try to sync I get the above error code on my PDA. The PDA is running on MS Mobile 6.0
Answer Question
| October 8, 2012 6:48 AM
ActiveSync error code 0x85010014, outlook 2010 64 bit, PDA, Win 7
pseudocode
INPUT: 30 temperatures OUTPUT: i)average of first 10 temperatures, average of next 10 temperatures and average of last 10 temperatures. ii) Number of times temperature was 0-100,101-200,201-300,>300 (inclusive) iii) Maximum,Minimum temperature and count the number of times max and min have changed. iv) state which series of 10 temperatures is lowest
Answer Question
| October 8, 2012 1:11 PM
Microsoft Word, Microsoft Word features
INPUT: 30 temperatures OUTPUT: i)average of first 10 temperatures, average of next 10 temperatures and average of last 10 temperatures. ii) Number of times temperature was 0-100,101-200,201-300,>300 (inclusive) iii) Maximum,Minimum temperature and count the number of times max and min have changed. iv) state which series of 10 temperatures is lowest
Answer Question
| October 8, 2012 1:11 PM
Microsoft Word, Microsoft Word features
How can I access a .jls file or its bitstream compressed using JPEG-LS so that I may further compress it?
JPEG-LS is a lossless image compression algorithm for continuous-tone images. Images compressed using JPEG-LS results to a file with an extension of “.jls”. How may I access this file, or how may I access its bitstream, so that I may further compress it? Access it in a programming language, e.g. (C#). I’d like to maybe [...]
Answer Question
| October 13, 2012 2:44 PM
.JLS file, JPEG
JPEG-LS is a lossless image compression algorithm for continuous-tone images. Images compressed using JPEG-LS results to a file with an extension of “.jls”. How may I access this file, or how may I access its bitstream, so that I may further compress it? Access it in a programming language, e.g. (C#). I’d like to maybe [...]
Answer Question
| October 13, 2012 2:44 PM
.JLS file, JPEG
Masters after CCNA
Hello all I’m currently Cisco certified and planning to move for my CCNP is sometime I wanted to know if there are any colleges which approve CCNA/CCNP for there masters degree as i don’t have a bachelor’s in computer or engineering. Any help will be great Thanks
Answer Question
| October 8, 2012 2:08 PM
CCNA, CCNP
Hello all I’m currently Cisco certified and planning to move for my CCNP is sometime I wanted to know if there are any colleges which approve CCNA/CCNP for there masters degree as i don’t have a bachelor’s in computer or engineering. Any help will be great Thanks
Answer Question
| October 8, 2012 2:08 PM
CCNA, CCNP
VB Code to solve y = sqrt of x^2 – 5z/2a +Sin x – Cos z (x^3 – e^a)
Write a VB application to solve following expression: y = sqrt of x^2 – 5z/2a +Sin x – Cos z (x^3 – e^a)
Answer Question
| October 8, 2012 1:57 PM
Visual Basic 6, Visual Basic Functions
Write a VB application to solve following expression: y = sqrt of x^2 – 5z/2a +Sin x – Cos z (x^3 – e^a)
Answer Question
| October 8, 2012 1:57 PM
Visual Basic 6, Visual Basic Functions
inserting many columns
i want to insert new columns like day1, day2, day3, etc. in a database by passing a veriable in day(n), please help me what i can do for this
Answer Question
| October 6, 2012 9:54 AM
SQL commands
i want to insert new columns like day1, day2, day3, etc. in a database by passing a veriable in day(n), please help me what i can do for this
Answer Question
| October 6, 2012 9:54 AM
SQL commands
Using BAPI for Customizing SAP Reports
With the help of klanduedoc’s knowledge which he shared http://klanguedoc.hubpages.com/hub/Silent-Connection-with-SAPLOGON-with-RFC SDK-Example-RFC-Excel-VBA, I managed to develop a reporting system which uses the silent connection to SAP downloads sale orders headers & lineitems in two separate table in access database and then it generates sales & targets reports on daily basis. The users are happy. One thing [...]
Answer Question
| October 6, 2012 4:11 AM
BAPI
With the help of klanduedoc’s knowledge which he shared http://klanguedoc.hubpages.com/hub/Silent-Connection-with-SAPLOGON-with-RFC SDK-Example-RFC-Excel-VBA, I managed to develop a reporting system which uses the silent connection to SAP downloads sale orders headers & lineitems in two separate table in access database and then it generates sales & targets reports on daily basis. The users are happy. One thing [...]
Answer Question
| October 6, 2012 4:11 AM
BAPI
Folder sharing Windows 2008
I have Windows 2008 with Active Directory. How can i create a folder and share this folder for only Human Rights department? Only 4 person must be to see this Folder from HR department?
Answer Question
| October 8, 2012 1:29 AM
Active Directory, Windows 2008
I have Windows 2008 with Active Directory. How can i create a folder and share this folder for only Human Rights department? Only 4 person must be to see this Folder from HR department?
Answer Question
| October 8, 2012 1:29 AM
Active Directory, Windows 2008
Outlook 2007 cannot connect to exchange server
Hello everyone, I’m having problem setting up an Outlook 2007 profile on a new computer: DELL WINDOWS XP Sp2 The user profile is already on the old computer without any problem but on the new computer when I’m manually configuring following these instructions http://support.sherw…7-exchange-2007 which was given from my exchange provider which is : Sherweb: [...]
Answer Question
| October 8, 2012 10:35 PM
Microsoft Outlook 2007, Microsoft Outlook error messages
Hello everyone, I’m having problem setting up an Outlook 2007 profile on a new computer: DELL WINDOWS XP Sp2 The user profile is already on the old computer without any problem but on the new computer when I’m manually configuring following these instructions http://support.sherw…7-exchange-2007 which was given from my exchange provider which is : Sherweb: [...]
Answer Question
| October 8, 2012 10:35 PM
Microsoft Outlook 2007, Microsoft Outlook error messages
Expand Counter Size in WRKQRY
I use WRKQRY to produce a summary file. I use ’5′ to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?
Answer Question
| October 8, 2012 9:25 PM
AS400 -WRKQRY, WRKQRY
I use WRKQRY to produce a summary file. I use ’5′ to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?
Answer Question
| October 8, 2012 9:25 PM
AS400 -WRKQRY, WRKQRY
Cloud certification — worth it?
Any contractors out there found that getting cloud-specific certifications makes a difference in getting hired for a project? Seems like it’s an emphasis (for Microsoft particularly) right now, but I’m not sure it’s worth it. Seems like knowledge of individual technologies that contribute to cloud would be more worthwhile.
Answer Question
| October 5, 2012 8:17 PM
certification, Cloud Computing, Private Cloud
Any contractors out there found that getting cloud-specific certifications makes a difference in getting hired for a project? Seems like it’s an emphasis (for Microsoft particularly) right now, but I’m not sure it’s worth it. Seems like knowledge of individual technologies that contribute to cloud would be more worthwhile.
Answer Question
| October 5, 2012 8:17 PM
certification, Cloud Computing, Private Cloud
SAP -MM IMPLEMENTATION
IN SAP IMPLEMENTATION ERROR CAME AS – -Account determination for key INT GBB__INV 3000 is not maintained in MM. How can I solve this?
Answer Question
| October 5, 2012 8:12 PM
SAP MM
IN SAP IMPLEMENTATION ERROR CAME AS – -Account determination for key INT GBB__INV 3000 is not maintained in MM. How can I solve this?
Answer Question
| October 5, 2012 8:12 PM
SAP MM
Open IT Forum: Apple’s greatest innovation
Mashable recently published a chart of Apple’s distinguished history including every Apple computer ever released since Steve Jobs introduced the IT world to the first Mac over 30 years ago. What has been your favorite Apple innovation? What’s the one product you think helped change the course of IT history?
Answer Question
| October 5, 2012 7:15 PM
Apple, Apple Mac
Mashable recently published a chart of Apple’s distinguished history including every Apple computer ever released since Steve Jobs introduced the IT world to the first Mac over 30 years ago. What has been your favorite Apple innovation? What’s the one product you think helped change the course of IT history?
Answer Question
| October 5, 2012 7:15 PM
Apple, Apple Mac
