extract data from file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extract data from file
# 8  
Old 09-18-2008
assuming consistent data format
Code:
awk 'BEGIN{FS="[^0-9a-zA-Z]+"}
{
 print "var"++d"="$1," value="$2
}' file

# 9  
Old 09-18-2008
Tools Are you looking to head in this direction?

The input file
Code:
> cat file1a
Name := sachin
address:=something
phone:=111

The program script
Code:
> cat mkfile2a
sed "s/Name/~Name/g" file1a | tr "\n" "|" | tr "~" "\n" | tail +2>file2a
echo "" >>file2a

while read zf
   do
   echo $zf
   var1=$(echo $zf | cut -d"|" -f1 | cut -d":" -f1 | tr -d " ")
   val1=$(echo $zf | cut -d"|" -f1 | cut -d"=" -f2 | tr -d " ")
   var2=$(echo $zf | cut -d"|" -f2 | cut -d":" -f1 | tr -d " ")
   val2=$(echo $zf | cut -d"|" -f2 | cut -d"=" -f2 | tr -d " ")
   var3=$(echo $zf | cut -d"|" -f3 | cut -d":" -f1 | tr -d " ")
   val3=$(echo $zf | cut -d"|" -f3 | cut -d"=" -f2 | tr id " ")

   echo "Var1="$var1
   echo "Value1="$val1
   echo "Var2="$var2
   echo "Value2="$val2
   echo "Var3="$var3
   echo "Value3="$val3

done<file2a

The output from execution (the input is echo'd to screen just as a debug tool)
Code:
> mkfile2a
Name := sachin|address:=something|phone:=111|
Var1=Name
Value1=sachin
Var2=address
Value2=something
Var3=phone
Value3=111

# 10  
Old 09-18-2008
Another awk solution :
Code:
awk '
/:=/ {
   gsub(/^[[:space:]]*|[[:space:]]*$/, "");
   gsub(/[[:space:]]*:=[[:space:]]*/, SUBSEP);
   split($0, vv, SUBSEP);
   printf("Var%d=%s\n",   ++count, vv[1]);
   printf("Value%d=%s\n",   count, vv[2]);
}
' inputfile

Inputfile:
Code:
Source := /home/user1
Dest   := /tmp
File   := result.dat

Output:
Code:
Var1=Source
Value1=/home/user1
Var2=Dest
Value2=/tmp
Var3=File
Value3=result.dat

Jean-Pierre.
# 11  
Old 09-18-2008
Bug

Quote:
Originally Posted by aigles
Another awk solution :
Code:
awk '
/:=/ {
   gsub(/^[[:space:]]*|[[:space:]]*$/, "");
   gsub(/[[:space:]]*:=[[:space:]]*/, SUBSEP);
   split($0, vv, SUBSEP);
   printf("Var%d=%s\n",   ++count, vv[1]);
   printf("Value%d=%s\n",   count, vv[2]);
}
' inputfile

Inputfile:
Code:
Source := /home/user1
Dest   := /tmp
File   := result.dat

Output:
Code:
Var1=Source
Value1=/home/user1
Var2=Dest
Value2=/tmp
Var3=File
Value3=result.dat

Jean-Pierre.
Its working ....
Thanks for the help...

I m new to the shell scripting so i need explation....
waiting for the reply......
# 12  
Old 09-19-2008
Code:
sed 's/ //g' filename | nawk -F":=" '{
print "var"NR"="$1
print "value"NR"="$2
}'

# 13  
Old 09-19-2008
sed 's/[:=]/ /g' InputFileName | awk '{print "var1= "$1"\nvalue1="$2}'
Its working for me
# 14  
Old 09-19-2008
sed 's/[:=]/ /g' InputFileName | awk '{print "var"NR"= "$1"\nvalue"NR"="$2}'
-->
var1= Name
value1=sachin
var2= address
value2=something
var3= phone
value3=111
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data from a file

Hi , I am having a file which is PIPE delimited like this : file.txt aus|start|10:00:00 nz|start|11:00:00 aus|end|10:10:00 us|start|10:00:00 nz|end|11:10:00 us|end|11:00:00 . . . I want to extract an output file like this based on start time and end time for each countries: (9 Replies)
Discussion started by: rohit_shinez
9 Replies

2. Shell Programming and Scripting

Extract data from a file

I have a text file that contains the following data. For example, aa.txt has some numbers. I need to extract the continuous numbers(minimum 3 numbers) from it.How can I do this with awk? >aa.txt 31 35 36 37 38 39 44 169 170 173 174 175 177 206 >1a.txt 39 (5 Replies)
Discussion started by: rahmanabdulla
5 Replies

3. Shell Programming and Scripting

Extract data from a file

Hello All, I have a small xml file which looks like below: <Check:defaultval Val="crash" value="crash_report_0013&#xA;generate_check_0020 generate_check_0022&#xA;&#xA;This is where the fault is."/> <Check:defaultval Val="crash" value="crash_report_1001&#xA;generate_check_1001... (9 Replies)
Discussion started by: suvendu4urs
9 Replies

4. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached... (17 Replies)
Discussion started by: nex_asp
17 Replies

5. Shell Programming and Scripting

Help with File Data Extract

Hello, Hope you are doing fine. I have been struggling with it for some time now and I would really appreciate your help. Following is file format: Currency,Name,Date, Term USD, ABC, 2011/11/11, T0, S1, S2, S3, S4 , , ,T1, 5.6, 2.3, 6.5, 4.5 , ... (5 Replies)
Discussion started by: srattani
5 Replies

6. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

7. Shell Programming and Scripting

Extract Data from a file

I need to create a script to extract some specific data from a file. I locate the file using the find command: find . -name "rpbol*" -print | xargs grep -li Once I locate the file I need using the above command, I would like to extract some data from that file. The data is always located... (2 Replies)
Discussion started by: jevaba
2 Replies

8. Shell Programming and Scripting

extract data from file

Hello again, how do you extract data from a file? I have created a file with PID #s in it, I need to be able to take the PID from each line and kill it. How is this done? (4 Replies)
Discussion started by: raidzero
4 Replies

9. Shell Programming and Scripting

Extract data from file

Dear All , I am posting first time in this forum . Please ignore my mistakes . I am learning Unix and i need help to extract specific data from file . 1. I want to grep number of fails from log . The file contains "fails" word in line if test cases are failed . 2. The log contains... (20 Replies)
Discussion started by: getdpg
20 Replies

10. Shell Programming and Scripting

extract data from file

My file in ksh consists of message data of varying lengths (lines), separated with headers. I would like to find a string from this file, and print out the whole message data including the headers. my plan of attack is to search the strings, print the top header, and print the whole message... (2 Replies)
Discussion started by: apalex
2 Replies
Login or Register to Ask a Question