Assuming range is required, the following 26 results were found.
-
CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings )...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte Unsigned values from 0 to 255 Numeric...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
all events // NB: status=open are upcoming events; status=closed are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in which the B2 value was found. -- Returns #N/A for a value which is NOT in...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
— Between Count You use the between-count interval operator to search for a number of occurrences within a specified range. For example, to find where 'a' occurs at least 3 times and no more than 5 times, you use the following regular expression:...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Const WM_MDINEXT = $0224 Const WM_MDIMAXIMIZE = $0225 Const WM_MDITILE = $0226 Const WM_MDICASCADE = $0227 Const WM_MDIICONARRANGE = $0228 Const WM_MDIGETACTIVE = $0229 Const WM_MDISETMENU = $0230 Const WM_ENTERSIZEMOVE = $0231 Const WM_EXITSIZEMOVE =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
compatibility for this app - [1.7.0] Map: toggle city centres - [1.7.0] Map: toggle map type - [1.7.0] Map: change blue zone range - [1.7.0] Map: tap the "located" infotip to scan current - [1.7.0] Map: tap and Hold anywhere on the map to scan - [1.7.0]...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
calendar SET @EndDate = DATEADD(DAY,6-DATEPART(WEEKDAY,@EndDate),@EndDate) ; WITH Dates([Date]) AS ( --Select First day in range SELECT CONVERT(DATETIME,@StartDate) AS [Date] UNION ALL --Add a record for every day in the range SELECT DATEADD(DAY, 1,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
(along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
(SMD): The SITS application audit giving details on each process. Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters. Stu-Talk Monitor Summary (STMS): Specify a SMG, date range and it will give you an overview of the DOT, EOT,...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
You also may not make threats against administrators (or other members for that matter...). Punishments for harrassment range from a 5 day mute for minor harrasments to a permanent ban if serious threats are involved. Amendment 4 - If you break more...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
for and count holiday clashes: First we need the code to search for other requests with these dates, we're going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
+ v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through active products range m_Sku_IDs = Map(); v_LastID = 0; l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
this field hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references specified in a previous multi-line text...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *