Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help me to to insert data
Top Forums UNIX for Dummies Questions & Answers help me to to insert data Post 302093871 by ghostdog74 on Tuesday 24th of October 2006 02:25:08 AM
Old 10-24-2006
Quote:
Originally Posted by ghostdog74
Python alternative

Code:
#!/usr/bin/python
1.import fileinput
2.for lines in fileinput.FileInput("input.txt", inplace=1): #inplace edit
3. 	a = lines.strip().split(",")
4. 	if a[0] == "asd":
5. 		insertstring = ",33,44," 
6. 	if a[0] == "mnmn":
7. 		insertstring = ",55,66," 
8. 	print a[0] , insertstring , ','.join(a[1:])

1. fileinput is a Python standard module for looping over files and processing them. So we import it into the script.
2. Here we loop over the lines in the file, using for loop. The "inplace = 1" argument says to perform modification to the file "without creating a temporary file", ie inplace editing.
3. Strip the line of newlines and then split them up using ',' as delimiter. Eg asd,12,12,12,12,1,2,1,1,1,1,1 will become ['asd', '12', '12', '12', '12', '1', '2', '1', '1', '1', '1', '1']. In Python , strings are immutable, do i use a list
4-7. to refer to elements of a list in Python, we use indexes. eg a[0] refers to the first element, which is "asd". The second element will be a[1] which is '12' and so on.
8. a[1:] means get from index 1 (element 2) till the end of the list.
",".join ( a[1:] ) means to join ['12', '12', '12', '12', '1', '2', '1', '1', '1', '1', '1'] back to a string 12,12,12,12,1,2,1,1,1,1,1 , using commas as delimiters.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed, insert data from a file to another?

Hello, I have 2 files. File1 has data I wrote, and File2 is a file created by an application. I would like to insert the data from File1 into File2, but it has to be inserted at a certain location on File2. I know I need to search for "</jsp-param> </jsp-descriptor>" But I don't know... (4 Replies)
Discussion started by: ctcuser
4 Replies

2. Solaris

Not able to insert data

Hi All, I enhanced a perl script that creates a table with xyz_yyyymm and insert data from xyz table before truncate xyz.I have tested it successfully in dev but when i ran it on production new table xyz_yyyymm created but did not insert any records from xyz.(No errors were thrown)The perl... (1 Reply)
Discussion started by: megh
1 Replies

3. Shell Programming and Scripting

How to insert data befor some field in a row of data depending up on values in row

Hi I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example. The original data record should be some thing like this 60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies

4. Shell Programming and Scripting

Awk: Data Insert

Hi guys, I'm having some difficulties in insert some details to the following contents. I need to insert "TEST" under MIR & a value "25" to the next line. So far, I am able to insert "TEST" by using awk to capture MIR as the identifier. However, I am having some difficulties in inserting "25"... (3 Replies)
Discussion started by: nantheless
3 Replies

5. Shell Programming and Scripting

insert data into specific lines of a CSV

So I work in a 1 to 1 laptop deployment and sometimes we need to mass order parts. The vendor will send us a text file and we have to manually input serial numbers. Well I have a full blown web based inventory system which I can pull serial number reports from. I then have to input the part... (4 Replies)
Discussion started by: tlarkin
4 Replies

6. Shell Programming and Scripting

Insert and shifting data at column

Hi all, i have data like this joe : 1 :a bob : 2 :b sue : 3 :c foo : 4 :d at column 2 i want to insert TOP to the top column and at column 3 i want to insert BOTTOM to the bottom column. and the result will... (12 Replies)
Discussion started by: psychop13
12 Replies

7. UNIX for Dummies Questions & Answers

How to insert data in a file at last?

Hi Am Using Unix ksh... I have file name called FILE1 Have a content in a FILE as 11/01/2012 12/07/2012 -- -- I have used one variable DATE=12/11/2012 I wants to insert DATE variable value at last line in a file I need Output as cat FILE1 11/01/2012 12/07/2012 -- (2 Replies)
Discussion started by: Venkatesh1
2 Replies

8. Shell Programming and Scripting

Parsing XML (and insert data) then output data (bash / Solaris)

Hi folks I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file. It all works - apart from the xml and config file format in the new file with XML files the original XML (that ends up in... (2 Replies)
Discussion started by: dfinch
2 Replies

9. Programming

Need help on Insert data to mySQL database

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies

10. Shell Programming and Scripting

Insert data based on pattern

if it is finding some data based on pattern 'test' then insert else if has no data based on the pattern 'test' then exit successfully cat file | grep test > file2 (3 Replies)
Discussion started by: jagu
3 Replies

LEARN ABOUT DEBIAN

idle

IDLE(1) 						      General Commands Manual							   IDLE(1)

NAME

       IDLE - An Integrated DeveLopment Environment for Python

SYNTAX

       idle [ -dins ] [ -t title ] [ file ...]

       idle [ -dins ] [ -t title ] ( -c cmd | -r file ) [ arg ...]

       idle [ -dins ] [ -t title ] - [ arg ...]

DESCRIPTION

       This  manual page documents briefly the idle command.  This manual page was written for Debian because the original program does not have a
       manual page.  For more information, refer to IDLE's help menu.

       IDLE is an Integrated DeveLopment Environment for Python. IDLE is based on Tkinter, Python's bindings to the Tk widget  set.  Features  are
       100%  pure  Python, multi-windows with multiple undo and Python colorizing, a Python shell window subclass, a debugger. IDLE is cross-plat-
       form, i.e. it works on all platforms where Tk is installed.

OPTIONS

       -h     Print this help message and exit.

       -n     Run IDLE without a subprocess (see Help/IDLE Help for details).

       The following options will override the IDLE 'settings' configuration:

       -e     Open an edit window.

       -i     Open a shell window.

       The following options imply -i and will open a shell:

       -c cmd Run the command in a shell, or

       -r file
	      Run script from file.

       -d     Enable the debugger.

       -s     Run $IDLESTARTUP or $PYTHONSTARTUP before anything else.

       -t title
	      Set title of shell window.

       A default edit window will be bypassed when -c, -r, or - are used.

       [arg]* and [file]* are passed to the command (-c) or script (-r) in sys.argv[1:].

EXAMPLES

       idle   Open an edit window or shell depending on IDLE's configuration.

       idle foo.py foobar.py
	      Edit the files, also open a shell if configured to start with shell.

       idle -est "Baz" foo.py
	      Run $IDLESTARTUP or $PYTHONSTARTUP, edit foo.py, and open a shell window with the title "Baz".

       idle -c "import sys; print sys.argv" "foo"
	      Open a shell window and run the command, passing "-c" in sys.argv[0] and "foo" in sys.argv[1].

       idle -d -s -r foo.py "Hello World"
	      Open a shell window, run a startup script, enable the debugger, and run foo.py, passing "foo.py" in sys.argv[0] and "Hello World" in
	      sys.argv[1].

       echo "import sys; print sys.argv" | idle - "foobar"
	      Open a shell window, run the script piped in, passing '' in sys.argv[0] and "foobar" in sys.argv[1].

SEE ALSO

       python(1).

AUTHORS

       Various.

								 21 September 2004							   IDLE(1)
All times are GMT -4. The time now is 02:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy