|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
How do I insert commas/delimiters in File
Post 72223 by mbelen on Thursday 19th of May 2005 05:16:27 PM
05-19-2005
How do I insert commas/delimiters in File
Hi,
Newbie here. Need to convert a txt file to .csv format. There's no character to replace so not sure if I can use sed
. The comma is to be inserted after every certain number of characters in each line...
Help!
Thanks.
Newbie here. Need to convert a txt file to .csv format. There's no character to replace so not sure if I can use sed
. The comma is to be inserted after every certain number of characters in each line...Help!
Thanks.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm working with a file like:
somestuff
somemorestuff
...
someadditionalstuff
STARTTAG
ENDTAG
someotherstuff
somecoolstuff
...
somefinalstuffI've got some text (either in a file or piped) to put between STARTTAG and ENDTAG. I was thinking something like grepping for the line number of... (2 Replies)
Discussion started by: BMDan
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Newbie here. I have a file that consists of data that I want to convert to a csv file. For example:
Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105
Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Discussion started by: kangaroo
3 Replies
3. UNIX for Dummies Questions & Answers
Hi
I have a text file which is position delimited, i.e.
Code1 Description1 Value1
Code2 Description2 Value2 etc.
I want to import this file into MySQL so I want to convert the file into Comma delimited format.
To do this I want to insert commas at fixed positions on... (7 Replies)
Discussion started by: arossco
7 Replies
4. Shell Programming and Scripting
Can someone please help?I have a file - fixed.txt----------------------------AABBBBCCCCCCDDDEEFFFFGGGGGGHHHIIJJJJKKKKKKLLL----------------------------To insert delimiters at fixed lengths of 2, 4, 6, 3, I created a file text1.txt as-------------------2463----------------------and trying to execute... (10 Replies)
Discussion started by: jd_mca
10 Replies
5. Shell Programming and Scripting
Hi,
I am trying to insert Inverted Commas around all the numeric values within a comma seperated string / variable.
1111,2222,3333,4444
I would like it to be:
'1111','2222','3333','4444'
Note - This string could have a differing amount of numeric values each time the variable is... (4 Replies)
Discussion started by: RichZR
4 Replies
6. Shell Programming and Scripting
Having a huge file in the following format.
2,3,1,,,4
1,2,3,,,,,5,
8,7,3,4,,,,
Output needed is:
2,3,1,0.0,0.0,4
1,2,3,0.0,0.0,0.0,0.0,5,
8,7,3,4,0.0,0.0,0.0,
I have tried reading the file each line, using AWK to parse to find out ",," and then insert 0.0 . It works but very slow. Need... (8 Replies)
Discussion started by: wincrazy
8 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have a set of data as below :
XS012371378 Raj 23-09-12
SH128238948 Andrew 24-08-12
CH273712399 Walsh 12-10-12
JK7249923893 Nick 10-02-13
JP6383791389 Braslin 30-12-13
I want the first column to be extracted separately. I can get this using awk.
awk '{print $1}' file_name
... (3 Replies)
Discussion started by: Nand Kishor
3 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement where in I need to insert delimiters before the last column of the total delimiters is less than a specified number.
Say if the delimiters is less than 139, I need to insert 2 columns ( with blanks) before the last field
awk -F 'Ç' '{ if (NF-1 < 139)} END { "Insert 2... (5 Replies)
Discussion started by: arunkesi
5 Replies
9. Shell Programming and Scripting
Hey guys,
I have a file that is delimited by | and I am trying to write a sed command to
convert this:
abc|def||ghi|jkl||||mnop
into this:
abc|def|-|ghi|jkl|-|-|-|mnop
The output I am getting out of:
sed -e "s/+//g" /tmp/opt.del > /tmp/opt2.del
is like:
... (9 Replies)
Discussion started by: prohank
9 Replies
10. UNIX for Beginners Questions & Answers
Original content:
ACACCTCAT 129 | ACACCTCAT 0
ACACCTCATX 171 | ACACCTCATX 0
ACACRESRT 0 ACACRESRT 0
ACACRESRTX 0 ... (4 Replies)
Discussion started by: loktamann
4 Replies
LEARN ABOUT DEBIAN
py_xls2csv
py_xls2csv(1) General Commands Manual py_xls2csv(1) NAME
py_xls2csv - convert an Excel xls file to a comma separated value csv file SYNOPSIS
py_xls2csv input-file DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page. py_xls2csv takes an Excel xls file as an argument and converts it to a comma separated value csv file. Output is sent to stdout. Additional utility scripts can be found in the tools/ directory. OPTIONS
This program does not take any command line options. AUTHOR
pyexcelerator and py_xls2csv were written by Roman V. Kiseliov <roman@kiseliov.ru>. This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. SEE-ALSO pyexcelerator(1), py_xls2txt(1), py_xls2html(1) October 12, 2006 py_xls2csv(1)