Search results for query: *

Folder Path: C:\Test Excel file name: test.xlsx Columns A2:A22 and D2:D22 Want to take the data from those columns and put it into a new xlsx

I am currently using replace function to add a new line after each "." but will be more presentable if there is a new line after every 5 words? How can I add a new line after every 5 words?

My string contains: The dog walked across the street. How can I parse this string and only return walked across .. Take only words between dog and street.

String contains a value in HTML format. The value is an email. The value contains tags such as <P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><o:p><FONT face ... I was able to remove the HTML format, but I end up losing the format in general. The email will show on one line, etc... Any...

I am experimenting with Visual Studio 2015. I created a webform in which contains a datagrid. I have enabled Edit and Delete on the grid. When I select PREVIEW IN BROWSER option, the page loads with the datagrid returning the correct data. I have two links in the grid Edit and Delete. I select...

How can I pass a session variable into a .vbs file

I have a web page and when the user loads the page it displays the name attached to the PC - the Control Panel\USER ACCOUNTs info

Using asp how can I execute this command: c:\Windows\SysWOW64\wscript.exe "C:\Test.vbs

I am able to successfully execute the following code as an excel macro. However I wanted to be able to run this code using vbscript. When I run this from my html page I encounter: Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'TDApiOle80.TDConnection' on...

I want to find duplicate dates for a specific book rental:

How can I check to see if the Date Modified in for a specific file name is yesterday... For example: File Name Date Modified Test3.txt 2014-07-28 Test2.txt 2014-05-08 Test1.txt 2014-01-01 IE: LAST modified date for files starting with Test...

Name column: Height column Name column contains the same value but the Hight column is different. IE: NAME HEIGHT John 6FT2 John 6FT2 Shawn 3FT1 Shawn 5FT2 Return SHAWN as Shawn contains multiple records with a different Height value

SELECT SUBSTR('\NAME\ADDRESS\CITY\STATE' , INSTR('\NAME\ADDRESS\CITY\STATE','\', 1, 2)-5 ) ADDRESS, SUBSTR('\NAME\ADDRESS\CITY\STATE' , INSTR('\NAME\ADDRESS\CITY\STATE','\', 1, 2)-5 ) CITY FROM dual; How can I change this query to return ADDRESS and CITY in seperate columns as the result...

SELECT SUBSTR('\NAME\ADDRESS\CITY\STATE' , INSTR('\NAME\ADDRESS\CITY\STATE','\', 1, 2)-5 ) ADDRESS, SUBSTR('\NAME\ADDRESS\CITY\STATE' , INSTR('\NAME\ADDRESS\CITY\STATE','\', 1, 2)-5 ) CITY FROM dual; How can I change this query to return ADDRESS and CITY in seperate columns as the result...

We have a clustered environment and when on the report object - Viewing Server Group - 'Only use servers belonging to the selected group' option is greyed out????

I create a report against a DSN connection using Crystal Reports 2008 and Crystal Reports XI Release 2. I am able to do a Verify Database and the hit F5 and the data is returned on the report as expected. I deploy the rpt file to the CMC, under Process tab\Database, I use the 'Use Custom...

Table = Employees Column1 = https://ebay.com/sec/EmployeeName.pdf Using a SELECT statement I want to return the name of the pdf file from Column1 (ie: EmployeeName.pdf) How can I do this using a SELECT statement

BOE XI 3.1 Windows 7 Unable to view reports using IE8. We are able to view reports VIA IE7, IE9, Firefox but cannot view reports VIA IE8... We can view the reports VIA the CMC but when run from JAVA app we encounter this issue. Here is what we have in our logs...

I keep getting error ERROR line 9, col 14, ending_line 9, ending_col 15, Found ':=', Invalid identifier: := CREATE OR REPLACE PROCEDURE SYSVIEW.TESTREPORT (V_TEXT IN varchar2) AUTHID CURRENT_USER AS V_VAR1 VARCHAR2 (12); v_VAR2 INTEGER; V_TABLE_NAME VARCHAR(50)...

This returns the count of 3 months (which is correct): SELECT round(MONTHS_BETWEEN (DATE '2012-12-07', DATE '2012-10-12') + 1) FROM dual; Dec Nov Oct However I am trying to return the count of 2 for the following: SELECT round(MONTHS_BETWEEN (DATE '2013-01-07', DATE '2012-12-31') + 1) FROM...