#!/usr/bin/ksh
##################################################################
#
# Remove Control M characters and invalid line break from the specified fil
# usage: removeInvalidChar FileName
#
####################################################################
find 2013/02/14 -name 'SASMMF*_FISUP_DURDSARCHIVE_ID*.dat*' | while read file
do
echo "1. in loop."
IXT = substr($0,869,869);
echo $IXT
awk ' NR>1 && substr($0,869,869) == "1" {
echo "2. loop 2"
TS = substr($0,11,27) + 0;
if(TS>=20130116000000000&&TS<=20130119000000000) {
R = R RS $0;
c++;
}
} END {
printf "Count=%d\n", c;
printf "Records%s", R;
printf "\n"
}' "$file" >> file_prov_coutry_time.csv
done
The above code gives me an error ")" not allowed @ line # 13
I f I want to check to see if substr($0,869,869) returns how many 1s and how mnay 0s and how many 2s from each file and print the statistics in a file along with the file name.
Code:
RETURN VALUE =1 COUNT = 30 FILE NAME = 'SASMMF1_FISUP_DURDSARCHIVE_ID1.dat
RETURN VALUE =0 COUNT = 10 FILE NAME = 'SASMMF1_FISUP_DURDSARCHIVE_ID1.dat
RETURN VALUE =2 COUNT = 5 FILE NAME = 'SASMMF1_FISUP_DURDSARCHIVE_ID1.dat
RETURN VALUE =0 COUNT = 2 FILE NAME = 'SASMMF2_FISUP_DURDSARCHIVE_ID2.dat
Is there a command that sets a variable length?
I have a input of a variable length field but my output for that field needs to be set to 32 char.
Is there such a command?
I am on a sun box running ksh
Thanks (2 Replies)
Newbie
Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23.
Thanks in advance for your assistance.
tbtbs
input file:... (12 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
hi
i have two types of file
1. temp.0000000001.data (10 digit numeric)
2. temp.000000001.data (9 digit numeric)
i want to search a file which is having 10 digit numeric in between the file name.
i use command like this..
ls | grep temp.^*.data
but this will give both the files as... (2 Replies)
Hi,
I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value.
How can I do that in a single step. (6 Replies)
How do I extract values in a few columns in a row of a fixed length file?
If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column?
The below command will give... (1 Reply)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Hi,
I have a DB2 UDB 9.7 SQL script, as follows:
I need to pass the script into Unix and generate a fixed length file from this.
Can someone kindly provide a script to achieve it?
SELECT
CAST(COALESCE(CL_ID,'000000000') AS CHAR(9)) AS CL_ID
,STATUS... (5 Replies)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
LEARN ABOUT PHP
strripos
STRRIPOS(3) 1 STRRIPOS(3)strripos - Find the position of the last occurrence of a case-insensitive substring in a stringSYNOPSIS
int strripos (string $haystack, string $needle, [int $offset])
DESCRIPTION
Find the numeric position of the last occurrence of $needle in the $haystack string.
Unlike the strrpos(3), strripos(3) is case-insensitive.
PARAMETERS
o $haystack
- The string to search in.
o $needle
- If $needle is not a string, it is converted to an integer and applied as the ordinal value of a character.
o $offset
- If specified, search will start this number of characters counted from the beginning of the string. If the value is negative,
search will instead start from that many characters from the end of the string, searching backwards.
RETURN VALUES
Returns the position where the needle exists relative to the beginnning of the $haystack string (independent of search direction or off-
set). Also note that string positions start at 0, and not 1.
Returns FALSE if the needle was not found.
Warning
This function may return Boolean FALSE, but may also return a non-Boolean value which evaluates to FALSE. Please read the section on
Booleans for more information. Use the === operator for testing the return value of this function.
EXAMPLES
Example #1
A simple strripos(3) example
<?php
$haystack = 'ababcd';
$needle = 'aB';
$pos = strripos($haystack, $needle);
if ($pos === false) {
echo "Sorry, we did not find ($needle) in ($haystack)";
} else {
echo "Congratulations!
";
echo "We found the last ($needle) in ($haystack) at position ($pos)";
}
?>
The above example will output:
Congratulations!
We found the last (aB) in (ababcd) at position (2)
SEE ALSO strpos(3), stripos(3), strrpos(3), strrchr(3), stristr(3), substr(3).
PHP Documentation Group STRRIPOS(3)