Sponsored Content
Top Forums Shell Programming and Scripting Replace characters in string with awk gsub Post 302886240 by Akshay Hegde on Thursday 30th of January 2014 08:32:18 AM
Old 01-30-2014
Whether like this ?

Code:
$ cat file
a,b,c,d,e,f,g,h,t,DISTI(USD),MSRP(USD),DIST(EUR),MSRP(EUR),EMEA-DISTI(USD),EMEA-MSRP(USD),GLOBAl-DISTI(USD),GLOBAL-MSRP(USD),DISTI(GBP), MSRP(GBP)

Code:
$ awk 'NR==1{gsub(/\(/,",");gsub(/\)/,x)}1' file

Resulting
Code:
a,b,c,d,e,f,g,h,t,DISTI,USD,MSRP,USD,DIST,EUR,MSRP,EUR,EMEA-DISTI,USD,EMEA-MSRP,USD,GLOBAl-DISTI,USD,GLOBAL-MSRP,USD,DISTI,GBP, MSRP,GBP

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace characters in a string using their ascii value

Hi All, In the HP Unix that i'm using when i initialise a string as Stalled="'30¬G'" Stalled=$Stalled" '30¬C'", it is taking the character ¬ as a comma. I need to grep for 30¬G 30¬C in a file and take its count. But since this character ¬ is not being understood, the count returns a zero. The... (2 Replies)
Discussion started by: roops
2 Replies

2. Shell Programming and Scripting

search and replace characters in one string

I have lines like: Dog Cat House Mouse Dog Cat House Mouse Dog Cat House Mouse Dog Cat House Mouse I'd like to replace characters only in $3. H -> Z s -> W e -> x Resulting in something like (where $1, $2, and $4 are not changed): Dog Cat ZouWx Mouse Dog Cat ZouWx Mouse... (3 Replies)
Discussion started by: dcfargo
3 Replies

3. Shell Programming and Scripting

gsub in Awk to capture count of replaced characters

Hi , I am working on a script to replace special characters in ASCII file with '?'. We need to get count of replaced characters from file. I am new to Awk and i read, # The gsub function returns the number of substitutions made. I was trying to replace characters with below... (10 Replies)
Discussion started by: Akshay
10 Replies

4. Shell Programming and Scripting

awk and gsub - how to replace only the first X occurrences

I have a text (text.txt) and I would like to replace only the first 2 occurrences of a word (but I might need to replace more): For example, if text is this: CAR sweet head hat red yellow CAR book brown tiger CAR cow CAR CAR milk I would like to replace the word "CAR" with word... (12 Replies)
Discussion started by: bingel
12 Replies

5. Shell Programming and Scripting

Using of gsub function in AWK to replace space by underscore

I must design a UNIX script to monitor files whose size is over a threshold of 5 MB in a specific UNIX directory I meet a problem during the for loop in my script. Some file names contain spaces. ls -lrt | awk '$5>=5000000 && length($8)==5 {gsub(/ /,"_",$9); print};' -rw-r--r-- 1 was61 ... (2 Replies)
Discussion started by: Scofield38
2 Replies

6. Shell Programming and Scripting

awk + gsub to search multiple input values & replace with located string + extra text

Hi all. I have the following command that is successfully searching for any one of the strings on all lines of a file and replacing it with the instructed value. cat inputFile | awk '{gsub(/aaa|bbb|ccc|ddd/,"1234")}1' > outputFile This does in fact replace any occurrence of aaa, bbb,... (2 Replies)
Discussion started by: dazhoop
2 Replies

7. Shell Programming and Scripting

Search & replace content using awk/gsub

Hi, I have two files master.txt & reference.txt. Sample below Master.txt 2372,MTS,AP 919848001104,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 Reference.txt 2372,919848701430,46467 919848002372,2372,47195 2372,919849788001,59027 0819,028803,1 0819,029801,1... (2 Replies)
Discussion started by: siramitsharma
2 Replies

