Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk and substr
Top Forums Shell Programming and Scripting awk and substr Post 302969783 by RavinderSingh13 on Monday 28th of March 2016 05:43:26 AM
Old 03-28-2016
Hello mystition,

Could you please try following and let me know if this works for you, though I haven't seen anything matching from your shown Input_file here.
Code:
awk -F, '{len=length($1);Q=substr($1,len-1);if(Q>=0 && Q<=15){print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File1.txt"};if(Q>=16 && Q<=25){print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File2.txt"};if(Q>=26 && Q<=40){print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File3.txt"}}'  Input_file

As your Input_file is not having any of the content matching to your requirement so I couldn't test it, if your requirement is not matching to above code please show us more Input_file with expected output too.
EDIT: Adding a non-one liner form for above solution as follows.
Code:
awk -F, '{
                len=length($1);
                Q=substr($1,len-1);
                if(Q>=0 && Q<=15){
                                        print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File1.txt"
                                 };
                if(Q>=16 && Q<=25){
                                        print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File2.txt"
                                 };
                if(Q>=26 && Q<=40){
                                        print "General" OFS $1 OFS "123,0" OFS $3 OFS "0" >> "File3.txt"
                                  }
         }
        '   Input_file

Thanks,
R. Singh
Last edited by RavinderSingh13; 03-28-2016 at 06:53 AM.. Reason: Added a non-one liner form of solution now.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk substr?

Sorry if this has been posted before, I searched but not sure what I really want to do. I have a file with records that show who has logged into my application: 2003-03-14:I:root: Log_mesg: registered servername:userid. (more after this) I want to pull out the userid, date and time into... (2 Replies)
Discussion started by: MizzGail
2 Replies

2. Shell Programming and Scripting

How to use awk substr ?

Hi all, I have a flatfile I would like to get ext = 7950 , how do I do that ? if ($1 == "CTI-ProgramStart") { ext = substr($9,index($9,"Extension")+11,4); But why it is not working ???? Please help . Thanks (1 Reply)
Discussion started by: sabercats
1 Replies

3. UNIX for Dummies Questions & Answers

awk or substr

i have a variable 200612 the last two digits of this variable should be between 1 and 12, it should not be greater than 12 or less than 1 (for ex: 00 or 13,14,15 is not accepted) how do i check for this conditions in a unix shell script. thanks Ram (3 Replies)
Discussion started by: ramky79
3 Replies

4. Shell Programming and Scripting

awk substr

Hi I have multiple files that name begins bidb_yyyymm. (yyyymm = current year month of file creation). What I want to do is look at the files and where yyyymm is older than 1 month I want to remove the file from the server. I was looking at looping through the files and getting the yyyymm... (2 Replies)
Discussion started by: colesga
2 Replies

5. UNIX for Dummies Questions & Answers

substr first element using awk

I have a variable '$test' that has the following string value: $test = 123|456|789|0123 How would I select just the first element ('123') using awk. Note: '|' is the delimiter, and the length of each field can vary. Thanks, - CB (3 Replies)
Discussion started by: ChicagoBlues
3 Replies

6. Shell Programming and Scripting

Help with awk and substr

I have the following to find lines matching "COMPLETE" and extract parts of it using substr. sed -n "/COMPLETE/p" 1.txt | awk 'BEGIN { FS = "\" } {printf"%s %s:%s \n", substr($3,17,3),substr($6,4,1), substr($7,4,1)}' | sort | uniq > temp.txt Worked fine until the numbers in 2nd & 3rd substr... (5 Replies)
Discussion started by: zpn
5 Replies

7. Shell Programming and Scripting

awk substr

HI I am using awk and substr function to list out the directory names in the present working directory . I am using below code ls -l | awk '{ if ((substr($1,1,1)) -eq d) {print $9 }}' But the problem is i am getting all the files and directories listed where as the requirement i wrote... (7 Replies)
Discussion started by: prabhu_kumar
7 Replies

8. Shell Programming and Scripting

Substr with awk

Hi to all, I'm here again, cause I need your help to solve another issue for me. I have some files that have this name format: date_filename.csv In my shell I must rename each file removing the date so that the file name is filename.csv To do this I use this command: fnames=`ls ${fname}|... (2 Replies)
Discussion started by: leobdj
2 Replies

9. Shell Programming and Scripting

awk substr

Hello life savers!! Is there any way to use substr in awk command for returning one part of a string from declared start and stop point? I mean I know we have this: substr(string, start, length) Do we have anything like possible to use in awk ? : substr(string, start, stop) ... (9 Replies)
Discussion started by: @man
9 Replies

10. Shell Programming and Scripting

HELP : awk substr

Hi, - In a file test.wmi Col1 | firstName | lastName 4003 | toto_titi_CT- | otot_itit - I want to have only ( colones $7,$13 and $15) with code 4003 and 4002. for colone $13 I want to have the whole name untill _CT- or _GC- 1- I used the command egrep with awk #egrep -i... (2 Replies)
Discussion started by: georg2014
2 Replies

LEARN ABOUT DEBIAN

rdup-up

RDUP-UP(1)							       rdup								RDUP-UP(1)

NAME

       rdup-up - update a directory tree with a rdup archive

SYNOPSIS

       rdup-up [OPTION]...  DIRECTORY

DESCRIPTION

       With rdup-up you can update an (possibly) existing directory structure with a rdup archive.

       The rdup archive has to be given to rdup-up's standard input.

   Username and uids
       rdup  outputs  both  the  username  and	uid, the receiving system (which may be a totally different system) checks if the username and uid
       match. If the username and uid don't match the (numeric) uid is used on the file. The same holds true for the groupname and gid.

OPTIONS

       -n     Do a dry-run and do not create anything on disk.

       -t     Create DIRECTORY (ala mkdir -p) if it does not exist.

       -s N   Strip N path components from a pathname. If the resulting pathname is empty after this operation it is skipped. Be  careful  however
	      with the following structure:

		  /foo
		  /foo/bar
		  /foo/bar/bla.txt
		  /foo/blork/bla.txt

	      With rdup-up -s2 this will leave:

		  <empty>
		  <empty>
		  /bla.txt
		  /bla.txt

	      And the last 'bla.txt' will overwrite the previous one, this will happen without warnings.

       -r PATH
	      This option is related to the -s option, but works different. The string PATH is removed from (the beginning of) each pathname. With
	      -r /home/backup the pathname /home/backup/bin/mycmd becomes /bin/mycmd. The same could be done with -s 2, but then you need to count
	      the slashes. Note -s is always performed before -r.

       -v     Be more verbose and echo the processed files to standard output.

       -vv    Be even more verbose and echo processed file and the uid and gid information to standard output.

       -T     Show  a  table  of  contents of the rdup stream received (ala tar -tf -).  With -T the directory argument is optional. -T unsets any
	      verbose (-v) options.

       -h     A short help message.

       -V     Show the version.

EXIT CODE

       rdup-up return a zero exit code on success, otherwise 1 is returned.

AUTHOR

       Written by Miek Gieben.

REPORTING BUGS

       Report bugs to <miek@miek.nl>.

SEE ALSO

       http:/www.miek.nl/projects/rdup/ is the main site of rdup. Also see rdup(1), rdup-tr(1) and rdup-backups(7).

COPYRIGHT

       Copyright (C) 2005-2010 Miek Gieben. This is free software. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A	PARTICULAR
       PURPOSE.

       Licensed under the GPL version 3. See the file LICENSE in the source distribution of rdup.

1.1.11								    13 Dec 2008 							RDUP-UP(1)
All times are GMT -4. The time now is 01:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy