04-09-2015
I don't get it.
In post #1 in this thread you showed us a sample input file. In post #3, you showed us the 1st two columns of the output you wanted. All of the input fields were preserved from the sample input your provided in post #1 with the contents of the 2nd field replaced by the numbers you said you wanted to be produced in that field in this output.
How is that different from the output produced by my script???
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm reading from a file that is semi-colon delimited. One of the fields contains 2 spaces separating the first and last name (4th field in - "JOHN<space><space> DOE"):
e.g. TORONTO;ONTARIO;1 YONGE STREET;JOHN DOE;CANADA
When I read this record and either echo/print to screen or write to... (4 Replies)
Discussion started by: NinersFan
4 Replies
2. Shell Programming and Scripting
Hi All,
I am trying to cut to do a cut operation, but since there are seems to be more than one deltimiters in some occasion I am not able to get the exact field. Can you please provide an SED and AWK script for treating the source file in such a way that all consecutive delimiters are treated... (3 Replies)
Discussion started by: rakesh.su30
3 Replies
3. Shell Programming and Scripting
Suppose you have a line like this:
cn=user.blr.ou=blr.india.o=company
The line should be converted like this:
cn=user.blr,ou=blr.india,o=comapny
Was wondering how to do that using shell script.
Please use tags where appropriate, thank you (4 Replies)
Discussion started by: saurabhkoar
4 Replies
4. Shell Programming and Scripting
Hi folks,
I have a file with four columns that looks like the following (tab separated)
1 1 1 a
2 2 2 b
3 3 3 c
4 4 4 d
I would like to create a file with always 4 columns but where the third entry corresponds to the thirst entry of the next line and so on, to get the following
1 1 2 a... (4 Replies)
Discussion started by: klebsiella
4 Replies
5. Shell Programming and Scripting
Hi All :o,
I have some log files which contains these informations:
2013-04-24 09:11:34.018 INFO XXXXXXXXXXXX
2013-04-24 09:11:34.029 INFO YYYYYYYYYYYY
2013-04-24 09:11:34.039 INFO ZZZZZZZZZZZZZZZ
2013-04-24 09:12:21.295 INFO TTTTTTTTTTTTTTT
2013-04-24 09:12:21.489 INFO... (3 Replies)
Discussion started by: shariquehabib
3 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I have two (2) sets of files that are based on some snapshots of database that I want to merge and insert any missing sequential number.
Below are example representation of these files:
file1:
DATE TIME COL1 COL2 COL3 COL4 ID
01/10/2013 0800 100 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
7. Shell Programming and Scripting
Hi
I need to remove three consecutive lines of code which appear multiple times during a script. Two of the lines also appear in other parts of the scripts and need to stay so I can't strip out the code per se - It needs to be the exact three lines. Hope that makes sense !
Any help much... (5 Replies)
Discussion started by: Grueben
5 Replies
8. How to Post in the The UNIX and Linux Forums
Hi All,
Please help me and guide me to write a bash/shell script on Linux box to delete parent entry with all their child entries.
example:
Parent is :
----------
dn: email=yogesh.kumar@wipro.com, o=wipro, o=in
child is:
----------
dn: cn: yogesh kumar, email=yogesh.kumar@wipro.com,... (1 Reply)
Discussion started by: Chand
1 Replies
9. Shell Programming and Scripting
Hi
I have a text file (Input.txt) with two column entries separated by tab as given below:
aaa str1
bbb str2
cccccc str3
dddd str4
eee str3
ssss str2
sdf str3
hhh str1
fff str2
ccc str3
.....
.....
..... (1 Reply)
Discussion started by: my_Perl
1 Replies
10. Shell Programming and Scripting
I have the input file like this.
Input file: 12.txt
1) There are one or more than one <tr> tags in same line.
2) Some tr tags may have one <td> or more tna one <td> tags within it.
3) Few <td> tags having "<td> </td>". Few having more than one " " entry in it.
<tr> some td... (4 Replies)
Discussion started by: thomasraj87
4 Replies
LEARN ABOUT PHP
sqlite_column
SQLITE_COLUMN(3) SQLITE_COLUMN(3)
sqlite_column - Fetches a column from the current row of a result set
SYNOPSIS
mixed sqlite_column (resource $result, mixed $index_or_name, [bool $decode_binary = true])
DESCRIPTION
mixed SQLiteResult::column (mixed $index_or_name, [bool $decode_binary = true])
mixed SQLiteUnbuffered::column (mixed $index_or_name, [bool $decode_binary = true])
Fetches the value of a column named $index_or_name (if it is a string), or of the ordinal column numbered $index_or_name (if it is an
integer) from the current row of the query result handle $result.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
o $index_or_name
- The column index or name to fetch.
o $decode_binary
-When the $decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it
was encoded using the sqlite_escape_string(3). You should normally leave this value at its default, unless you are interoperating
with databases created by other sqlite capable applications.
RETURN VALUES
Returns the column value.
NOTES
Note
Use this function when you are iterating a large result set with many columns, or with columns that contain large amounts of data.
SEE ALSO
sqlite_fetch_string(3).
PHP Documentation Group SQLITE_COLUMN(3)