|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Need to modify csv-file with bash script
Post 302394676 by Sebi0815 on Friday 12th of February 2010 08:08:42 AM
02-12-2010
@Franklin52
Hey Franklin,
thanks for your help. I found the mistake... In your post, there's a blank between @ "substr($10,1,10), so the timestamp did not stand right behind the @-Symbol... Again, thanks for your help...
@pludi
I also wanna thank you, maybe I can use your version somehow...
Hey Franklin,
thanks for your help. I found the mistake... In your post, there's a blank between @ "substr($10,1,10), so the timestamp did not stand right behind the @-Symbol... Again, thanks for your help...
@pludi
I also wanna thank you, maybe I can use your version somehow...
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey guys, i'm having trouble complete one of my bash scripts
I'm hoping to ---
1. Modify bash so that then the user types "ls" the command that is executed is "ls -al"
2. Modify the point of entry in bash when the user accesses it, moving the initial location to /var
I've somewhat done #2,... (9 Replies)
Discussion started by: LibRid
9 Replies
2. Shell Programming and Scripting
hi guys,
im fairly new to unix and bash scripts and therefore your help would really be appreciated.
i need to write a bash script that will take a csv file, and reorder the data and output to another csv file.
The source csv file will look something like this:
HEAD,671061,Add,SS... (3 Replies)
Discussion started by: daz_20
3 Replies
3. Shell Programming and Scripting
I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Discussion started by: raj100
3 Replies
4. Shell Programming and Scripting
I need to
1.Open a csv
2.Process the csv i.e. Modify 2 column in the csv.
To modify the column the value needs to be passed to a pl/sql function and the return value should be updated
For eg:
If column 2 E,then E will be passed in database function
which will return Employee.
3. Write a... (5 Replies)
Discussion started by: Chinky23
5 Replies
5. Shell Programming and Scripting
Hello Everyone,
I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank.
Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
3 Replies
6. Shell Programming and Scripting
Hi Friends,
I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file
table findhost=
{
{"xyz","abc"},
{"rxz","mmz"},
{"vrr","nnz"},
}
default={"NONE"}
My current perl script
#!/usr/bin/env perl... (12 Replies)
Discussion started by: dbashyam
12 Replies
7. Shell Programming and Scripting
I am attempting to download a url in csv format. When I download this url in a browser excel opens up and automatically populates with comma separated values.
When I try to use curl or wget I get nothing or garbage.
This on the command line just hangs
wget -b... (2 Replies)
Discussion started by: bash_in_my_head
2 Replies
8. Shell Programming and Scripting
Hi, I would like to change my CSV file by adding " and : and moving some of the information around. the CSV file looks as follows:
501254424;500440257;PE PACKS;300467279;PREP;;276476070;655031001867176;Two Block;Olga;25/12/2015 00:00:00;Olga
I would like to move the field 7 to the front "... (13 Replies)
Discussion started by: omuhans123
13 Replies
9. Shell Programming and Scripting
Hello everyone!
I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns.
The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies
10. UNIX for Beginners Questions & Answers
Hello everybody,
I would like modify some strings using sed or another command line with the content file.
For example:
- {fqdn: "server-01" , ip: "server-01"}
- {fqdn: "server-02" , ip: "server-02"}
- {fqdn: "server-03" , ip: "server-03"}
- {fqdn: "server-04" , ip: "server-04"}
My... (4 Replies)
Discussion started by: dco
4 Replies
LEARN ABOUT OSX
ppi::token::symbol
PPI::Token::Symbol(3) User Contributed Perl Documentation PPI::Token::Symbol(3) NAME
PPI::Token::Symbol - A token class for variables and other symbols INHERITANCE
PPI::Token::Symbol isa PPI::Token isa PPI::Element DESCRIPTION
The "PPI::Token::Symbol" class is used to cover all tokens that represent variables and other things that start with a sigil. METHODS
This class has several methods beyond what is provided by its PPI::Token and PPI::Element parent classes. Most methods are provided to help work out what the object is actually pointing at, rather than what it might appear to be pointing at. canonical The "canonical" method returns a normalized, canonical version of the symbol. For example, it converts "$ ::foo'bar::baz" to $main::foo::bar::baz. This does not fully resolve the symbol, but merely removes syntax variations. symbol The "symbol" method returns the ACTUAL symbol this token refers to. A token of $foo might actually be referring to @foo, if it is found in the form $foo[1]. This method attempts to resolve these issues to determine the actual symbol. Returns the symbol as a string. raw_type The "raw_type" method returns the apparent type of the symbol in the form of its sigil. Returns the sigil as a string. symbol_type The "symbol_type" method returns the actual type of the symbol in the form of its sigil. Returns the sigil as a string. SUPPORT
See the support section in the main module. AUTHOR
Adam Kennedy <adamk@cpan.org> COPYRIGHT
Copyright 2001 - 2011 Adam Kennedy. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. perl v5.16.2 2011-02-25 PPI::Token::Symbol(3)