05-05-2009
How to add text to a field within a csv file
I have a csv file which has three columns
mem no. name surname
1234 John Smith
12345 John Doe
I want to change the mem no. to add TF to the mem no. field i.e.
mem no. name surname
1234TF John Smith
12345TF John Doe
How do you do this for all records in the file?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
print "count,pub,prodline,group,sector,date,source" > $fname
cat sp_log.summary.$firstday-$lastday.ProdlineSector | sed "s/^ *//g;s/ *$//g" >sp_log.summary.$firstday-$lastday
cat sp_log.summary.$firstday-$lastday | sed "s/$/ $lastyy-$lastmm cache/;s/ /,/g" >> $fname
cat $fname | sed... (1 Reply)
Discussion started by: shikhakaul
1 Replies
2. Shell Programming and Scripting
Hello all,
I've a CSV file and need to replace 5th field if its value is "X".
The exact requirement is to replace 5th field (column) with "Y" if
a. it's value is "X" AND
b. the line must start with ABC string
i guess this can be done with awk. Pl help.
For security reasons, the... (2 Replies)
Discussion started by: prvnrk
2 Replies
3. Shell Programming and Scripting
Hi there, I have a csv file with some columns comma sepated like this :
4502-17,PETER,ITA2,LEGUE,92,ME - HALF,23/05/10 15:00
4502-18,CARL,ITA2,LEGUE,96,ME - HALF,20/01/09 14:00
4502-19,OTTO,ITA2,LEGUE,97,ME - MARY,23/05/10 15:00
As you can see the column n. 7 is a timestamp column, I need... (23 Replies)
Discussion started by: capnino
23 Replies
4. Shell Programming and Scripting
hi,
i have various csv files, the file format is as follows
Entry: "1",4,2010/08/15-10-00-00.01,,"E",,,,,,,,,120,0,"M4_","C","KEW-011-5337140-20100916163456-540097","1234567890","N N 0 ",,,"NUK 800100200",,,"NN",,,,,,,,,,,,"0000000001|0001|20150401... (2 Replies)
Discussion started by: niteesh_!7
2 Replies
5. Shell Programming and Scripting
Hello,
I have some data in a text file where fields are separated by blank lines. There are only 6 fields however some fields have several lines of data as I will explain. Also data in a particular field is not consistently the same size but does end on a blank line. The first field start with... (6 Replies)
Discussion started by: vestport
6 Replies
6. Shell Programming and Scripting
Hi
I have a job status csv file. I want to update the status of the job in the file.
Below is the csv file
1,jobname1,in_progress,starttime,somthing,somthing
2,jobname2,completed,starttime,somthing,somthing
3,jobname3,failed,starttime,somthing,somthing... (8 Replies)
Discussion started by: midhun19
8 Replies
7. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
8. UNIX for Dummies Questions & Answers
Hi... I can't find my little red AWK book and it's been a long while since I've awk'd. But I need to take a CSV file and convert the first word of the fifth field to its own field by replacing a space with a comma.
This is for importing a spreadsheet of issues into JIRA...
Example:
a line... (9 Replies)
Discussion started by: Tawpie
9 Replies
9. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
10. Shell Programming and Scripting
Hi, all
I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw... (9 Replies)
Discussion started by: refrain
9 Replies
LEARN ABOUT DEBIAN
mojo::asset::memory
Mojo::Asset::Memory(3pm) User Contributed Perl Documentation Mojo::Asset::Memory(3pm)
NAME
Mojo::Asset::Memory - In-memory storage for HTTP 1.1 content
SYNOPSIS
use Mojo::Asset::Memory;
my $mem = Mojo::Asset::Memory->new;
$mem->add_chunk('foo bar baz');
say $mem->slurp;
DESCRIPTION
Mojo::Asset::Memory is an in-memory storage backend for HTTP 1.1 content.
EVENTS
Mojo::Asset::Memory can emit the following events.
"upgrade"
$mem->on(upgrade => sub {
my ($mem, $file) = @_;
...
});
Emitted when asset gets upgraded to a Mojo::Asset::File object.
$mem->on(upgrade => sub {
my ($mem, $file) = @_;
$file->tmpdir('/tmp');
});
ATTRIBUTES
Mojo::Asset::Memory inherits all attributes from Mojo::Asset and implements the following new ones.
"auto_upgrade"
my $upgrade = $mem->auto_upgrade;
$mem = $mem->auto_upgrade(1);
Try to detect if content size exceeds "max_memory_size" limit and automatically upgrade to a Mojo::Asset::File object.
"max_memory_size"
my $size = $mem->max_memory_size;
$mem = $mem->max_memory_size(1024);
Maximum size in bytes of data to keep in memory before automatically upgrading to a Mojo::Asset::File object, defaults to the value of the
"MOJO_MAX_MEMORY_SIZE" environment variable or 262144.
METHODS
Mojo::Asset::Memory inherits all methods from Mojo::Asset and implements the following new ones.
"new"
my $mem = Mojo::Asset::Memory->new;
Construct a new Mojo::Asset::Memory object.
"add_chunk"
$mem = $mem->add_chunk('foo bar baz');
my $file = $mem->add_chunk('abc' x 262144);
Add chunk of data and upgrade to Mojo::Asset::File object if necessary.
"contains"
my $position = $mem->contains('bar');
Check if asset contains a specific string.
"get_chunk"
my $chunk = $mem->get_chunk($offset);
Get chunk of data starting from a specific position.
"move_to"
$mem = $mem->move_to('/home/sri/foo.txt');
Move asset data into a specific file.
"size"
my $size = $mem->size;
Size of asset data in bytes.
"slurp"
my $string = mem->slurp;
Read all asset data at once.
SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>.
perl v5.14.2 2012-09-05 Mojo::Asset::Memory(3pm)