Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extracting fields from an output 8-)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting fields from an output 8-)
# 1  
Old 01-19-2006
Lightbulb Extracting fields from an output 8-)
I am getting a variable as x=2006/01/18

now I have to extract each field from it.
Like x1=2006, x2=01 and x3=18.

Any idea how?

Thanks a lot for help.

Thanks
CSaha
# 2  
Old 01-19-2006
Code:
[/tmp]$ echo "2006/01/18" | { IFS="/" read a b c; echo $a $b $c ; }
2006 01 18

# 3  
Old 01-19-2006
On a deeper note, I think I know where you are heading to...

If that solution does not work, pick up some clues from this thread Breaking input with "read" command
# 4  
Old 01-19-2006
Code:
echo "2006/01/18" | awk -F"/" '{print "x1="$1",x2="$2 ",x3=" $3}'

# 5  
Old 01-19-2006
Excellent Vino !!!

After posting I tried this and resolved

$ echo "2006/01/18" | awk -F"/" '{print $1}'
2006

$ echo "2006/01/18" | awk -F"/" '{print $2}'
01

$ echo "2006/01/18" | awk -F"/" '{print $3}'
18

See this also ...
# 6  
Old 01-19-2006
here is one more in sed,

Code:
echo 2006/01/18 | sed 's/\(.*\)\/\(.*\)\/\(.*\)/year: \1 month: \2 day: \3/'

year: 2006 month: 01 day: 18
# 7  
Old 01-20-2006
You can also use 'cut'

year=`echo 2006/01/18 | cut -d/ -f1`
month=`echo 2006/01/18 | cut -d/ -f2`
day=`echo 2006/01/18 | cut -d/ -f3`


But, i think tah the better solution is Vino post

echo 2006/01/18 | IFS=/ read year month day


Jean-Pierre.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Extracting specific fields from an XML file

Hello All, I have a requirement to split the input.xml file different files and i have tried using earlier examples(where i have posted in the forum), but still no luck Here is my input.xml <jms-system-resource> <name>UMSJMSSystemResource</name> ... (4 Replies)
Discussion started by: Siv51427882
4 Replies

2. Shell Programming and Scripting

UNIX extracting fields

I have one file A.txt which is comma separated and I want to extract first 4 field's in a file and also I want to add one more column in output A.txt in output for all records. A.txt should not be hard coded since I do not filename it may be any file. (1 Reply)
Discussion started by: vamsi.valiveti
1 Replies

3. Shell Programming and Scripting

Pattern Matching and extracting the required fields in Perl

Hi All, I am writing the following Perl Scrip and need your help in Pattern matching : I have the following Shell Script that would read line by line from the file (file_svn) and would inturn calls the Perl Script: #!/bin/bash perl_path="/home/dev/filter"... (2 Replies)
Discussion started by: filter
2 Replies

4. Shell Programming and Scripting

Help in extracting fields from a file

I have an input file with contents like: 203969 OrdAcctCycChg USAGE_DAEMON1 203970 OrdAcctCycChg USAGE_DAEMON2 203971 OrdAcctCycChg USAGE_DAEMON3 203972 OrdAcctCycChg USAGE_DAEMON4 I need to extract variables in first column... (51 Replies)
Discussion started by: Rajesh Putnala
51 Replies

5. Shell Programming and Scripting

need help in writing a script for extracting fields

Hi, I need to extract last character of the field retrieved from the database using select command. eg: select event,text from event_data; o/p: Event1,text1 But I need to extract only '1' from the fields...similarly '2' from Event2,text2 and '3' from Event3,text3 etc., and need to pass... (6 Replies)
Discussion started by: Rajesh Putnala
6 Replies

6. Shell Programming and Scripting

Extracting fields from file

I am need to extract a number of values from a file, put have now clue how to do this. The file looks like this: # My file Dest=87;CompatibleSystemSoftwareVersion=2.5300-; Dest=87;ImageVersion=000061f3;SystemSoftwareVersion=2.5300;CDN=http://my.backup.com/download.txt;CDN_Timeout=30; I... (3 Replies)
Discussion started by: MagicDude4Eva
3 Replies

7. Shell Programming and Scripting

Removing LF and extracting two fields

I need some assistance, I am writing a script in bash. I want to do two things: 1/. I want to replace the LF at the end of the RFH  Ø  ¸MQSTR ¸ so I can process the file record by record using a while loop. 2/. I want to extract two fields from each record, they are identified with... (1 Reply)
Discussion started by: gugs
1 Replies

8. Shell Programming and Scripting

Extracting records with unique fields from a fixed width txt file

Greetings, I would like to extract records from a fixed width text file that have unique field elements. Data is structured like this: John A Smith NY Mary C Jones WA Adam J Clark PA Mary Jones WA Fieldname / start-end position Firstname 1-10... (8 Replies)
Discussion started by: sitney
8 Replies

9. Shell Programming and Scripting

extracting fields

Hi, i have a line with several fields (indefinite number of - count varies) separated by colon. Now, i need to pick each field (except the first one) and have it assigned to variable within a loop. In other words, in the first iteration of the loop, the variable must be assigned with 2nd... (2 Replies)
Discussion started by: prvnrk
2 Replies

10. UNIX for Dummies Questions & Answers

Extracting information from text fields.

Dear friends, I'm a novice Unix user and I'm trying to learn the ropes. I have a big task I have to accomplish and I'm convinced Unix can get the job done, I just haven't figured out how. I recently posted on the topic of cutting text between unique text patterns and somebody helped me a great... (24 Replies)
Discussion started by: spindoctor
24 Replies
Login or Register to Ask a Question