Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Delete only commas in a string in AWK Post 302677263 by agama on Wednesday 25th of July 2012 09:23:29 PM
Old 07-25-2012
Your gsub() function call looks correct to me. You might want to post your programme, and possibly going into more detail about where exactly you are still seeing the commas.

What is the output if you run the simple command below?
Code:
echo "h,e,l,l,o, world" | awk '{gsub( /,/, "", $1 ); print}'

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Inserting commas and replacing backslashes with commas

Hi, Newbie here. I have a file that consists of data that I want to convert to a csv file. For example: Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105 Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Discussion started by: kangaroo
3 Replies

2. Shell Programming and Scripting

Help with removing additional commas in string

Hi Experts, I have below strings hello,hi,,,,,,start date age,code,,,,,61,season I am trying to format this string to hello,hi,start date age,code,61,season Can anyone please help me in achieving this? Kind Regards, RB (3 Replies)
Discussion started by: ramakanth_burra
3 Replies

3. 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

4. Shell Programming and Scripting

delete string using AWK

inputfile has 3 columns SCHEMA.TAB1 COL1 LENGTH SCHEMA.TAB2 COL2 LENGTH. If i use awk on the above inputfile awk '{print $1}' inputfile.The out put will be SCHEMA.TAB1 SCHEMA.TAB2. But from the above output i need to delete SCHEMA. i.e i don't want the string "SCHEMA." should... (6 Replies)
Discussion started by: rocking77
6 Replies

5. Shell Programming and Scripting

Get string between quotes separate by commas

I'm a beginner with shell and tried to do this per hours and everytinhg gives different want i do. So I have a lot of file in *.csv ( a.csv, b.csv ...) in each file csv , it has some fields separeted by commas. ----- "joseph";"21","m";"groups";"j.j@gmail.com,j.j2@hotmail.com"... (6 Replies)
Discussion started by: flaviof
6 Replies

6. Shell Programming and Scripting

Find number in string and delete it AWK

Hi all, i have some logs on my linux server that looks like this: CDR.2012-04-30:30-04-2012 14:09:36;123456456654;A;Greetings! Your amount is 42.24 dollars (without VAT) until 30/04/2012 11:00. CDR.2012-04-30:30-04-2012 14:09:36;12154878454212;A;Greetings! Your amount is 4203.2 dollars... (2 Replies)
Discussion started by: arrals_vl
2 Replies

7. Shell Programming and Scripting

awk delete line if $5 contains string from list

(5 Replies)
Discussion started by: chrisjorg
5 Replies

8. Shell Programming and Scripting

How to delete the commas in a .CSV file that are enclosed in a string with double quotes?

Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote. Please see the sample file as below: column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
Discussion started by: dhruuv369
8 Replies

9. Shell Programming and Scripting

Remove rows containing commas with awk

Hello everyone, I have a dataset that looks something like: 1 3 2 2 3 4,5 4 3:9 5 5,9 6 5:6 I need to remove the rows that contain a comma in the second column and I'm not sure how to go about this. Here is an attempt. awk 'BEGIN {FS=" "} { if ($2!==,) print }'Any help is appreciated. (5 Replies)
Discussion started by: Rabu
5 Replies

10. Shell Programming and Scripting

Print commas between awk output

When I output fields 1 2 4 5 & 6, I would like to have a comma between them but I am beating my head against the wall to get it to work. Any help is appreciated sed 's/]*,]*/,/g' file1 > file1.$$ && awk -F, 'FNR==NR{f2=$1 $2 $4 $5 $6;next} FNR==1{print $0, "CDP NE Hostname,CDP NE IP,Remote... (6 Replies)
Discussion started by: dis0wned
6 Replies
TV_GREP(1p)						User Contributed Perl Documentation					       TV_GREP(1p)

NAME
tv_grep - Filter programmes and channels from an XMLTV listings file. SYNOPSIS
"tv_grep [--help] [--output FILE] [--ignore-case|-i] (EXPR | REGEXP) [FILE...]" DESCRIPTION
Reads XMLTV listings data and writes out data containing some of the programmes and channels from the original. Which programmes and channels are left in the output is controlled by the regexp or Boolean expression given. Simple usage is tv_grep REGEXP [FILE...], where REGEXP is a Perl 5 regular expression (see perlre(1)). This finds all <programme> elements containing text matching the regexp. The channels are left unchanged, that is, all the <channel> elements are output. For more advanced searches, you can specify a Boolean expression (which loosely follows the style of find(1)). There are many tests for matching programme content against a regular expression, a few for matching channels and programmes on those channels, and a few special tests. OPTIONS
--output FILE write to FILE rather than standard output. --ignore-case, -i treat all regular expression matches as case insensitive. EXPRESSIONS
PROGRAMME CONTENT TESTS The tests for programme content match against particular attributes or subelements of the <programme> element in the XML data. Each test is named the same as the attribute or element it matches. Those which take a regexp as an argument match if the programme contains at least one attribute or element of the same name whose content matches the regexp. Those which do not take a regexp match if the programme simply contains one or more attributes or elements of that name. Some elements may or may not have content - they may just be empty. The regular expression '' (the empty string) matches any element, even one with empty content, while a nonempty regular expression matches only those with content. For example, --desc Racing matches a programme if the programme has at least one <desc> element whose content contains 'Racing'. --stop '' (the second argument is the empty string) matches a programme if the programme gives a stop time. There are some elements where only yes/no matching is possible, where you cannot give a regexp to query the element's content. For these the second '' argument is mandatory. For example --previously-shown '' will match programmes which have that element, but a test of --previously-shown foo will give an error because querying the content of previously-shown is not implemented. The additional empty-string argument is to leave room for future expansion. The content tests are generated from the XMLTV file format. The current set of programme content tests is: --audio '' --category REGEXP --channel REGEXP --clumpidx REGEXP --country REGEXP --credits '' --date REGEXP --desc REGEXP --episode-num '' --icon '' --language REGEXP --last-chance REGEXP --length '' --new --orig-language REGEXP --pdc-start REGEXP --premiere REGEXP --previously-shown '' --rating '' --showview REGEXP --star-rating '' --start REGEXP --stop REGEXP --sub-title REGEXP --subtitles '' --title REGEXP --url REGEXP --video '' --videoplus REGEXP --vps-start REGEXP While every attribute and subelement of <programme> elements is included in the above list, for some of them it is normally more convenient to use the special tests described below. CHANNEL TESTS There are two tests for channels. These filter both <programme> and <channel> elements: if a channel is filtered out then all programmes on that channel are too. --channel-name REGEXP True if the channel has a <name> whose content matches REGEXP. --channel-id CHANNEL_ID True if the channel's XMLTV id is exactly equal to CHANNEL_ID. TIME TESTS Normally you don't want to test time strings with a regular expression but rather compare them with some other time. There are two tests for this. --on-after DATE True if the programme will be broadcast at or after DATE, or will be part of the way through broadcasting at DATE. (Note: a programme is considered to be broadcasting from its start time, up to but not including its stop time.) DATE can be given in any sane date format; but if you don't specify the timezone then UTC is assumed. To remove all the programmes you have already missed, try --on-after now. --on-before DATE True if the programme will be broadcast wholly before DATE, or if it will be part of the way through broadcasting at DATE. To remove all the programmes that haven't yet begun broadcasting, try --on-before now. You can use --on-before and --on-after together to find all programmes which are broadcasting at a certain time. Another way of thinking about these two tests is that --on-after now gives 'all programmes you could possibly still watch, although perhaps only catching the end'. --on-before now gives 'all programmes you could possibly have seen, even if only the start'. --eval CODE Evaluate CODE as Perl code, use the return value to decide whether to keep the programme. The Perl code will be given the programme data in $_ in XMLTV.pm hash format (see XMLTV). The code can actually modify the programme passed in, which can be used for quick fixups. This option is not intended for normal use, but as an escape in case none of the existing tests is what you want. If you develop any useful bits of code, please submit them to be included as new tests. LOGICAL OPERATORS EXPR1 --and EXPR2, EXPR1 -and EXPR2, EXPR1 EXPR2 EXPR1 --or EXPR2, EXPR1 -or EXPR2 --not EXPR, -not EXPR, ! EXPR Of these, 'not' binds tightest, affecting the following predicate only. 'and' is next, and 'or' binds loosest. SEE ALSO
xmltv(5), perl(1), XMLTV(3). AUTHOR
Ed Avis, ed@membled.com BUGS
The --on-after test cannot be totally accurate when the input data did not give a stop time for a programme. In this case we assume the stop time is equal to the start time. This filters out more programmes than if the stop time were given. There will be a warning if this happens more than once on any single channel. It could be worthwhile to filter the listings data through tv_sort(1) beforehand to add stop times. Similar remarks apply to --on-before: if the stop time is missing we assume it is equal to the start time, and this can mean leaving in a programme which, if it had a stop time, would be removed. The assumption of UTC for dates without timezones could be considered a bug. Perhaps the user input should be interpreted according to the local timezone. OTOH, if the data has no timezones and neither does the user input, then things will work as expected. The simple usage is the only way to match against all a programme's content because some things (like <credits>) do not have programme content tests defined. It actually works by stringifying the whole programme and regexp matching that, which means that it could give wrong results for regular expressions containing quote characters or some punctuation symbols. This is not particularly likely to happen in practice. Some listings sources generate timeslots containing two or more programmes in succession. This is represented in XMLTV with the 'clumpidx' attribute. If tv_grep selects only some of the programmes from a clump, then it will alter the clumpidx of those remaining to make it consistent. This is maybe not ideal, perhaps the clumpidx should be left unchanged so it's obvious that something is missing, but at least it prevents complaints from other XMLTV tools about badly formed clumps. The clumpidx handling does mean that tv_grep is not always idempotent. perl v5.14.2 2012-06-30 TV_GREP(1p)
All times are GMT -4. The time now is 05:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy