|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
read a line from a csv file and convert a column to all caps
Post 302154642 by orahi001 on Monday 31st of December 2007 05:05:52 PM
12-31-2007
Hi again,
thanks for the feedback...I used nawk as suggested and it worked.
awk -F '|' '/[.]doc/ {print toupper($2)}' datafile
is definitely simpler than what I have...I'm a newbie to unix scripting so I of course made something more complicated than it should be
thanks for the help
thanks for the feedback...I used nawk as suggested and it worked.
awk -F '|' '/[.]doc/ {print toupper($2)}' datafile
is definitely simpler than what I have...I'm a newbie to unix scripting so I of course made something more complicated than it should be
thanks for the help
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a .csv file which is seperated with (;)
inputfile
---------
ZZZZ;AAAA;BBB;CCCC;DDD;EEE;
YYYY;BBBB;CCC;DDDD;EEE;FFF;
...
...
reading file line by line till end of file.
while reading each line output format should be .
i need to print only specific columns let say 5th... (2 Replies)
Discussion started by: rocking77
2 Replies
2. Shell Programming and Scripting
Folks ,
i want to read a csv file line by line till the end of file and filter the text in the line and append everything into a variable.
csv file format is :-
trousers:shirts,price,50
jeans:tshirts,rate,60
pants:blazer,costprice,40
etc
i want to read the first line and get... (6 Replies)
Discussion started by: venu
6 Replies
3. Shell Programming and Scripting
Hi All,
My requirement is to remove line (3 Replies)
Discussion started by: r_t_1601
3 Replies
4. Shell Programming and Scripting
Hi All,
i have a csv file .
In the 7th column i have data that has line feed in it.
Requirement is to remove the line feed from the 7th column whenever it appears
There are 11 columns in the file
C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11
The value in C7 contains line feed ( Alt + Enter ),... (2 Replies)
Discussion started by: r_t_1601
2 Replies
5. UNIX for Dummies Questions & Answers
Folks,
how do i skip the first line in a csv, while doing the read of a csv file in to a variable line by line.
eg :
do
echo $line
done < $rpt
where rpt is path to csv file
The initial 1st line is a garbage that i want to avoid, and start reading from 2nd line
... (2 Replies)
Discussion started by: venu
2 Replies
6. Shell Programming and Scripting
I have huge xml file in server and i want to convert it to .csv with specific column ...
i have search in blog but i didn't get any usefully command.
Thanks in advance (1 Reply)
Discussion started by: pareshkp
1 Replies
7. Shell Programming and Scripting
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Discussion started by: giankan
8 Replies
8. Shell Programming and Scripting
Hi experts,
I have a very large (1.5M lines), sorted but unstructured list that looks like this:
process_nameA valueA
process_nameA valueA
...
process_nameB valueB
process_nameB valueB
...
process_nameN valueN
I'd like to turn this into a csv.
The values are all... (4 Replies)
Discussion started by: abercrom
4 Replies
9. Shell Programming and Scripting
Hello,
Got a CSV file which contains 21 columns
Need to convert the file to Pipe delimiter and Few columns text data contains new line
Example
1,2,3,"ABC" 8" ABC,5,6,7
1,2,3,"ABC"
8" ABC,5,6,7 ( New Line)
1,2,3,""ABC" 8" ABC", 5,6,7
1,2,3,"ABC"
,5,6,7(New line)
Expected... (8 Replies)
Discussion started by: krux_rap
8 Replies
10. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
LEARN ABOUT DEBIAN
rec2csv
REC2CSV(1) User Commands REC2CSV(1) NAME
rec2csv - rec to csv converter SYNOPSIS
rec2csv [OPTIONS]... [REC_FILE] DESCRIPTION
Convert rec data into csv data. -t, --type=TYPE record set to convert to csv; if this parameter is omitted then the default record set is used -S, --sort=FIELD sort the output by the specified field. --help print a help message and exit. --version show version and exit. AUTHOR
Written by Jose E. Marchesi. REPORTING BUGS
Report bugs to: bug-recutils@gnu.org GNU recutils home page: <http://www.gnu.org/software/recutils/> General help using GNU software: <http://www.gnu.org/gethelp/> COPYRIGHT
Copyright (C) 2010, 2011, 2012 Jose E. Marchesi. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. SEE ALSO
The full documentation for rec2csv is maintained as a Texinfo manual. If the info and rec2csv programs are properly installed at your site, the command info rec2csv should give you access to the complete manual. rec2csv 1.4.93 January 2012 REC2CSV(1)