It's time to learn what the special IFS variable does It's a list of characters that the shell splits on, by default any whitespace.
If you had your users type in 1 2 3 instead of commas, you wouldn't need to alter IFS at all.
Hi,
Newbie here. I have a file that consists of data that I want to convert to a csv file. For example:
Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105
Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Hi,
Can any one tell me how to replace one or more tabs from start of the line and in between the words with commas in the file using unix commands?
My actual data in the text file is as below with spaces.The spaces are not being shown in the post..please see them while replying to the post.... (1 Reply)
Hello all
i am working on a database to import log files from my systems, but i cannot seem to find the answer. I searched here for a good bit and couldnt peice together what i was looking for.
I know you could do this with awk, i just dont know how. Any help would be greatly appreciated.... (6 Replies)
OK, I am one needy dude. However, how can I make the program NOT change any of the values BETWEEN the first and second "," ?
I dont want any of the numbers changed that are preceded by "AT".
I want ALL other numeric values > 300 changed to 300.
cat qin.csv |head... (4 Replies)
Hi All,
My file looks like this:
1 2 3
3 4 5
6 7 8
8 7 6
3 4 5
3 6 7
3 4 5
1 2 4
3 4 6
2 4 6
As you can see there are two newlines after the next pattern of numbers begin. (4 Replies)
Hi All,
I have a file which looks like this:
abc 3456
computer 3214
printer 0.9823
computer 3214
Can anyone please let me know how I can format my text like this?
abc 3456 computer 3214 printer 0.9823 computer 3214
I know how to space to newlines using tr but don't know how to do... (4 Replies)
Hey guys,
I have the following text:
1,2,3,4,5,6,'NULL','when',NULL,1,2,0,'NULL'
1,2,3,4,5,6,'NULL','what','NULL',1,2,0,1
I need the same text with the word NULL without commas
u know something like this:
1,2,3,4,5,6,NULL,'when',NULL,1,2,0,NULL
1,2,3,4,5,6,NULL,'what','NULL',1,2,0,1
... (1 Reply)
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Hi,
My input file is like this
chr1 + "NM_1234"
chr1 - "NM_1234"
If I want my third column to contain both the first and second column values, how do I do it?
I know how to do it by including the column numbers, but I want the values before the inverted commas.
So, my output would... (5 Replies)
Hi buddy's
my file are like this:
s.no,name,band,sal
1,"suneel",,10
2,"bargav
sand",,20
30,"
ebdug gil",,4
but i want
s.no,name,band,sal
1,"suneel",,10
2,"bargav sand",,20
30,"ebdug gil",,4
any command or Shell script for this.
please help me it's urgent to implement (33 Replies)
Discussion started by: Suneelbabu.etl
33 Replies
LEARN ABOUT CENTOS
uri::url
URI::URL(3) User Contributed Perl Documentation URI::URL(3)NAME
URI::URL - Uniform Resource Locators
SYNOPSIS
$u1 = URI::URL->new($str, $base);
$u2 = $u1->abs;
DESCRIPTION
This module is provided for backwards compatibility with modules that depend on the interface provided by the "URI::URL" class that used to
be distributed with the libwww-perl library.
The following differences exist compared to the "URI" class interface:
o The URI::URL module exports the url() function as an alternate constructor interface.
o The constructor takes an optional $base argument. The "URI::URL" class is a subclass of "URI::WithBase".
o The URI::URL->newlocal class method is the same as URI::file->new_abs.
o URI::URL::strict(1)
o $url->print_on method
o $url->crack method
o $url->full_path: same as ($uri->abs_path || "/")
o $url->netloc: same as $uri->authority
o $url->epath, $url->equery: same as $uri->path, $uri->query
o $url->path and $url->query pass unescaped strings.
o $url->path_components: same as $uri->path_segments (if you don't consider path segment parameters)
o $url->params and $url->eparams methods
o $url->base method. See URI::WithBase.
o $url->abs and $url->rel have an optional $base argument. See URI::WithBase.
o $url->frag: same as $uri->fragment
o $url->keywords: same as $uri->query_keywords
o $url->localpath and friends map to $uri->file.
o $url->address and $url->encoded822addr: same as $uri->to for mailto URI
o $url->groupart method for news URI
o $url->article: same as $uri->message
SEE ALSO
URI, URI::WithBase
COPYRIGHT
Copyright 1998-2000 Gisle Aas.
perl v5.16.3 2012-02-11 URI::URL(3)