8. Shell Programming and Scripting

Search & Replace content of files using gsub in awk

Hi,I have 2 files master.txt & reference.txt as shown below & i require o/p as mentioned in file 3 using awk but content is not replacing properlymaster.txt:... (15 Replies)
Discussion started by: siramitsharma
15 Replies

9. Shell Programming and Scripting

Help to replace the string with special characters

{"name":"alR_pl-ENVIRONMENT_192_168_211_123_sDK_PROVISION_7","description":"aLR_pl-ENVIRONMENT_192_168_211_123_sDK_PROVISION_7","json_class":"Chef::Role","default_attributes":{},"override_attributes":{"yoapp":{"jboss":"5.1.0","port":"2243","warname":"soap","datacenter":"alR","ip":"192.168.211.123","... (3 Replies)
Discussion started by: nikhil jain
3 Replies

10. Shell Programming and Scripting

awk gsub command to replace multiple spaces

Hi Forum. I'm trying to cleanup the following data elements (To remove any occurences of commas and any extra spaces) while preserving the <TAB> delimiter using awk gsub but I have not been successful. Original Data: 4365 monte des source rue,, ,<TAB>trevost<TAB>QC Desired Data:... (1 Reply)
Discussion started by: pchang
1 Replies
GNC-FQ-HELPER(1)					User Contributed Perl Documentation					  GNC-FQ-HELPER(1)

NAME
gnc-fq-helper - allows gnucash to communicate with Finance::Quote over pipes from guile. The requests and responses are scheme forms. SYNOPSIS
gnc-fq-helper DESCRIPTION
Input: (on standard input - one entry per line and one line per entry, and double quotes must only be delimiters, not string content -- remember, we don't have a real scheme parser on the perl side :>). (<method-name> symbol symbol symbol ...) where <method-name> indicates the desired Finance::Quote method. The currently recognized subset is yahoo, yahoo_europe, fidelity_direct, troweprice_direct, vanguard, asx, tiaacref, and currency. For currency quotes, the symbols alternate between the 'from' and 'to' currencies. For example: (yahoo "IBM" "LNUX") (fidelity_direct "FBIOX" "FSELX") (currency "USD" "AUD") Output (on standard output, one output form per input line): Schemified version of gnc-fq's output, basically an alist of alists, as in the example below. Right now, only the fields that this script knows about (and knows how to convert to scheme) are returned, so the conversion function will have to be updated whenever Finance::Quote changes. Currently you'll get symbol, gnc:time-no-zone, and currency, and either last, nav, or price. Fields with gnc: prefixes are non-Finance::Quote fields. gnc:time-no-zone is returned as a string of the form "YYYY-MM-DD HH:MM:SS", basically the unmolested (and underspecified) output of the quote source. It's up to you to know what it's proper timezone really is. i.e. if you know the time was in America/Chicago, you'll need to convert it to that. For example: $ echo '(yahoo "CSCO" "JDSU" "^IXIC")' | ./gnc-fq-helper (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 20.375) (currency . "USD")) ("JDSU" (symbol . "JDSU") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 23.5625) (currency . "USD")) ("^IXIC" (symbol . ^IXIC) (gnc:time-no-zone . 2002-12-04 17:16:00) (last . 1430.35) (currency . failed-conversion))) On error, the overall result may be #f, or on individual errors, the list sub-item for a given symbol may be #f, like this: $ echo '(yahoo "CSCO" "JDSU")' | ./gnc-fq-helper (#f ("JDSU" (symbol . "JDSU") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 23.5625) (currency . "USD"))) further, errors may be stored with each quote as indicated in Finance::Quote, and whenever the conversion to scheme data fails, the field will have the value 'failed-conversion, and accordingly this symbol will never be a legitimate conversion. Exit status 0 - success non-zero - failure perl v5.14.2 2013-01-03 GNC-FQ-HELPER(1)
All times are GMT -4. The time now is 11:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy