Search Results

Perfect, thank you!

It's a korn shell. I am afraid I don't know all the technical bits of operating etc

Thanks for this but alas I get an error...

perry[5]: expiry_date="${expiry_date:3:2}/${expiry_date:0:2}/${expiry_date:6}": 0403-011 The specified substitution is not valid for this command.

...

This is the first line of the file...

1,PJGSW-YXQR55-1905,10,30/12/2016

Thanks, this is the part of code...

while read line
do

vouchercode=`echo ${line} | awk -F, '{ print $2}'`
partnumber=`echo ${line}| awk -F , '{ print $3 }'`
expiry_date=`echo ${line}| awk...

I am hoping someone can help me with this issue.

I am extracting a date from a file that is in DD/MM/YYYY format using...

expiry_date=`echo ${line}| awk -F, '{ print $4 }' | tr -d '\r'`

What...

Hi

I have a file which contains customer data...

I need to be able to strip out everything from the file so I am only left with the order number (0000000000000912906R)

The lenght of the...

Hi

I have a text file that has four columns (Logonid,First Name,Last Name,Status)

Logonid First Name Last Name Status
abc2 Fred Mercury Inactive
abc1 John ...

Hi

In the below query userreg.status returns a value of 1 (Active) or -1 (Non Active). Ideally, I would like to replace this automatically on the export so instead of getting 1 or -1 I get Active...

It brings back 11 which I assume is the line count if you don't count the header row.

This is brilliant and if I could just ask you to explain how the command is put together so I can use it for...

The corrupted one would look like this ...

An abridged version with details amended to not give away customers details!

I have a text file that is generated each morning and 9/10 runs perfectly. However, every now and again it fails and it is a nightmare to find the line that is corrupt as this job fails in the early...

This issue has been causing me a headache all night....

I have a file, from a third party payment vendor, that contains an export of data including an order number (unique) and a payment value,...

Thanks everyone for their help so far. I almost there but one thing has been causing me issues all day....

paste $prog $pan | sed "s/^/\'/" | sed 's/$/',/g' | sed '$s/,$/') with ur;/' >...

Many thanks for both replies. If I wanted to seperate file1 and file2 with a | sign do I need to have this in file1 or file2 already or can it be added as part of the paste?

I have a script that produces two output files each containing the same number of lines <file1.txt> and <file2.txt>. What I need to do is combine both files into a new file <file3.txt> where line 1...

Thanks for the swift reply but I really need this to be included in a ksh script that will run from the crontab as I need to use the dates as variables when it comes to generating the reports.

Any...

I need to generate a report on the first of each month that will show me how many points are going to expire on a particular scheme for the next three months. The points expiry is not an issue what I...

Top man, thanks.

./pjg

Thanks for the swift reply.

This is bringing back 10-01-2010 when I need it bring back:

2010-10-01

Could you please advise what would be required to get it in this format.

Thanks

./pjg

Sorry to be a pain but coould you show me what I would need to amend to make the date in yyyy-mm-dd format. I've tried switiching the parameters around but I end up with some very weird results!
...

Hi

I need to produce a report that the start date must be the first day of the current quarter. Therefore a repor that is run today the start date would be 01/10/2010 (ddmmyyyy).

Obvioulsy I...