Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Regarding cut or awk command

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Regarding cut or awk command
# 1  
Old 07-16-2012
Regarding cut or awk command
Hi,

I need a help with cut/awk command. I need to get certain values from a string provided. For example: i have a config file with below mentioned details
oracle="user=name"/"pass/word"@databasename.

I have used a command var1=`grep -w oracle sample.cfg | cut -d"=" -f2 | cut -d"/" -f1`.

However, the above command gives me a value "name". Could you pls help me get the output as mentioned below-
var1="user=name"
var2="pass/word"
var3=databasename.

Thanks in advance for the reply!
# 2  
Old 07-16-2012
I would suggest you to use " as a delimiter for awk Smilie
This User Gave Thanks to PikK45 For This Post:
kumars2102
# 3  
Old 07-16-2012
Hi..actually i have given double quotes just to make sure that folks here understand its a single word..actual string is

oracle=user=name/pass/word@databasename
# 4  
Old 07-16-2012
Try...
Code:
$ echo 'oracle=username/password@database' > sample.cfg

$ set -- $(awk -F '[=/@]' '/oracle/{print $2,$3,$4}' sample.cfg)

$ echo user is $1, pass is $2, db is $3
user is username, pass is password, db is database

$

This User Gave Thanks to Ygor For This Post:
kumars2102
# 5  
Old 07-16-2012
What confused here is "user=name" !!! Smilie

@Ygor: How do you intend to tackle this?
# 6  
Old 07-16-2012
Hi Ygor,

thanks for ur reply. I am facing issues when i have a delimiter as a part of username or password. if i use the command provided by you or command posted by me originally gives me improper values. For example my string is
echo 'oracle=user=name/pa/ssword@database'

so the output should be
$1 = user=name
$2 = pa/ssword
$3 = database

can we achieve this?
# 7  
Old 07-16-2012
Try...
Code:
$ echo 'oracle=user=name/pa/ssword@database' > sample.cfg

$ eval $(awk '/oracle/{
      if(match($0,/=[^/]*/))
          printf "user=\047%s\047\n", substr($0,RSTART+1,RLENGTH-1)
      if(match($0,/\/.*@/))
          printf "pass=\047%s\047\n", substr($0,RSTART+1,RLENGTH-2)
      if(match($0,/@.*/))
          printf "db=\047%s\047\n", substr($0,RSTART+1,RLENGTH-1)
    }' sample.cfg)

$ echo user is $user, pass is $pass, db is $db
user is user=name, pass is pa/ssword, db is database

$

This User Gave Thanks to Ygor For This Post:
kumars2102
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use cut output as variable piped awk command

Hi, I would like use the output of my cut command as a variable in my following awk command. Here's what I've written. cut -f1 info.txt | awk -v i=xargs -F'' '{if($6 == $i) print $20}' summary.txt Where obviously the 'xargs' doesn't do what I want. How can I pass my cut result to my awk... (3 Replies)
Discussion started by: heyooo
3 Replies

2. Shell Programming and Scripting

Problem in extracting data using cut/awk command

Hi Everyone, I have a very simple problem and i am stuck in that from last 8 days. I tried many attempts, googled my query but all in vain. I have a text file named "test.txt" In that suppose i have contents like: Java: 1 Object oriented programming language 2 Concepts of Abstraction... (5 Replies)
Discussion started by: Abhijeet Anand
5 Replies

3. UNIX for Beginners Questions & Answers

Cut command: can't make it cut fields

I'm a complete beginner in UNIX (and not a computer science student either), just undergoing a tutoring course. Trying to replicate the instructions on my own I directed output of the ls listing command (lists all files of my home directory ) to My_dir.tsv file (see the screenshot) to make use of... (9 Replies)
Discussion started by: scrutinizerix
9 Replies

4. Shell Programming and Scripting

Storing command output in a variable and using cut/awk

Hi, My aim is to get the md5 hash of a file and store it in a variable. var1="md5sum file1" $var1 The above outputs fine but also contains the filename, so somthing like this 243ASsf25 file1 i just need to get the first part and put it into a variable. var1="md5sum file1"... (5 Replies)
Discussion started by: JustALol
5 Replies

5. Shell Programming and Scripting

Help with cut or awk command

i am trying to cut the 4th field from the file. sample file a1,a2,"a,3",a4,a5,a6 b1,"b,2",b3,b4,b5,b6 c1,"c,2","c,3",c4,c5,c6 i need the output in the format of a1,a2,"a,3",a5,a6 b1,"b,2",b3,b5,b6 c1,"c,2","c,3",c5,c6 i tried using cut -d, -f1-4,6- but i am getting the output as ... (10 Replies)
Discussion started by: ATWC
10 Replies

6. UNIX for Dummies Questions & Answers

Cut pid from ps using cut command

hay i am trying to get JUST the PID from the ps command. my command line is: ps -ef | grep "mintty" | cut -d' ' -f2 but i get an empty line. i assume that the delimiter is not just one space character, but can't figure out what should i do in order to do that. i know i can use awk or cut... (8 Replies)
Discussion started by: ran ber
8 Replies

7. Shell Programming and Scripting

awk and cut command

Hi, I have to display the value 16 present in "lcpu=16" which is the output of a command # vmstat System configuration: lcpu=16 mem=4096MB I used as # hdtype=`vmstat | grep "lcpu" | awk -F "=" '{print $2}'` # echo $hdtype 16 mem But I need to display only 16.. Am doing... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

8. Shell Programming and Scripting

AWK command to cut the desired header columns

Hi Friends, I have a file1 i want to retrieve only the fields which have DEP,CITY,TRANS as headers in other file. Output: I want to give the input as DEP,CITY,TRANS column names to get the output. i used cut command .. but if i have 300 fileds it is more difficult to... (4 Replies)
Discussion started by: i150371485
4 Replies

9. Shell Programming and Scripting

a cut-command or special format pattern in awk

Hi i read data with awk, 01.07.2012 00:10 227.72 247.50 1.227 1.727 17.273 01.07.2012 00:20 237.12 221.19 2.108 2.548 17.367 01.07.2012 00:30 230.38 230.34 3.216 3.755 17.412 01.07.2012 00:40 243.18 242.91 4.662 5.172 17.328 01.07.2012 00:50 245.58 245.41 5.179 5.721 17.128... (3 Replies)
Discussion started by: IMPe
3 Replies

10. Shell Programming and Scripting

Cut Command error cut: Bad range

Hi Can anyone what I am doing wrong while using cut command. for f in *.log do logfilename=$f Log "Log file Name: $logfilename" logfile1=`basename $logfilename .log` flength=${#logfile1} Log "file length $flength" from_length=$(($flength - 15)) Log "from... (2 Replies)
Discussion started by: dgmm
2 Replies
Login or Register to Ask a Question