Assuming value is required, the following 197 results were found.
-
1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value. Cause 3: Fields and objects in the same column do not have the same text alignment For example, the column heading text...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
my_csv_rows_array.forEach( function (row_content, row_index) { // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom parameter then press So to use...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
the service. Cheque overpayment. A buyer, prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
= My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
(or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for AllowUserRegistration allowUserRegistration=0 to disable it. allowUserRegistration=1 to enable it. Not...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This selects all cells. Now open the "Properties" pane, find the "BorderStyle" and type the word "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
For the Action type what ever you want the context menu to display, I use Command prompt from here For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK >...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ---------- ----------- Task 1 0.14...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB