Thanks Ranga.... your command working fine and i redirected to new file.
But in the original file when i press end it is showing as 3001 but in the new generated file it is showing as 3002. Please let me know what could be the reason.
thanks,
Kiran
Last edited by Scrutinizer; 12-21-2012 at 07:17 AM..
Reason: code tags
Hi guys,
I want to use a quick one liner that can copy an entire column, and add it to a new file as another column. I've tried using cat, but that only appends my column to the bottom of the file.
So now, my first file(file1) looks like this:
1995060101 8
1995060102 6
1995060102... (1 Reply)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi,
i have file which contains only one record like below
a|b|c|....
The no of columns is not known. The expected output is as below:
a|a|b|b|c|c|...
Please provide me your suggestions.
OS: unix
Thanks,
Selva (7 Replies)
I want to copy column no 3 to the end of column
example :
alter table RECOVER_USR.MPULKIXD rename to
alter table RECOVER_USR.CS_ADV_PROMO rename to
alter table RECOVER_USR.BCH_HISTORY_TABLE rename to
alter table BILLOPS.HISHAM_DATAPLUS_FINAL rename to
alter table... (8 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Dear Gurus,
I have a unix file 2 columns (# delimited) with the following data:
ZTXX_CTBR1-ZBRAN1#ZTXX_CTBR1-ZBRAN_DESC#
01#CASH & CARRY#
02#DRUGSTORE - RX#
04#SUPERMARKET#
05#HYPERMARKET#
17#DRUGSTORE - NO RX#
I would like to have a code that will do 2 things:
1. Delete the header... (16 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT PHP
iconv_substr
ICONV_SUBSTR(3) 1 ICONV_SUBSTR(3)iconv_substr - Cut out part of a stringSYNOPSIS
string iconv_substr (string $str, int $offset, [int $length = iconv_strlen($str, $charset)], [string $charset = ini_get("iconv.inter-
nal_encoding")])
DESCRIPTION
Cuts a portion of $str specified by the $offset and $length parameters.
PARAMETERS
o $str
- The original string.
o $offset
- If $offset is non-negative, iconv_substr(3) cuts the portion out of $str beginning at $offset'th character, counting from zero.
If $offset is negative, iconv_substr(3) cuts out the portion beginning at the position, $offset characters away from the end of
$str.
o $length
- If $length is given and is positive, the return value will contain at most $length characters of the portion that begins at
$offset (depending on the length of $string). If negative $length is passed, iconv_substr(3) cuts the portion out of $str from
the $offset'th character up to the character that is $length characters away from the end of the string. In case $offset is also
negative, the start position is calculated beforehand according to the rule explained above.
o $charset
- If $charset parameter is omitted, $string are assumed to be encoded in iconv.internal_encoding. Note that $offset and $length
parameters are always deemed to represent offsets that are calculated on the basis of the character set determined by $charset,
whilst the counterpart substr(3) always takes these for byte offsets.
RETURN VALUES
Returns the portion of $str specified by the $offset and $length parameters.
If $str is shorter than $offset characters long, FALSE will be returned.
SEE ALSO substr(3), mb_substr(3), mb_strcut(3).
PHP Documentation Group ICONV_SUBSTR(3)