Assuming replaceall is required, the following 18 results were found.
-
in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", "}{", true); v_DataHtml = v_DataHtml.replaceAll(l_Keys.get(0) + "\"", "", true); v_DataHtml = v_DataHtml.replaceAll("\",\"" +...
- 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: *
-
= "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql v_SearchName = v_SearchName.replaceAll("'","''",true); // // replace ampersand with unicode value v_SearchName = v_SearchName.replaceAll("&","\u0026",true); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ii OF CAMBRIDGE-worcester-OXFORD"; // // let's deal with double or triple barrelled first names v_FirstName = v_FirstName.replaceAll("-", " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
#00FF00 // // given value v_HexGiven = "#00FF00"; // // transform or format the submitted value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
d MMM yyyy"); info "*********************"; // // regex change dd/MM/yyyy to yyyy-MM-dd v_RegexdDate = v_TestDate.replaceAll("(\\d{2})/(\\d{2})/(\\d{4})","$3-$2-$1", false); info v_RegexdDate; info v_RegexdDate.toDate(); info v_RegexdDate.toString("E, d...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later on) v_TimeZone = v_TimeZone.replaceAll(","," ", true);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
c_Product in l_ApplicableProducts { l_CsvRow = List(); l_CsvRow.add(c_Product.Photo); l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ",", true)); l_CsvRow.add(c_Product.Product_Desc.replaceAll(",", ",", true)); l_CsvRow.add("\"" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with money/currencies, a one liner to maintain the decimal point v_SalesAmount...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
yields 15-Apr-2020 17:00:00 Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Additional The reverse...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} input.Selected_Value = input.Calendar_Day_Select; v_DateOffset = m_Offset.get(input.Calendar_Day_Select.replaceAll("[^0-9]","")); // // if a number was selected, ie. not chevrons if(v_DateOffset >= 0) { // // set selected date field value...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1); v_FilenameFormatted = v_FilenameDetected.replaceAll("_"," "); row.Document_Name=v_FilenameFormatted; } } And finally, with a bit of CSS, this is what the end product looks like:
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
info "EBAY ORDER XML:"; if(b_DebugMode) { l_DebugMessages.add("EBAY ORDER XML: " + r_ResponseXMLOrder.replaceAll(">",">").replaceAll("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
than once if(v_Frequency > 1) { // // replace apostrophes with double apostrophe for coql v_SearchName = v_ProductName.replaceAll("'","''",true); // v_KeepID = 0; // // get other products with the same name (set in order of oldest first and keep only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *