I have a '~' delimited file of 6 - 7 million rows. Each row should contain 13 columns delimited by 12 ~'s. Where there are 13 tildes, the row needs to be removed. Each row contains alphanumeric data and occasionally a ~ ends up in a descriptive field and therefore acts as a delimiter, resulting in... (1 Reply)
Hope someone can help,
I am trying to sort a generic file like this
test2 A 468 0
test2 R 468 1
test2 E 468 1
test2 R 468 3
test2 R 468 4
test2 R 468 459
test2 Z 468 0
test1 A 191 0
test1 R 191 191
test1 Z 191 0
test3 A 3 0
test3 R 3 3
test3 Z 3 0
test0 A 1 0
test4 A 1 0
test4 E... (2 Replies)
Hi all,
I So, I've got a monster text document comprising a list of various company names and associated info just in a long list one after another. I need to sort them alphabetically by name...
The text document looks like this:
Company Name:
the_first_company's_name_here
Address:... (2 Replies)
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Hi,
I have a problem where I need to make this input:
nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a
nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b
look like this output:
nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
Hi,
I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!
Input:
1 1 ABC DEF
2 2 IJK LMN
1 2 ZYX OPW
Output:
1 2 ZYX OPW (2 Replies)
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Hi Team
I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows .
For example :
Column 1 Column2
Jan,Feb Hold,Sell,Buy
Expected Result
Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies
LEARN ABOUT PHP
iconv_mime_decode_headers
ICONV_MIME_DECODE_HEADERS(3) 1 ICONV_MIME_DECODE_HEADERS(3)iconv_mime_decode_headers - Decodes multiple MIMEheader fields at onceSYNOPSIS
array iconv_mime_decode_headers (string $encoded_headers, [int $mode], [string $charset = ini_get("iconv.internal_encoding")])
DESCRIPTION
Decodes multiple MIME header fields at once.
PARAMETERS
o $encoded_headers
- The encoded headers, as a string.
o $mode
-$mode determines the behaviour in the event iconv_mime_decode_headers(3) encounters a malformed MIME header field. You can spec-
ify any combination of the following bitmasks.
Bitmasks acceptable to iconv_mime_decode_headers(3)
+------+--------------------------------------+---+
|Value | | |
| | | |
| | Constant | |
| | | |
| | Description | |
| | | |
+------+--------------------------------------+---+
| 1 | | |
| | | |
| | ICONV_MIME_DECODE_STRICT | |
| | | |
| | If set, the given header is decoded | |
| | in full conformance with the stan- | |
| | dards defined in RFC2047. This | |
| | option is disabled by default | |
| | because there are a lot of broken | |
| | mail user agents that don't follow | |
| | the specification and don't produce | |
| | correct MIME headers. | |
| | | |
| 2 | | |
| | | |
| | ICONV_MIME_DECODE_CONTINUE_ON_ERROR | |
| | | |
| | If set, iconv_mime_decode_head- | |
| | ers(3) attempts to ignore any gram- | |
| | matical errors and continue to | |
| | process a given header. | |
| | | |
+------+--------------------------------------+---+
o $charset
- The optional $charset parameter specifies the character set to represent the result by. If omitted, iconv.internal_encoding will
be used.
RETURN VALUES
Returns an associative array that holds a whole set of MIME header fields specified by $encoded_headers on success, or FALSE if an error
occurs during the decoding.
Each key of the return value represents an individual field name and the corresponding element represents a field value. If more than one
field of the same name are present, iconv_mime_decode_headers(3) automatically incorporates them into a numerically indexed array in the
order of occurrence.
EXAMPLES
Example #1
iconv_mime_decode_headers(3) example
<?php
$headers_string = <<<EOF
Subject: =?UTF-8?B?UHLDvGZ1bmcgUHLDvGZ1bmc=?=
To: example@example.com
Date: Thu, 1 Jan 1970 00:00:00 +0000
Message-Id: <example@example.com>
Received: from localhost (localhost [127.0.0.1]) by localhost
with SMTP id example for <example@example.com>;
Thu, 1 Jan 1970 00:00:00 +0000 (UTC)
(envelope-from example-return-0000-example=example.com@example.com)
Received: (qmail 0 invoked by uid 65534); 1 Thu 2003 00:00:00 +0000
EOF;
$headers = iconv_mime_decode_headers($headers_string, 0, "ISO-8859-1");
print_r($headers);
?>
The above example will output:
Array
(
[Subject] => Prufung Prufung
[To] => example@example.com
[Date] => Thu, 1 Jan 1970 00:00:00 +0000
[Message-Id] => <example@example.com>
[Received] => Array
(
[0] => from localhost (localhost [127.0.0.1]) by localhost with SMTP id example for <example@example.com>; Thu, 1 Jan 1970 00:00:00 +0000 (UTC) (envelope-from example-return-0000-example=example.com@example.com)
[1] => (qmail 0 invoked by uid 65534); 1 Thu 2003 00:00:00 +0000
)
)
SEE ALSO iconv_mime_decode(3), mb_decode_mimeheader(3), imap_mime_header_decode(3), imap_base64(3), imap_qprint(3).
PHP Documentation Group ICONV_MIME_DECODE_HEADERS(3)