Assuming comma is required, the following 24 results were found.
-
This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value. // What I have in CRM:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
( @StringValue ) END RETURN END And one more time for a more common purpose where it converts a string of words delimited by commas to a table: CREATE FUNCTION [dbo].[ufn_CommaStringToTable] ( @CommaSeparatedValues VARCHAR(MAX) ) RETURNS @OutputTable...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I have set the module by default to only search one area, but you can include multiple components by separating these with a comma. This parameter is a text field which uses the alias of the component (eg. "doc_indexer"), you would need to modify this...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
%v_BrowsedFolder% Return SelectExternal: FileSelectFile, v_SelectedExternalFile, 3, %A_MyDocuments%, Open a File, Comma Separated Values File (*.csv) if v_SelectedExternalFile != GuiControl,, MyExternalFile, %v_SelectedExternalFile% Return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
is "CRM" and not records with "Best CRM" or "Latest CRM" in their Campaign_Name fields. When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. Further, you must encode the value. Example: Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV - note that I am replacing commas with the HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
$term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return $term; } function search_split_terms($terms){ $terms = preg_replace("/\"(.*?)\"/e", "search_transform_term('\$1')", $terms);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file. CHANGELOG: Version 1.0 + This is version 1.0 unless people have suggestions I don't see the need to...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values (CSV) list of all data from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data file is...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
} Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings)....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in the database @SearchStr -- Provide the search string. Use...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
BEGIN -- Declare some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the second is what I want it to do: SELECT value FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges. ip_lookup.php: to use the database License.txt: Released under GNU/GPL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *