|
View previous topic :: View next topic
|
| Author |
Message |
anand1204
New User
Joined: 16 Jan 2015
Posts: 12
Location: USA
|
|
|
|
Hi,
I have a file & it has date fields in 2 different places (say 1st date filed in 10th Position & 2nd date field in 20th position).
Now i need to compare the dates and write into another file if 10th position date is greater than 20th position date. Can you please help me out??
e.g
| Code: |
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102 |
Now my output file should have only
| Code: |
----+----1----+----2----+----3---
20150102 20150101
20150103 20150102
20150201 20150102 |
Thanks,
Anand
[coded] |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
please use the code tags to present code, data, screenshots and anything else requiring retention of spaces. Did you not notice that your data display did not match your words?
Coded for you this time - but maybe not next time.
With code tags:
| Code: |
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102 |
Without code tags:
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102 |
|
| Back to top |
|
|
anand1204
New User
Joined: 16 Jan 2015
Posts: 12
Location: USA
|
|
|
|
Thanks Nic, I didnt realize it will not retain spaces.
| Nic Clouston wrote: |
please use the code tags to present code, data, screenshots and anything else requiring retention of spaces. Did you not notice that your data display did not match your words?
Coded for you this time - but maybe not next time.
With code tags:
| Code: |
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102 |
Without code tags:
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102 |
|
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| Quote: |
| I didnt realize it will not retain spaces. |
You mean you did not check your post after submitting it? Bad, very bad - not just in a forum but in your work in general. |
|
| Back to top |
|
|
|
|
