using awk for setting variable but change the output of this variable within awk Post: 302546348

Sponsored Content

Top Forums Shell Programming and Scripting using awk for setting variable but change the output of this variable within awk Post 302546348 by Cowardly on Thursday 11th of August 2011 03:43:26 AM

08-11-2011

Registered User

Quote:

Originally Posted by dude2cool

here is a possible solution. You may have to tweak it to the input.

split($9,a,"/")
dept=a[2]

This is really good.. And it works as well Smilie

Many thanks!

Could you explain a bit more about the variable?
- What does the a mean in the split ?
- what does the [2] do in the variable ?

edit: Ok, done some google on it and this explains it pretty good:

Code:

split(string, array, fieldsep)
    This divides string into pieces separated by fieldsep, and stores the pieces in array.
    The first piece is stored in array[1], the second piece in array[2], and so forth. 
    The string value of the third argument, fieldsep, is a regexp describing where to split string (much as FS can be a regexp describing where to split input records).
    If the fieldsep is omitted, the value of FS is used. split returns the number of elements created. The split function, then,
    splits strings into pieces in a manner similar to the way input lines are split into fields. For example:

    split("auto-da-fe", a, "-")

    splits the string `auto-da-fe' into three fields using `-' as the separator. It sets the contents of the array a as follows:

    a[1] = "auto"
    a[2] = "da"
    a[3] = "fe"

again many thanks!

Still have to do some tweaking (as you said) because some Dirs have spaces in them..

Last edited by Cowardly; 08-11-2011 at 04:51 AM..

Cowardly

View Public Profile for Cowardly

Find all posts by Cowardly

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

setting environment variable in awk

Dear all, I have a data sample... Dose: Summed ROI: Bladder ************************** Bin Dose Volume 001 0.700 100.000 002 0.715 99.998 168 3.142 0.368 169 3.157 0.338 170 3.171 0.292 Dose: Summed ROI:...

2. Shell Programming and Scripting

setting a variable, using SSH and awk?

hi there I am trying to get a value from a remote machine into a local variable. To get this value i want to use awk but im having trouble getting it to run, am i escaping in the right places here and using the right quotes (i must have tried a million combinations :() # VAR=`ssh server1...

3. Shell Programming and Scripting

How to change awk and shell variable value?

In awk script, #!/bin/sh awk 'BEGIN{i=0;}{i=i+5;}END{print i}' in.txt vr=0; vr=$i; echo "$vr" How can i assign that value of i in $vr(variable) of shell script?

4. Shell Programming and Scripting

awk: Eliminating white space while setting variable

Hi, I have a large flat file from host without delimiter. I'm transforming this file to a csv file using statements like # Row 03: Customer / field position 3059 +20 WOFABNAM=substr( $0, 3059, 20 ); and deleting the trailing whitespaces before and after with that sub( /^ +/, "",...

5. Shell Programming and Scripting

awk: change string variable

Hi. How to change string variable in awk? for example, I parse with awk script text file named some_name_with_extension.txt I want to print only some_name in my script .... varCompName = FILENAME print varCompName How to put not all symbols from FILENAME to variable? thank you This...

6. Shell Programming and Scripting

setting a shell script variable in awk

The following is part of a larger shell script grep -v "Col1" my_test.log | grep -v "-" | awk '$5 == "Y" {print $1}' instead of printing, can I set set $1 to a variable that the rest of the shell script can read? if $5 == Y, I want to call another shell script and pass $1 as a...

7. Shell Programming and Scripting

help on awk---- need to assign the output of awk to a variable

hi i want to find the size of a folder and assign it to a variable and then compare if it is greater than 1 gb. i am doin this script, but it is throwing error.... #!/bin/ksh cd . | du -s | size = awk '{print $1}' if size >= 112000 then echo size high fi ERROR :

8. UNIX for Dummies Questions & Answers

awk - change variable on fly

Hello All, I have csv file, where one of fields is date (yyyy/mm/dd 00:00:00). Using awk I am trying to find all records with date newer/older than specific date. My idea was to compare unix timestamps of both dates: start=`date +%s -d "$DateStart"` awk -v start="$start" -v current=`date +%s...

9. Shell Programming and Scripting

awk question : system output to awk variable.

Hi Experts, I am trying to get system output to capture inside awk , but not working: Please advise if this is possible : I am trying something like this but not working, the output is coming wrong: echo "" | awk '{d=system ("date") ; print "Current date is:" , d }' Thanks,

10. Shell Programming and Scripting

awk - Removing extra character when setting variable

I have a data file d0 that looks like this: $cat d0 server1 running -n-cv- 8G 3.1% 1435d 15h server2 running -n---- 8G 39% 660d 22h server3 running -n--v- 8G 2.5% 1173d 6h server4 running -n---- 8G 1.1% 1048d 20h...

LEARN ABOUT MOJAVE

split

split(n)						       Tcl Built-In Commands							  split(n)

__________________________________________________________________________________________________________________________________________________

NAME

       split - Split a string into a proper Tcl list

SYNOPSIS

       split string ?splitChars?
_________________________________________________________________

DESCRIPTION

       Returns a list created by splitting string at each character that is in the splitChars argument.  Each element of the result list will con-
       sist of the characters from string that lie between instances of the characters in splitChars.  Empty list elements will  be  generated	if
       string contains adjacent characters in splitChars, or if the first or last character of string is in splitChars.  If splitChars is an empty
       string then each character of string becomes a separate element of the result list.  SplitChars defaults to the standard white-space  char-
       acters.

EXAMPLES

       Divide up a USENET group name into its hierarchical components:
	      split "comp.lang.tcl.announce" .
		    -> comp lang tcl announce

       See how the split command splits on every character in splitChars, which can result in information loss if you are not careful:
	      split "alpha beta gamma" "temp"
		    -> al {ha b} {} {a ga} {} a

       Extract the list words from a string that is not a well-formed list:
	      split "Example with {unbalanced brace character"
		    -> Example with {unbalanced brace character

       Split a string into its constituent characters
	      split "Hello world" {}
		    -> H e l l o { } w o r l d

   PARSING RECORD-ORIENTED FILES
       Parse a Unix /etc/passwd file, which consists of one entry per line, with each line consisting of a colon-separated list of fields:
	      ## Read the file
	      set fid [open /etc/passwd]
	      set content [read $fid]
	      close $fid

	      ## Split into records on newlines
	      set records [split $content "
"]

	      ## Iterate over the records
	      foreach rec $records {

		 ## Split into fields on colons
		 set fields [split $rec ":"]

		 ## Assign fields to variables and print some out...
		 lassign $fields 
		       userName password uid grp longName homeDir shell
		 puts "$longName uses [file tail $shell] for a login shell"
	      }

SEE ALSO

       join(n), list(n), string(n)

KEYWORDS

       list, split, string

Tcl																	  split(n)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

setting environment variable in awk

Discussion started by: tintin72

2. Shell Programming and Scripting

setting a variable, using SSH and awk?

Discussion started by: hcclnoodles

3. Shell Programming and Scripting

How to change awk and shell variable value?

Discussion started by: cola

4. Shell Programming and Scripting

awk: Eliminating white space while setting variable

Discussion started by: Celald