insert comma in a text file

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert data between comma delimiters-large file

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...

2. UNIX for Dummies Questions & Answers

insert comma

my file looks like this: 297 PC Closed 07/10/12 999000098 AMERICAN SOCIETY FOR HEALTHCAR 0.00 USD 1 NAI i want to look line this: 297,PC,Closed,07/10/12,999000098,AMERICAN SOCIETY FOR HEALTHCAR,0.00,USD,1,NAI

3. Shell Programming and Scripting

Append the text file with comma at the end of every word

Hi folks, Using shell, I am trying the append comma to every line of text. the requirement is like, I have to open the txt file in unix and read line by line and should add comma at the end of every word to make it single line txt file ------- abc@gmail.com bcd@gmail.com...

4. Shell Programming and Scripting

How to format file into comma separated text file?

Hi Guys, I have text file which is tab/space separated but I want it to re-format into a comma separated and trim the spaces in between. Can someone spare me a perl or sed script that can do the job? INPUT FILE: 500010245623 500 21-APR-11 05.58.21 PM ...

5. Shell Programming and Scripting

Convert comma text file to Column in html format

I am trying to generate a report with below file : File1 : EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere11-phys,8227caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere3-phys,822caef0,gpatmon,/bin/ksh,nuten Erick can you help me convert it to html and add...

6. Shell Programming and Scripting

Need to insert new text and change existing text in a file using SED

Hi all, I need to insert new text and change existing text in a file. For that I used the below line in the command line and got the expected output. sed '$a\ hi... ' shell > shell1 But I face problem when using the same in script. It is throwing the error as, sed: command garbled:...

7. Shell Programming and Scripting

How to insert some constant text at beginig of each line within a text file.

Dear Folks :), I am new to UNIX scripting and I do not know how can I insert some text in the first column of a UNIX text file at command promtp. I can do this in vi editor by using this command :g/^/s//BBB_ e,g I have a file named as Test.dat and it containins below text: michal...

8. Shell Programming and Scripting

How to replace all entries of comma in text file by space or other character

Hi , How to replace all entries of comma in text file by space or other character. cat temp.txt A,B,C,D I want this file to be like A B C D Please help!!!

9. Shell Programming and Scripting

How do you delete multiple text from a comma delimited file

I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST): 1, 2,43,34, bosx,PEST 1,...

10. Shell Programming and Scripting

Parsing comma delimited text file

I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days. The format is like this: dirA,5 dirB,7 How do I write script to iteratively parse this text file & delete...

LEARN ABOUT BSD

vi

VI(1)							      General Commands Manual							     VI(1)

NAME

       vi - screen oriented (visual) display editor based on ex

SYNOPSIS

       vi [ -t tag ] [ -r ] [ +command ] [ -l ] [ -wn ] name ...

DESCRIPTION

       Vi (visual) is a display oriented text editor based on ex(1).  Ex and vi run the same code; it is possible to get to the command mode of ex
       from within vi and vice-versa.

       The Vi Quick Reference card and the Introduction to Display Editing with Vi provide full details on using vi.

FILES

       See ex(1).

SEE ALSO

       ex (1), edit (1), ``Vi Quick Reference'' card, ``An Introduction to Display Editing with Vi''.

AUTHOR

       William Joy
       Mark Horton added macros to visual mode and is maintaining version 3

BUGS

       Software tabs using ^T work only immediately after the autoindent.

       Left and right shifts on intelligent terminals don't make use of insert and delete character operations in the terminal.

       The wrapmargin option can be fooled since it looks at output columns when blanks are typed.  If a long word passes through the  margin  and
       onto the next line without a break, then the line won't be broken.

       Insert/delete  within  a  line  can  be slow if tabs are present on intelligent terminals, since the terminals need help in doing this cor-
       rectly.

       Saving text on deletes in the named buffers is somewhat inefficient.

       The source command does not work when executed as :source; there is no way to use the :append, :change, and :insert commands, since  it	is
       not possible to give more than one line of input to a : escape.	To use these on a :global you must Q to ex command mode, execute them, and
       then reenter the screen editor with vi or open.

3rd Berkeley Distribution					  April 29, 1985							     VI(1)

UNIX for Dummies Questions & Answers