Search Results

Search: Posts Made By: arunkumar_mca
186
Posted By arunkumar_mca
Match file and extract the output
Hi All

I have 2 file . I need match the files based on key and then form a third file which have the matching values

FILE1:
10264;K*AD
10265;K*AIR
10266;K*AUTO
10267;K*BABY
10268;K*...
955
Posted By arunkumar_mca
Extract a column and multiple by 1000 and replace it on same file
Hi All,

I need to extract a position in the file and multiple the value by 1000 and the replace it .

Original
0010001200084701217637306521200000000000010010000000 ---> 000847 * 1000...
1,082
Posted By arunkumar_mca
Thanks the below worked . Is there a way I can...
Thanks the below worked . Is there a way I can sum those values to total. I get the each row doing the operation but I need to sum up those rows

awk '{print ( ( substr($0,50,5) * substr($0,55,6)...
1,082
Posted By arunkumar_mca
Multiply values from a file
Hi All,

I extracted a file using an awk command like this

awk '{print substr($0,78,5)"," substr($0,59,6) "," substr($0,81,3) "," substr($0,11,7)}' file1 >> OUTPUT
cat OUTPUT...
136
Posted By arunkumar_mca
Execute a script after SFTP transfer
Hi All,

I am having an issue with the script execution. I am having a SFTP process that send files to a location . I want to execute a script once it transfer the file to that location. Right...
132
Posted By arunkumar_mca
Thanks for the input . I should have been more...
Thanks for the input . I should have been more clear. This sed will convert all blank space to non blank. There is a change that other position can be blank. I need to move these only based on...
132
Posted By arunkumar_mca
Shift record from one position to another
Hi All,

I have a file and it is a fixed length file. I want to move the values from 42,6 ( where 6 is length) to the 36th position


Original file:
00000100000100000100000100000100001 ...
166
Posted By arunkumar_mca
Replace a numeric values in a certain column
Hi All,

I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7

I tried

awk...
136
Posted By arunkumar_mca
I want to match only 1,8 position and match the...
I want to match only 1,8 position and match the record. Is there a way I can add in thew awk ? . I tried the below and it is not getting me any output

awk 'NR==FNR{a[substr($0,1,8)];next} ($2 in...
136
Posted By arunkumar_mca
Matching 2 files based on key
Hi all

I have two files I need to match record from first file and second file on column 1,8 and and output only match records on file1

File1:...
Forum: Programming 01-24-2019
319
Posted By arunkumar_mca
Very strange output with casting
Hi All,

I am having a strange issue. Below is the code snippet. If I print fraction * (double)::pow((double)10,scalingFactor) which is a double I am getting 154 when I type cast that to int as...
171
Posted By arunkumar_mca
Ignoring decimal in comparision
HI All,

I am having a requirement on ignoring mismatch on 2 file

File 1:
A,B,US,10.02
A,B,US,10.02
A,B,US,11.02
File 2:
A,B,US,10.02
A,B,US,10.00
A,B,US,12.02

Here I want to...
288
Posted By arunkumar_mca
sed and replace
Hi All,

I am trying to replace ", " with ",". For I am getting below error. I think I am missing something. I tried to escape the , with \ still I see the same error


Input...
405
Posted By arunkumar_mca
I should have said that "_SB" or "_B". I know...
I should have said that "_SB" or "_B".
I know it is against the form to post personal comment. @peasant I was trying to do in parallel to see how I can get this in from SQL. I was not being rude...
405
Posted By arunkumar_mca
I am using Redhat Linux. In my example I have SB...
I am using Redhat Linux. In my example I have SB alone so it should be CONC- BC. Things I have tried

cut -d' ' -f1,2,3 test.desc - where test.desc is my file. This will bring me from 2nd segment...
405
Posted By arunkumar_mca
Help with pattern match and Extract
Hi All,

I am having a file like below . Basically when SB comes in the text with B. I have to take the word till SB. When there only B I should take take till B. Tried for cut it by demilter but...
483
Posted By arunkumar_mca
It worked partially (K>) awk -f change.awk...
It worked partially

(K>) awk -f change.awk input.csv
id,description,type,year
994475;1832 + S PP1829 10/17/18;S;P201829;115;N;4,4;M;0;xx994475;*;BA7005;10/17/2018 16:48
994477;1836 + S...
483
Posted By arunkumar_mca
I missed the column in the input. Input...
I missed the column in the input.


Input with columns
994475;1832 + S PP1835 10/17/18;S;P201835;115;N;4,4;M;0;xx994475;*;BA7005;10/17/2018 16:48
994477;1836 + S PP1839...
483
Posted By arunkumar_mca
First my apologize for not putting the actual...
First my apologize for not putting the actual data.

ORIGINAL
994475;1832 + S PP1835 10/17/18;S;P201835;115;N;4,4;M;0;xx994475;*;BA7005;10/17/2018 16:48
994477;1836 + S PP1839...
483
Posted By arunkumar_mca
Changing CSV files with date . Subtracting date by values
Hi All,

I have a CSV file which is as below. Basically I need to take the year column in it and find if the year is >= 20152 . If that is then I should subtract all values by 6. In the below...
253
Posted By arunkumar_mca
Removing pipe and space in a file
Hi ,

I have a file which is like below. The file record is separated by | as delimiter. I want to remove the first and last | in the file and also I want to remove the spaces in the columns.
...
472
Posted By arunkumar_mca
Adding quotes in printlog worked. Thanks a lot
Adding quotes in printlog worked. Thanks a lot
472
Posted By arunkumar_mca
this is the script . The printlog is called and...
this is the script . The printlog is called and the sqlcmd print select and all the files name in the log

_bkp_table_name=processed$_timestamp
_sqlcmd="select * into $_bkp_table_name from...
472
Posted By arunkumar_mca
The problem is with the echo. The execute $sql...
The problem is with the echo. The execute $sql work fine. When it echo it expand it and print all file
472
Posted By arunkumar_mca
Wild char getting expanded in echo
Hi All,
I am having a issue in a script. I am trying to execute a select * from a scirpt to a database and printing the the sql string. The * in the sqltring is printing all the files in the...
Showing results 1 to 25 of 436

 

Featured Tech Videos

All times are GMT -4. The time now is 08:11 PM.
Unix & Linux Forums Content Copyright 1993-2019. All Rights Reserved.
Privacy Policy