Assuming commas is required, the following 12 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: *
-
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: {"My_MultiPicklist":["Option1","Options...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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
-
file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_MyString.replaceAll("\b(Posh)([^ ]*)","$1 and $2",false); // yields Posh and David Beckham UK/US Decimal Separator and Commas: v_MyString = 1234.567; v_FormattedString = (v_MyString.round(2)).toString().replaceAll(("(?Link"; v_FormattedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
!= 0) { v_QuoteTotalGBP = (v_QuoteTotal.toDecimal() / v_ExchangeRate).toDecimal().round(2); // // format currency with commas (thousand separator) and 2 decimals v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" + v_QuoteRef...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= 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); info v_TimeZone;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- 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: *
-
@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
-
d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers)
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB