Extracting the column containing URL from a text file
I have the file like this:
Each column is tab separated. I need to extract only the URLs from column 2 and column 3 if in case of the no URLs then leave it empty for example to get the result like this:
I tried this script
This script can give me the all URLS in a single column without the header. Any suggestion to resolve this.
Hi All,
I have some HTML files and my requirement is to extract all the anchor text words from the HTML files along with their URLs and store the result in a separate text file separated by space. For example, <a href="/kid/stay_healthy/">Staying Healthy</a>
which has /kid/stay_healthy/ as... (3 Replies)
I have a tab delimited text file where the first column can take on three different values : 100, 150, 250. I want to extract all the rows where the first column is 100 and put them into a separate text file and so on. This is what my text file looks like now:
100 rs3794811 0.01 0.3434... (1 Reply)
I have a tab delimited text file where the first column can take on three different values : 100, 150, 250. I want to extract all the rows where the first column is 100 and put them into a separate text file and so on. This is what my text file looks like now:
100 rs3794811 0.01 0.3434
100... (1 Reply)
I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001.
My input:
rs10082730 9e-08 12 46002702
rs2544081 1e-07 12 46015487
rs1425136 1e-06 7 35396742
rs2712590... (1 Reply)
I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
Hello Everyone,
I am trying to write a shell script(or Perl Script) that would do the following:
I have a file that contains the following lines:
File:
https://ims-svnus.com/dev/DB/trunk/feeds/templates/shell_script.txt -r860... (5 Replies)
I have the file like this:
Timestamp URL Text 1331635241000 http://example.com Peoples footage at www.test.com,http://example4.com 1331635231000 http://example1.net crack the nuts http://example6.com 1331635280000 http://example2.net ... (0 Replies)
I have the file like this:
Timestamp URL Text 1331635241000 http://example.com Peoples footage at www.test.com,http://example4.com 1331635231000 http://example1.net crack the nuts http://example6.com 1331635280000 http://example2.net ... (0 Replies)
Discussion started by: csim_mohan
0 Replies
LEARN ABOUT PHP
urlcoding
URLCODING(3) libbash urlcoding Library Manual URLCODING(3)NAME
urlcoding -- a Libbash library for encoding and decoding URL's.
SYNOPSIS
urlEncodeString [-l] <STRING>
urlEncodeFile [-l] <FILE>
urlEncodeStream [-l]
urlDecodeString <STRING>
urlDecodeFile <FILENAME>
urlDecodeStream
DESCRIPTION
urlcoding is a collection of functions that convert ASCII-text to standard URL's and vice-versa. The AWK code used is based on code by Heiner
Steven <heiner.steven@odn.de>
The function list:
urlEncodeString Creates a URL from an ASCII string
urlEncodeFile Converts a file into URL-valid text
urlEncodeStream Converts standard input into URL-valid text
urlDecodeString Converts a URL-encoded text back to a plain-text form
urlDecodeFile Coverts URL-encoded text in a file back to plain text
urlDecodeStream Converts URL-encoded standard input to text
Detailed interface description follows.
The [-l] option for the encoding functions should be used when line-feed characters ('
') are to be encoded as well.
All functions print the results of their conversions to standard output.
The exit status of all functions is that of the command 'awk', with '0' for success
FUNCTIONS DESCRIPTIONS
urlEncodeString [-l] <STRING>
Converts STRING - a string of ASCII characters - to URL.
urlEncodeFile [-l] <FILE>
Coverts FILE of URL-encoded text to plain text
urlEncodeStream [-l]
Converts text from standard input to URL-text.
urlDecodeString <STRING>
Converts URL-encoded string STRING back to text.
urlDecodeFile <FILENAME>
Converts the URL-encoded text in FILE to plain text.
urlDecodeStream
Converts the URL-encoded text from standard input to plain-text
AUTHORS
Alon Keren <alon.keren@gmail.com>
SEE ALSO ldbash(1), libbash(1)Linux Epoch Linux