Sponsored Content
Top Forums Shell Programming and Scripting Insert text into specific column Post 302747985 by alegnagrp on Monday 24th of December 2012 03:59:23 AM
Old 12-24-2012
Insert text into specific column

I have the following data:

Code:
Dec 24 11:31:10 0000008b 9911662486 Answered Price SGD 0.003 PERIOD: 0 m 6 s
Dec 24 11:21:42 00000086 9911662486 Answered Price SGD 0.001 PERIOD: 0 m 2 s
Dec 20 15:34:28 00000004 9911662486 Answered Price SGD 0.007 PERIOD: 0 m 12 s
Dec 20 18:42:30 0000017b 9911662486 Answered Price SGD 0.005 PERIOD: 0 m 9 s
Dec 20 18:36:04 00000172 9911662486 Answered Price SGD 0.004 PERIOD: 0 m 7 s
Dec 20 18:29:21 0000016d 9911662486 Answered Price SGD 0.007 PERIOD: 0 m 11 s

I would like it to be:


Code:
Dec 24 11:31:10 0000008b 9911662486 Answered Price SGD 0.003 PERIOD: 0 m 6 s
Dec 24 11:21:42 00000086 9911662486 Answered Price SGD 0.001 PERIOD: 0 m 2 s
Dec 20 15:34:28 00000004 9911662486 Answered Price SGD 0.007 PERIOD: 0 m 12 s
Dec 20 18:42:30 0000017b 9911662486 Answered Price SGD 0.005 PERIOD: 0 m 9 s
Dec 20 18:36:04 00000172 9911662486 Answered Price SGD 0.004 PERIOD: 0 m 7 s
Dec 20 18:29:21 0000016d 9911662486 Answered Price SGD 0.007 PERIOD: 0 m 11 s
                                                                                   Total SGD 0.027

The "Total SGD 0.027" is insert into column 7,8,9


Last edited by Scott; 12-24-2012 at 08:37 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

insert text into column

Hello! I have a text file containing some text : : : bla other text : : : bla any text : : : bla containing 3 columns separated by the ':' sign. Now i want to insert 'this' in the 2nd line after the 2nd column-deliminiter (i.e. into 3rd column), like some text : : : bla other text :... (1 Reply)
Discussion started by: knoxo
1 Replies

2. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies

3. Shell Programming and Scripting

Can sed be used to insert data at specific column?

I'm trying to use sed to insert data at a specific column, let's say my data looks like this: 0553 1828 0552 1829 0550 1829 0549 1830 0548 1831 what I want is this: timein 0553 timeout 1828 timein 0552 timeout 1829 timein 0550 timeout 1829 timein 0549 timeout 1830 timein 0548... (5 Replies)
Discussion started by: mswartz
5 Replies

4. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

5. UNIX for Dummies Questions & Answers

How to insert alternative columns and sort text from first column to second?

Hi Everybody, I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this as ad af 1 A as ad af 1 D ... ... 1 and A are in one... (7 Replies)
Discussion started by: Unilearn
7 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

7. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

8. Shell Programming and Scripting

sed - insert text if column empty

Hi, I want to insert the text 'Unknown' in 2 specific columns in a csv file (actually | separated) if the column is blank. Its always the same columns. I have tried using sed: sed "s/||/|Unknown|/g" but there are occasion where other fields are blank and they need to be left blank. This... (4 Replies)
Discussion started by: ksexton
4 Replies

9. Shell Programming and Scripting

Insert text line to specific location CSV

In Perl. ***edited question below*** Hey all, I am teaching myself some simple CSV file manipulation and have become a little stuck. Say I have the following layout in the CSV file: age,name,locationIs it possible to INSERT data into the CSV into the correct age order. For example, if I had... (1 Reply)
Discussion started by: whyte_rhyno
1 Replies

10. Shell Programming and Scripting

Insert space in specific column among many columns

Hello, I have some problem in inserting the space for the pairs of columns. I have the input file : I used this code below in replacing it using space in specific column (replace space in each two columns) sed -e "s/,/ /2" -e "s/,/ /3" inputfile Output showed : However, I have many... (3 Replies)
Discussion started by: awil
3 Replies
P910ND(8)						      System Manager's Manual							 P910ND(8)

NAME
p910nd - port 9100+n printer daemon SYNOPSIS
p910nd [-f device] [-i bindaddr] [-bv] [0|1|2] DESCRIPTION
p910nd is a small daemon that copies any data received on the port it is listening on to the corresponding printer port. It is primarily intended for diskless Linux hosts running as printer drivers but there is no reason why it could not be used on diskful hosts. Port 9100 is copied to /dev/lp0, 9101 to /dev/lp1 and 9102 to /dev/lp2. The default is port 9100 to /dev/lp0. The -f option can be used to specify a different printer device, e.g. /dev/usblp0. The -i option can be used to specify binding to one address instead of all interfaces which is the default. The -b option turns on bidirectional copying. The -v option shows the version number. INSTALLATION
p910nd can be run as a standalone daemon or from (x)inetd. It will automatically detect if it is running under (x)inetd. A sample SysVinit script, p910nd.sh, is provided for operation as a daemon. p910nd will change its name under ps to match the printer port, i.e. p9100d, p9101d and p9102d. When running under (x)inetd, the /etc/inetd.conf entry should look something like this (with tcpwrappers protection): p9101 stream tcp nowait root /usr/sbin/tcpd /sbin/p910nd Don't forget to add an entry in /etc/services for the corresponding port. If operating with lprng, use the host%port syntax for the printer device to send jobs to it. If operating with CUPS, this is supported as the AppSocket protocol, also known as the JetDirect (probably TM) protocol. If operating with classic Berkeley lpd, a sample client, client.pl, is provided. This should be installed as the ifilter (if=) in /etc/printcap. banner.pl should be installed as the ofilter (of=) in /etc/printcap. It may be necessary to create a dummy spool file for lpd (lp=). This file will be opened but not written to. The corresponding C versions are left as an exercise for the reader. When running under inetd, more than one instance could be started. To avoid problems with multiple instances attempting to access the printer at the same time, make sure that only one client is active at any one time. This can be done by designating one host as the spooler and sending all jobs to this host. You will probably need to set up an intermediate queue anyway to provide print job filtering. If built with USE_WRAP, it uses the libwrap library (tcpwrappers). Access control can be done with /etc/hosts.allow and /etc/hosts.deny. The service name is p910nd. DIAGNOSTICS
p910nd logs error messages to syslog. SEE ALSO
printcap(5), hosts_access(5) FILES
/var/run/p9100d.pid, /var/lock/p910nd/p9100d, /etc/hosts.allow, /etc/hosts.deny COPYRIGHT
p910nd is under the GNU Public License Version 2 AUTHOR
Ken Yap (greenpossum ATSIGN users PERIOD sourceforge PERIOD net) DATE
Version 0.95 February 2011 16 February 2011 P910ND(8)
All times are GMT -4. The time now is 01:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy