RemoveCommasBetweenQuotes Function

Removes the commas that are between quotes for a string. A comma separated string value read in from a file could have fields that are encased in quotes, and within that they may have additional commas. In order to use the GetField function on this string, it is necessary to remove the commas from between the quotes. This function will also remove the quotes, since they are not required anymore. The GetField function will read each value as a string, and convert numbers to numbers if necessary. See also the RemoveNonDigits function to remove $ signs and other non digits from number strings.

Syntax

RemoveCommasBetweenQuotes( inputString )

Parameters

Examples

The following examples illustrate the use of the RemoveCommasBetweenQuotes  function:

stringValue = '10,20,30,"40,000",50,60'

RemoveCommasBetweenQuotes( stringValue )

stringValue is now '10,20,30,40000,50,60'