Assuming replace is required, the following 100 results were found.
-
//m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
words, it didn't remove the unnecessary zeros. Note that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ", ",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ v_ImageURL = r_Permissions.get("data").get("attributes").get("permalink"); v_ImageURL = v_ImageURL.replaceAll("https://workdrive.zohopublic.eu/file/","",true); // // replaced with URL taken on inspect element v_ImageURL =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value is to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow { input.Color_Picker:ui.add(v_ThisColor); } } Step 2: Replace the text with colored boxes //... // // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ ": " + v_Frequency + ":- "; // // only use up more api calls if occurs more than once if(v_Frequency > 1) { // // replace apostrophes with double apostrophe for coql v_SearchName = v_ProductName.replaceAll("'","''",true); // v_KeepID = 0; // // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE ( '1, 2, 3, 4, 5, 6' , ',', '') || '' ) AS xmlval FROM DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html
Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml = CONVERT(xml,'' + REPLACE(@myStringToParse,',','') + ''); SELECT [Value] = T.c.value('.','varchar(20)') FROM @myXml.nodes('/root/s') T(c);
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html
lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but wouldn't it be nice if you could just replace the base64encode function with an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF