Extracting data from between double quotes


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting data from between double quotes
# 8  
Old 09-01-2013
Try something like this:
Code:
awk -v RS=\< -F\> '/href.*t00z/{ split($1, F, /"/); print F[2] }' file

--
@ajayram: If it is nawk you are using, then you can only use a single character for RS
@briandanielz: It is a huge file
# 9  
Old 09-01-2013
Quote:
Originally Posted by Scrutinizer
@briandanielz: It is a huge file
Yes. My bad for not being specific. I was just posting how to extract the variable.

I was thinking loop over the file with an array..
pseudo (untested)

Code:
while read line
	do
	    name=$line
	    if [[ $line == *fooBar* ]]; then #Some Search condition 
		line1="${line##*href\=\"}"
		line2="${line1%\"\>*}"
		array+=("$line2")
	    fi
	done < $file


Last edited by briandanielz; 09-01-2013 at 11:46 PM.. Reason: removed space
# 10  
Old 09-02-2013
Quote:
Originally Posted by briandanielz
Yes. My bad for not being specific. I was just posting how to extract the variable.

I was thinking loop over the file with an array..
pseudo (untested)

Code:
while read line
	do
	    name=$line
	    if [[ $line == *fooBar* ]]; then #Some Search condition 
		line1="${line##*href\=\"}"
		line2="${line1%\"\>*}"
		array+=("$line2")
	    fi
	done < $file

I'm confused: Are you briandanielz or are you ajayram_arya? Both of you seem to be answering questions about what is wanted and posting very similar segments of code that you're using to solve parts of the problem.

Shell array sizes in both ksh and bash are limited. Since your input is a "huge file", the shell array limits may be your problem.

What are you going to do with the array after you have processed your "huge file"? Can't you instead process the data from each line in your huge file as you find it without keeping a list of that data from all of the lines you've processed in an array?
# 11  
Old 09-02-2013
Quote:
Originally Posted by Don Cragun
I'm confused: Are you briandanielz or are you ajayram_arya? Both of you seem to be answering questions about what is wanted and posting very similar segments of code that you're using to solve parts of the problem.

Shell array sizes in both ksh and bash are limited. Since your input is a "huge file", the shell array limits may be your problem.

What are you going to do with the array after you have processed your "huge file"? Can't you instead process the data from each line in your huge file as you find it without keeping a list of that data from all of the lines you've processed in an array?
I would most likely read the file into a variable file stored in a trap directory. So upon completion or error the data, would be gobbled up.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace double quotes inside the string data for all the columns

Please use code tags Hi, I have input data is below format and n of column in the multiple flat files. the string data has any double quotes(") values replaced to double double quotes for all the columns{""). Also, my input flat file each column string data has carriage of new line too.... (14 Replies)
Discussion started by: SSrini
14 Replies

2. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

Hi All, I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes. Sample Data : "221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies

3. Shell Programming and Scripting

Skip the delimiter with in double quotes and count the number of delimiters during data extract

Hi All, I'm stuck-up in finding a way to skip the delimiter which come within double quotes using awk or any other better option. can someone please help me out. Below are the details: Delimited: | Sample data: 742433154|"SYN|THESIS MED CHEM PTY.... (2 Replies)
Discussion started by: BrahmaNaiduA
2 Replies

4. Shell Programming and Scripting

Handling embedded double quotes within column data

I have a text file where each field is enclosed in double quotes and separated by a comma. But in certain rows we have embedded double quotes within column data For e.g """TRUSPICE CENTRE"" CLAYTON AU" The above value is for a single column but there are embedded quotes within... (2 Replies)
Discussion started by: abhilashnair
2 Replies

5. Shell Programming and Scripting

Issue with Single Quotes and Double Quotes for prompt PS1

Hi, Trying to change the prompt. I have the following code. export PS1=' <${USER}@`hostname -s`>$ ' The hostname is not displayed <abc@`hostname -s`>$ uname -a AIX xyz 1 6 00F736154C00 <adcwl4h@`hostname -s`>$ If I use double quotes, then the hostname is printed properly but... (3 Replies)
Discussion started by: bobbygsk
3 Replies

6. Shell Programming and Scripting

Extract data based on 2nd colume having double quotes

i want extract where the 2nd column having "3" or "7". Based on the forums tried like this but it is not working awk -F"," '$2=3;$2=7 {print}' filename Source "1","2","3","4" "1","3","3","4" "1","7","3","4" "1","8","3","4" "1","2","3","4" "1","2","3","4" Output : ... (5 Replies)
Discussion started by: onesuri
5 Replies

7. UNIX for Dummies Questions & Answers

grep single quotes or double quotes

Unix superusers, I am new to unix but would like to learn more about grep. I am very familiar with regular expressions as i have used them for searching text files in windows based text editors. Since I am not very familiar with Unix, I dont understand when one should use GREP with the... (2 Replies)
Discussion started by: george_vandelet
2 Replies

8. Shell Programming and Scripting

Single quotes and double quotes

Hi guys, I have a sed line in double quotes which works fine, but I want it to be in single quotes here is the sed line sed "/abc_def/s/\'.*\'/\'\${abc_def}\'/" can some one give the equivalent to the above script in single quotes Thanks a ton (5 Replies)
Discussion started by: sol_nov
5 Replies

9. Shell Programming and Scripting

Double quotes or single quotes when using ssh?

I'm not very familiar with the ssh command. When I tried to set a variable and then echo its value on a remote machine via ssh, I found a problem. For example, $ ITSME=itsme $ ssh xxx.xxxx.xxx.xxx "ITSME=itsyou; echo $ITSME" itsme $ ssh xxx.xxxx.xxx.xxx 'ITSME=itsyou; echo $ITSME' itsyou $... (3 Replies)
Discussion started by: password636
3 Replies

10. Shell Programming and Scripting

comparing scalars contaning "DOUBLE QUOTES" as data

Hello to all, Does anyone know the solution ? Two strings A and B are present. I want to check whether B is a Substring of A. 1. The value of A is - 29 * * * /bin/ls "test" "tmp*" "log*" (Note: Pl note that A contains DOUBLEQUOTES, ASTERISK & FRONTSLASH) 2. The value of B is -... (5 Replies)
Discussion started by: rssrik
5 Replies
Login or Register to Ask a Question