Assuming contains is required, the following 65 results were found.
-
for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and after setting up all the pre-requisites in SITS first: What changes will trigger the event? Find the screen you know contains the field to monitor, in this example, it will be the Application Clearance and Decision Entry (ACD) screen. Put the cursor...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
m_Message.put("role",v_Role); m_Message.put("content",v_Content); l_Messages.add(m_Message); } } // // if the message contains a question mark, send it to OpenAI if(!isBlank(v_Message)) { v_Question = v_Message; // // Need to add openAI token v_Token =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
= $00080000 ;// hidden Object Const SFGAO_DISPLAYATTRMASK = $000F0000 Const SFGAO_FILESYSANCESTOR = $10000000 ;// It contains file system folder Const SFGAO_FOLDER = $20000000 ;// It's a folder. Const SFGAO_FILESYSTEM = $40000000 ;// is a file system...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
v_FilesPath := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext is not media if A_LoopFileExt not contains wav,mp3,avi,flv,mkv,mov,mp4,mpeg,mpg,wmv continue ; get name of file without its extension v_ThisFileName := A_LoopFileName...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
that any products, services or information available through this website meet your specific requirements. This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
yyyy"); info v_ContractDateFormatted; // yields Tuesday, 6th of November, 2018 Method #5: if a list contains: v_NextRenewalDate = '2018-11-06'; v_EnglishOrdinal = if("123".contains(v_NextRenewalDate.toString("dd").right(1)) &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
{ // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// yields: // a,b,c,d,e // a,c,e // compared to: for each v_FieldName in l_FieldApiNames { if(!l_ExcludeFields.contains(v_FieldName)) {... do stuff here... } } // notes: // no need to check if element exists on "removeElement" Zoho OAuth Connector...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the file content instead of the internal file name. {"code":2,"message":"Invalid value passed for doc"}: The doc parameter contains special characters. Improper Statement Error might be due to missing ';' at end of the line or incomplete expression This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","Leavetype"); m_SearchCriteria.put("searchOperator","Contains"); m_SearchCriteria.put("searchText","Leave"); l_SearchCriterias.add(m_SearchCriteria); l_AllTimeOffs =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
v_ThisEventNote = r_Event.get("Event_Details"); // // now lets add double-quotes for Excel in case the event contains commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote + "\"";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
l_AvailableSlots = r_AvailableSlots.get("response").get("returnvalue").get("data"); if(!l_AvailableSlots.toString().containsIgnoreCase("Slots Not Available")) { for each r_AvailableSlot in l_AvailableSlots { if(!r_AvailableSlot.contains("00:00") &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to consider that not all new lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different line to address city but in the same column... The following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
headers:m_Headers ]; // // output response info r_ResponseXML; // // if successful then read the response if(r_ResponseXML.contains("Success")) { // // init l_JSONItems = List(); // // parse the data v_MainNode = "ActiveList"; x_MainNode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *