Search Results

Hi Friends,

The solution provided had worked perfectly, and thanks for your detailed input.

Regards,
Ram

Hi,

Yes the file does exist, the problem is when file name ends with date Daily_rose_20170802.csv my code is working perfectly, but when file name is Daily_rose_20170802_report.csv after date...

Hi,

I am trying to download files from FTP using below FTP code.


x=$(TZ=CST date +%Y%m%d)
host='xxx.xx.xxx.xxx'
user='userX'
pass='Password'
echo "Connecting to FTP Host -- $host....."...

Hi,

I am trying to extract data where first field unique value and 4th field of next row is grater than first row 4th field.

input data is a below:


7035719974,20-jul-2016...

I developed a script to group by 1st column and sum few of the column which are required, but while executing sum of 2nd column which has decimals in place is not getting correct sum. below is the...

Thanks Ravindra,

It has worked perfectly and I am going to have good time now.

This will help me to save lot of time in converting my data.

Regards,
Ram

Hi Ravindra,

Thanks you very much for your much needed help, however regret to bother you again. I find that the data was present in below format


<Node>xxxxxx
<Node>yyyyy</Node>...

I regret for the inappropriate words used in my post.
I am using CYGWIN to perform this task. I searched thru this forum to fix my issue, and found many useful codes, but all the outputs are...

Hi,

I have an XML file and I am tring to extract some data form it, after lot of data cleaning process, I ended up with an issue, and need your urgent support.

my current input data in...

Thank you very much it's working great, and output is as desired.

I am having data in XML format and trying to extract codes form two fields called <String>, below is the data.
...

Thanks RudiC for your support, I am trying with the code you provided with litle modification but the code is not providing any output, awk -F"," '
BEGIN {OFS=","
OFMT="%.2f"
}...

Hi,

I have an issue converting decimal places of a particular column, i am using below script to get the output, but the output is not generating in desired format.


awk -F","...

Hi Sea,

Thanks for youre quick reply, however the issue is that, position of CSP is not fixed, it varies depending on other informations. I need something to identify position of CSP then extract...

Hi,

I am trying to extract a specific information from a file which contains more than 200 million records. Attached the input file for your reference.

My file contains information below
...

Dear Rudic,

if you will see my abc.txt where I am having a record which is haing value of 120, where as in bcd, my value is 1201 & 1203, since 120 of abc.txt, is matching with first 3 digit of...

Dear RudiC,

With some wild guessing I presume that you want to match entries based on the smallest common substring. But some questions remain:

Below are my comments against your Query.
Will...

Hi,

I have two files one (abc.txt) is having approx 28k records and another (bcd.txt) on is having 112k records, the length of each files are varried.

I am trying to look up abc.txt file with...

Thanks RudiC, this has worked perfectly as pre the desired output. But would like to know how does this works. can yo please be kind to explain.

Thanks again.

Hi All,

We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1"...

As I have mentioned above, Output file format RequiredDLKRISPSRM1_Missing Sequence

Just missed that part, it's the part of PSIN & PSRM as the split of each file.

Regret for inconvenience.

Hi,

I have a file which contains few columns and the first column has the file names, and I would like to identify the missing file sequence number form the file and would copy to another file....

Hi,

Thanks for all you support, and regret for the confusion created, actually below code worked the desired output, I was required simplly the file name to be added at the beginning of each line...

Hi,

I have multiple files having many lines like as bvelow:

file Name a.txt
abc def
def xyz
123 5678



file Name b.txt
abc def
def xyz
123 5678


I would like to append...