|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Convert comma seperated file to line seperated.
Post 302477922 by jim mcnamara on Monday 6th of December 2010 05:54:12 PM
12-06-2010
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Shell Programming and Scripting
how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell.
Pls help me as its very urgent.
Thanks,
Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies
4. UNIX for Dummies Questions & Answers
My query is now a bit simplified.
file1.txt
names; ID; value1 ; values N;
ABC; 1 ; a18 ; ...
CDF; 2 ; b16 ; ..
ABC; 1 ; c13 ; ......
EFG; 3 ;d12 ; ...
file2.txt
ID(Unique);smVals; smVal1; smVal N;
1; ...; ...; ...;
2; ..; ..; ..;
3; ..; ..; ..; ... (1 Reply)
Discussion started by: szchmaltz
1 Replies
5. Shell Programming and Scripting
Hi,
I want to remove empty/blank lines from comma seperated and space seperated files
Thanks all for help (11 Replies)
Discussion started by: pinnacle
11 Replies
6. Shell Programming and Scripting
I have file like this
FileA:
abc , "helloworld" , america
def,asia, japan
ghi, africa, ipl
Output Needed:
abc,"helloworld",america
def,asia,japan
ghi,africa,ipl
I would like to implement using awk.
I want to trim each field for its leading and trailing spaces. (7 Replies)
Discussion started by: pinnacle
7 Replies
7. UNIX for Dummies Questions & Answers
Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact.
Input:
40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0
Output:... (5 Replies)
Discussion started by: Scottie1954
5 Replies
8. Shell Programming and Scripting
I have a file with the below content
a = test1
b = test2
a = test3
b= test4
c = test6
b = test5
d = test7
d = test9
Need the output to be as follows
a = test1,test3
b = test2, test5
c = test6
d = test7, test9 (4 Replies)
Discussion started by: iron_michael86
4 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading.
i used this command
awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ {
i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i);
i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies
10. Shell Programming and Scripting
Hi Experts
I have an escape seperated fields in the unix file. And in the below format file I need to extract the first column. Please help its urgent.
cat -v op.dat | head
24397028^
I want to extract the file in below format ( with only first column )
24397028
2439707
thanks.
... (6 Replies)
Discussion started by: neha_suri06
6 Replies
LEARN ABOUT MOJAVE
native2ascii
native2ascii(1) General Commands Manual native2ascii(1) NAME
native2ascii - native to ASCII converter SYNOPSIS
native2ascii [ options ] [ inputfile [outputfile]] DESCRIPTION
The Java compiler and other Java tools can only process files that contain Latin-1 or Unicode-encoded (udddd notation) characters. native2ascii converts files that contain other character encoding into files containing Latin-1 or Unicode-encoded charaters. If outputfile is omitted, standard output is used for output. In addition, if inputfile is omitted, standard input is used for input. OPTIONS
The following options are supported: -encoding encoding_name Specifies the encoding name that is used by the conversion procedure. The default encoding is taken from system property file.encod- ing. The encoding_name string must be one taken from the first column of the table of supported encodings in the Supported Encodings document: http://java.sun.com/j2se/1.5/docs/guide/intl/encoding.doc.html -reverse Performs the reverse operation: converts a file with Latin-1 or Unicode-encoded characters to one with native-encoded characters. -Joption Pass option to the Java virtual machine, where option is one of the options described on the man page for the java applica- tion launcher, java(1). For example, -J-Xms48m sets the startup memory to 48 megabytes. It is a common convention for -J to pass options to the underlying virtual machine. 22 Jun 2004 native2ascii(1)