Hi:
I have a text file date(pipe delimited) which is loaded in to the DB using sql loader(&CTL files) after some initial validation by the shell script.
Now i have a situation where the shell script needs to check a column in the text file and if it is NULL then it needs send this record/row... (12 Replies)
I have file with multiple columns. Column values for a record may be same.
Now i have to replace a column value(this can be same for the other columns) with new value.
File.txt
A,B,C,D,A,B,C,D,A,B,C,D
A,B,C,D,A,B,C,D,A,B,C,D
A,B,C,D,A,B,C,D,A,B,C,D
A,B,C,D,A,B,C,D,A,B,C,D... (1 Reply)
Hi All,
I need a shell script which could insert a sequence number column inside a dat file(pipe delimited).
I have the dat file similar to the one as shown below..
|A|B|C||D|E
|F|G|H||I|J
|K|L|M||N|O
|P|Q|R||S|T
As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
hi,
I have pipe delimited flat file as below
1|ab|4.5|9|
2|ac|3|12|
3|ac|4.5|8|
i want to show (display) only 3rd field between pipes.
please help (1 Reply)
Hi All, I will need an help with respect to replacing a range of columns on a non-delimited file using a particular string pattern.
Say file input is
MYNUMBERD000000-BAN CHUE INSNTS ** N+
MYAREDSDD000000+BAN CHUE INSNTS ** N+
MYDERFFFSD00000-GIR PENT - ACH ** ... (5 Replies)
Hi All,
I have a large dat file where each lines are pipe delimited values. I need to parse the file depending on the request. For example: sometimes I have told to remove all the values in the 7th column (this case remove values '3333' only from the first line and '3543' from the second line)... (4 Replies)
Hi,
I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values.
1|10/15/2011|fname1|lname1
2|10/15/2012|fname2|lname2
3|10/15/2013|fname3|lname3
Output file:
1||fname1|lname1
2||fname2|lname2
3||fname3|lname3
I tried this
... (2 Replies)
Hi,
I have a requirement where I have to check whether the mandatory columns in a pipe delimited file is null and print error message.
For eg, I have to check if the 3rd,5th,6th,7th and 8th column are null and print the message "<column name> is null".
The data file will have aroung 100,000... (6 Replies)
Hi Folks!
Need a solution for the following :-
Source data
-------------
123|123|<CRLF><CRLF><CRLF>|321<CRLF>
Required output
------------------
123|123|<LF><LF><LF>|321<CRLF>
<CRLF> represents carriage return
<LF> represents line feed
Being hunting high and low for a... (10 Replies)
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT PHP
stream_socket_sendto
STREAM_SOCKET_SENDTO(3) 1 STREAM_SOCKET_SENDTO(3)stream_socket_sendto - Sends a message to a socket, whether it is connected or notSYNOPSIS
int stream_socket_sendto (resource $socket, string $data, [int $flags], [string $address])
DESCRIPTION
Sends the specified $data through the $socket.
PARAMETERS
o $socket
- The socket to send $data to.
o $data
- The data to be sent.
o $flags
- The value of $flags can be any combination of the following:
possible values for $flags
+-----------+----------------------------------+
| | |
|STREAM_OOB | |
| | |
| | Process OOB (out-of-band) data. |
| | |
+-----------+----------------------------------+
o $address
- The address specified when the socket stream was created will be used unless an alternate address is specified in $address. If
specified, it must be in dotted quad (or [ipv6]) format.
RETURN VALUES
Returns a result code, as an integer.
EXAMPLES
Example #1
stream_socket_sendto(3) Example
<?php
/* Open a socket to port 1234 on localhost */
$socket = stream_socket_client('tcp://127.0.0.1:1234');
/* Send ordinary data via ordinary channels. */
fwrite($socket, "Normal data transmit.");
/* Send more data out of band. */
stream_socket_sendto($socket, "Out of Band data.", STREAM_OOB);
/* Close it up */
fclose($socket);
?>
SEE ALSO stream_socket_recvfrom(3), stream_socket_client(3), stream_socket_server(3).
PHP Documentation Group STREAM_SOCKET_SENDTO(3)