Sponsored Content
Top Forums Shell Programming and Scripting Replace semicolon within double quotes in a file with semicolon delimiter Post 302968527 by RudiC on Thursday 10th of March 2016 09:27:11 AM
Old 03-10-2016
Please use code tags as required by forum rules!

This problem has been solved several times before. Are you sure you searched theses fora? However, try
Code:
awk -F\" '{for (i=2; i<=NF; i+=2) gsub (/;/, " ", $i)} 1' OFS=\" file
"TRP";037;5;"EDA";"Paper and Paperboard";"""for production  not including office supplies. Pulp molded"

This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

put a semicolon at the end of each line of a file

hi, Consider there is a file containing 200 lines. please let me know which command is to be used to put a semicolon at the end of each line. if no single command is there then how it can be achieved. (1 Reply)
Discussion started by: surjyap
1 Replies

2. Shell Programming and Scripting

Removing commas within semicolon in a flat file

Hi , Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it .. INPUT ==== filed1,field2,field3,"fie,ld4" OUTPUT ===== field1,field2,field3,"field4" can anyone tell me how to achieve... (10 Replies)
Discussion started by: r_t_1601
10 Replies

3. Shell Programming and Scripting

Removing commas within semicolon in a flat file

i am recieving a flat file ( comma seperated ) with comma in between double quotes in any of the source fields . i need to remove the comma in double quotes and process the file thereafter fields in file ========= col1,col2,col3,col4 input can be any of the followng... (31 Replies)
Discussion started by: r_t_1601
31 Replies

4. Shell Programming and Scripting

Replace blank spaces with semicolon - text file

Hi all, Been trying to find a solution to this, I'm sure its a sed 1 liner, but I don't know sed well enough to work it out... I have a text file in the following format: 431 666 1332 2665 0.24395 432 670 ... (3 Replies)
Discussion started by: mpcengineering
3 Replies

5. Shell Programming and Scripting

Extract semicolon separated delimiter

The log reads as follows. fname1;lname1;eid1;addr;pincode1; fname2;lname2;eid2;addr2;pincode2; fname3;lname3;eid3;addr3;pincode3; fname4;lname4;eid;addr4;pincode4; how do i extract only fname and save it in an array similarly for lname and so on i tried reading a file and cutting each... (5 Replies)
Discussion started by: vkca
5 Replies

6. Shell Programming and Scripting

Replace a string after n semicolon every line

I have a file that is formatted in this way. a1;b2;c33;d4;e5;e;f;f;f;s d;ds;d;a;v;b;g;gr;r;rt;fdf s1;s2;s2;s3;s4; b1;f2;g3;h4;a3c4e;xcsd;fds; sd2;fs4;fs2;sdf3; I want to replace the value just before the 4th semicolon to empty string, regardless the value, such that it looks... (3 Replies)
Discussion started by: alienated
3 Replies

7. Shell Programming and Scripting

Replace dot with semicolon in PERL

Hi, I have a file in PERL in the following pattern filename| 06-Dec-11 03.04.14.000000 PM filename1| 06-Dec-11 05.05.14.000000 PM I need to replace .(dot) with :(semicolon) in the timestamp value of the file How can this be done. Any help will be appreciated Thanks in advance (5 Replies)
Discussion started by: irudayaraj
5 Replies

8. UNIX for Dummies Questions & Answers

Delete a semicolon and numbers after a semicolon

I have this: ((9:0.010,(11:0.089,13:0.004)) and I would like this: ((A9,(A11,A13)) How do I delete the semi colon and the number (i.e. 0.010) after the semi colon? Also, how can I add the letter before the number that is NOT removed? Thank you in advance! ---------- Post updated... (4 Replies)
Discussion started by: MDeBiasse
4 Replies

9. Shell Programming and Scripting

SUM semicolon-seperated values from txt-file

Hello, (I'm a shell beginner) how can I sum the bold values of the following txt-file (values.txt) with bash shell. The result of the sum should be written in a new txt file (sum.txt): ... Thanks in advance (5 Replies)
Discussion started by: milu
5 Replies

10. 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
Mail::SpamAssassin::Plugin::ReplaceTags(3pm)		User Contributed Perl Documentation	      Mail::SpamAssassin::Plugin::ReplaceTags(3pm)

NAME
Mail::SpamAssassin::Plugin::ReplaceTags - tags for SpamAssassin rules The plugin allows rules to contain regular expression tags to be used in regular expression rules. The tags make it much easier to maintain complicated rules. Warning: This plugin relies on data structures specific to this version of SpamAssasin; it is not guaranteed to work with other versions of SpamAssassin. SYNOPSIS
loadplugin Mail::SpamAssassin::Plugin::ReplaceTags replace_start < replace_end > replace_tag A [a@] replace_tag G [gk] replace_tag I [il|!1y?xccxcdxcexcfxecxedxeexef] replace_tag R [r3] replace_tag V (?:[vu]|\/) replace_tag SP [s~_-] body VIAGRA_OBFU /(?!viagra)<V>+<SP>*<I>+<SP>*<A>+<SP>*<G>+<SP>*<R>+<SP>*<A>+/i describe VIAGRA_OBFU Attempt to obfuscate "viagra" replace_rules VIAGRA_OBFU RULE DEFINITIONS AND PRIVILEGED SETTINGS
replace_tag tagname expression Assign a valid regular expression to tagname. Note: It is not recommended to put quantifiers inside the tag, it's better to put them inside the rule itself for greater flexibility. replace_pre tagname expression Assign a valid regular expression to tagname. The expression will be placed before each tag that is replaced. replace_inter tagname expression Assign a valid regular expression to tagname. The expression will be placed between each two immediately adjacent tags that are replaced. replace_post tagname expression Assign a valid regular expression to tagname. The expression will be placed after each tag that is replaced. replace_rules list_of_tests Specify a list of symbolic test names (separated by whitespace) of tests which should be modified using replacement tags. Only simple regular expression body, header, uri, full, rawbody tests are supported. replace_start string replace_end string String(s) which indicate the start and end of a tag inside a rule. Only tags enclosed by the start and end strings are found and replaced. perl v5.14.2 2011-06-06 Mail::SpamAssassin::Plugin::ReplaceTags(3pm)
All times are GMT -4. The time now is 09:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy