Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Converting csv to tsv and back Post 302191763 by doubleminus on Sunday 4th of May 2008 06:54:19 PM
Old 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

Converting csv to xls

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

Converting %## back to special characters from an HTML form

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

converting text to csv format

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

Converting HTML to CSV

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

Converting spaces to csv

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

Converting txt file in csv

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

awk with tsv & csv

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

Converting CSV to ascii format

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

Converting csv to html format

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

Converting XML to CSV

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)
All times are GMT -4. The time now is 06:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy