05-04-2008
Oh, okay - got it!
sed "s/,/"$'\t'/g test
works like a charm!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony
1 Replies
2. Shell Programming and Scripting
I have an HTML form that sends email to a large list of users one at a time by matching an email address in peoplesoft to their username. It works great, except that special characters are converted to %## format. Is there a library of these I can use to sed them back (yes this is a crappy UNIX... (1 Reply)
Discussion started by: 98_1LE
1 Replies
3. Shell Programming and Scripting
I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited.
Here is the test file that needs to be changed to csv
11 051701
22 051701
330123405170105170112345... (13 Replies)
Discussion started by: gthokala
13 Replies
4. UNIX for Dummies Questions & Answers
Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this?
Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies
5. UNIX for Dummies Questions & Answers
I'm new to shell scripting and I have a file with positional columns. The rows look like this:
222 3333 44444 55 55 55 55 5555 59999
222 3333 44444 55 55 55 55 5555 59999
Not every row has the same number of spaces between the seven columns. They can range anywhere... (11 Replies)
Discussion started by: jkandel
11 Replies
6. Shell Programming and Scripting
HI All,
I have a text file memory.txt which has following values.
Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600
i want to convert this file in csv format and i am using following command to do it.
sed s/_/\./g <... (3 Replies)
Discussion started by: mkashif
3 Replies
7. Shell Programming and Scripting
Hi! HELP! I have a few issues...
I have a tsv with headers time, binary time, bytes, and bits. I'm trying to extract only time & bits. (Trying to graph throughput)
Using:
awk -F"\t" '{print $1, "\t"$4}' infile.tsv > outfile.tsv
Output is only the headers: time bits
Thinking it... (2 Replies)
Discussion started by: calitiggr
2 Replies
8. Shell Programming and Scripting
Hej All,
I have a file like this which is a comma dilimited:
input:
6000318,-263.011520678,-59.05869872409,587.67924868792
6000319,-265.6996842902,-50.24902479999,590.65693082607
6000320,-238.1333898366,-288.801232595,633.75332173496... (5 Replies)
Discussion started by: Johanni
5 Replies
9. Shell Programming and Scripting
Below is the code I have - How can I convert the data in the csv into 3 tables in html. instead of 1 table.
Attached is the format I am getting. (1 Reply)
Discussion started by: archana25
1 Replies
10. Shell Programming and Scripting
Hello,
For i while i have been using XMLStarlet to convert several XML files to CSV files. So far this always went fine.
Today however i got a new XML format however but i cannot find out how to get the data i need.
Below is part of the code where it shows the different format. What... (10 Replies)
Discussion started by: SDohmen
10 Replies
PERLUTS(1) Perl Programmers Reference Guide PERLUTS(1)
NAME
perluts - Perl under UTS
SYNOPSIS
This document can be read as is: as README.uts, or you can read it after you build your package using "man perluts".
The purpose is to help you build Perl for UTS, which, if you follow these instructions, should be easy, and result in a solidly working
installation.
DESCRIPTION
Perl 5.7.2 (Developmental) or Perl 5.8.x (forthcoming) for UTS
BUILDING PERL ON UTS
NOTE: Some sites have redefined the way uname works, and if yours does this, special steps must be taken so that Configure can recognize
your system as a UTS system. To see if you are in this category, issue the command "uname -a". It should look something like:
uts juno 4 4.4 9672 370
At any rate, the first field should be "uts". If this is not the case; supposing it is, say telcoUTS, create a script, uts/uname (i.e.
uname, in the subdirectory "uts" of the main Perl source dir):
# uname
/usr/bin/uname "$@" | sed -e 's/^telcoUTS/uts/'
and when you execute Configure, do it as below, except for adding PATH=uts:$PATH as a prefix. I.e. do:
PATH=uts:$PATH ./Configure ...
There is no need to do an interactive configure, just type
./Configure -de [-Dusedevel] [-Doptimize=-g ] 2>&1 | tee Conf.out
"-Dusedevel" may be required to configure Perl 5.7.2 non-interactively. Use -Doptimize=-g if you want to run Perl under sdb or gdb, OR if
you want to be able to use the -D command line flags to perl, which are occasionally useful in debugging perl scripts.
In this and the following steps, the "2>&1 | tee XXX.out" records all output from the process, which will be useful if anything unexpected
goes wrong.
Then do the compilation with
make 2>&1 | tee make.out
Finally, test using
make test 2>&1 | tee make-test.out
In the output, the only failures you should see should look like:
lib/Math/BigInt/t/bigfltpm.........Use of uninitialized value ...
FAILED at test 57
lib/Math/BigInt/t/bigintc..........ok
lib/Math/BigInt/t/bigintpm.........FAILED at test 204
lib/Math/BigInt/t/mbimbf...........Use of uninitialized value ...
Illegal division by zero at ../lib/Math/BigInt/Calc.pm line 314.
FAILED at test 71
lib/Math/Complex...................exp: OVERFLOW
FAILED at test 250
lib/Math/Trig......................exp: OVERFLOW
ok
lib/Memoize/t/array................ok
...
lib/Net/protoent...................ok
lib/Net/servent....................FAILED at test 0
This means that everything passes except for some problems in the packages "Math::BigInt", "Math::Complex", and "Math::Trig". The
lib/Net/servent failure seems to be a bug in the test program. To confirm this, from the main Perl source dir, do:
LD_LIBRARY_PATH=`pwd` ./perl -Ilib lib/Net/servent.t
and it should output
1..3
ok 1
ok 2
ok 3
Installing the built perl on UTS
Run the command "make install"
AUTHOR
Hal Morris
UTS Global LLC
email: hom00@utsglobal.com
perl v5.16.2 2012-10-25 PERLUTS(1)