Sponsored Content
Top Forums Shell Programming and Scripting How to delete the commas in a .CSV file that are enclosed in a string with double quotes? Post 302887702 by dhruuv369 on Monday 10th of February 2014 10:34:47 AM
Old 02-10-2014
@in2nix4life: The code works great, however, I will really appreciate if you could please help me understand the for condition? like, why was the i assigned 2 as the initial value and also, the variable was assigned at the beginning of the awk, and how is this used in the later part of the code?
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to remove a character which is enclosed in Double quotes

I want to remove the comma which is present within the double quoted string. All other commas which is present outside double quotes should be present. Input : a,b,"cc,dd,ee",f,ii,"jj,kk",mmm output : a,b,"ccddee",f,ii,"jjkk",mmm (3 Replies)
Discussion started by: mohan_tuty
3 Replies

2. Shell Programming and Scripting

how to find the count of commas in a string excluding the ones in double quotes

Hi, my requirement is to find the count of commas in a string excluding the ones in double quotes. For example: If the input string is abc,xyz.com,lmhgdf,"abc, 401 street","tty,stt",45,23,45 The output should be 7 (7 Replies)
Discussion started by: amitshete
7 Replies

3. Shell Programming and Scripting

HELP with AWK or SED. Need to replace the commas between double quotes in CSV file

Hello experts, I need to validate a csv file which contains data like this: Sample.csv "ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0 "ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0 I just need to check if all the records contain exactly the number of... (5 Replies)
Discussion started by: shell_boy23
5 Replies

4. Shell Programming and Scripting

How to delete a column/columns of a CSV file which has cell values with a string enclosed in " , "?

How can I delete a column from a CSV file which has comma separated value with a string enclosed in double quotes and a comma in between? I have a file 44.csv with 4 lines including the header like the below format: column1, column2, column3, column 4, column5, column6 12,455,"string with... (6 Replies)
Discussion started by: dhruuv369
6 Replies

5. Shell Programming and Scripting

How to delete a columns of a CSV file which has cell values with a string enclosed in " , "?

Hi How can I delete a columns from a CSV file which has comma separated value with a string enclosed in double quotes or square bracket and a comma in between? I have a csv file with below format. Template,Target Server,Target Component,Rule Group,Rule,Rule Reference Number,Rule... (7 Replies)
Discussion started by: Litu19
7 Replies

6. Shell Programming and Scripting

How to match fields surrounded by double quotes with commas?

Hello to all, I'm trying to match only fields surrounded by double quotes that have one or more commas inside. The text is like this "one, t2o",334,"tst,982-0",881,"kmk 9-l","kkd, 115-001, jj-3",5 The matches should be "one, t2o" "tst,982-0" "kkd, 115-001, jj-3" I'm trying with... (11 Replies)
Discussion started by: Ophiuchus
11 Replies

7. Shell Programming and Scripting

Shell script that should remove unnecessary commas between double quotes in CSV file

i have data as below 123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi" i need an output to be 123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies

8. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

Hi All, I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes. Sample Data : "221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies

9. Shell Programming and Scripting

Remove pipe(|) symbol ina file, except the ones which are enclosed in double quotes

I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes. If your quote file is: |Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|" It should return: Life is Beautiful"|"Indeed life is... (1 Reply)
Discussion started by: Sathyapts
1 Replies

10. Shell Programming and Scripting

Remove pipe(|) symbol in except the ones which are enclosed in double quotes

I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes. If your quote file is: |Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|" It should return: Life is Beautiful"|"Indeed life is... (9 Replies)
Discussion started by: Sathyapts
9 Replies
vc(1)							      General Commands Manual							     vc(1)

NAME
vc - substitutes assigned values in place of identification keywords. SYNOPSIS
char] [keyword=value ... keyword=value] DESCRIPTION
The or version control command copies lines from the standard input to the standard output under control of command line arguments and con- trol statements encountered in the standard input. In the process of performing the copy operation, user declared keywords can be replaced by their string value when they appear in plain text and/or control statements. The copying of lines from the standard input to the stan- dard output is conditional, based on tests of keyword values specified in control statements or on command arguments. Replacement of keywords by values is done whenever a keyword surrounded by control characters is encountered on a version control state- ment. The option forces replacement of keywords in all lines of text. An uninterpreted control character can be included in a value by preceding it with If a literal is desired, it too must be preceded by The command is part of the SCCS (Source Code Control System) command suite. Options recognizes the following options and arguments: Replace keywords surrounded by control characters with their assigned value in all text lines and not just in statements. Ignore all characters from the beginning of a line up to and including the first tab character for the purpose of detecting a control statement. If one is found, all char- acters up to and including the tab are discarded. Specify a control character to be used in place of Silence warning messages (not errors) that are normally printed on the diagnostic output. Control Statements A control statement is a single line beginning with a control character, and the default control character is colon (Unless the and options are used [See above]). Input lines beginning with a backslash followed by the control character are not control lines, and are copied to the standard output with the backslash removed. Lines beginning with a backslash followed by a non-control character are copied in their entirety. A keyword is composed of 9 or fewer alphanumeric characters of which the first character is alphabetic. A value is any ASCII string that can be created using (see ed(1)); a numeric value is an unsigned string of digits. Keyword values must not contain spaces or tabs. Version control statements occur in the following forms: :dcl keyword[, ..., keyword] Used to declare keywords. All keywords must be declared. :asg keyword=value Used to assign values to keywords. An statement overrides the assignment for the corresponding keyword on the command line and all previous for that keyword. Keywords declared, but not assigned values have null values. Used to skip lines of the standard input. If the condition is true, all lines between the if statement and the matching end statement are copied to the standard output. If the condition is false, all intervening lines are discarded, including control statements. Note that intervening if statements and matching end statements are recognized solely for the purpose of maintain- ing the proper if-end matching. The syntax of a condition may include the following: <cond> ::= [ "not" ] <or> <or> ::= <and> | <and> "|" <or> <and> ::= <exp> | <exp> "&" <and> <exp> ::= "(" <or> ")" | <value> <op> <value> <op> ::= "=" | "!=" | "<" | ">" <value> ::= <arbitrary ASCII string> | <numeric string> The following are available operators and their meanings: equal not equal and or greater than less than used for logical groupings allowed only immediately after the if, and when present, inverts the value of the entire condition The and operate only on unsigned integer values (such as is false). All other operators take strings as arguments (for example, is true). The precedence of the operators (from highest to lowest) is as follows: all of equal precedence Parentheses can be used to alter the order of precedence. Values must be separated from operators or parentheses by at least one space or tab. Used for keyword replacement on lines that are copied to the standard output. The two leading control characters are removed, and keywords surrounded by control characters in text are replaced by their value before the line is copied to the output file. This action is independent of the option. Turn on or off keyword replacement on all lines. Change the control character to char. Prints the given message on the diagnostic output. Prints the given message followed by: on the diagnostic output. halts execution and returns an exit code of 1. EXTERNAL INFLUENCES
Environment Variables determines the interpretation of keywords, values, the control character assigned through and within text as single- and/or multi-byte characters. determines the language in which messages are displayed. If is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty vari- able. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See environ(5). RETURN VALUE
returns 0 on normal completion; 1 if an error occurs. DIAGNOSTICS
Use sccshelp(1) for explanations. SEE ALSO
ed(1), sccshelp(1). vc(1)
All times are GMT -4. The time now is 07:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy