|
View previous topic :: View next topic
|
| Author |
Message |
subbu1522
New User
Joined: 11 Sep 2008
Posts: 29
Location: USA
|
|
|
|
I have a condition to include below criteria
| Code: |
{(Company '5' other than policy state VA or TX) OR (Company S policies)} and effective date >= 10/15/2010)
Input file layout: 422 byte.
Company pos 58
State Pos 121-122
Effective date (format mmyydddd in pos 32-39).
|
Could you please help me to split the input file into 2 files.
Input file-1: include the above condition
Input file-2: remaining records from Input file-1. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Which release of which sort product is used on the system? |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
|
Is n't a strange date format? |
|
| Back to top |
|
|
subbu1522
New User
Joined: 11 Sep 2008
Posts: 29
Location: USA
|
|
|
|
Sorry it was my mistake. Date is in mmddyyyy format.
| Code: |
{(Company '5' other than policy state VA or TX) OR (Company S policies)} and effective date >= 10/15/2010)
Input file layout: 422 byte.
Company pos 58
State Pos 121-122
Effective date (format mmddyyyy in pos 32-39).
|
|
|
| Back to top |
|
|
|
|
