kkxlnc
New User
Joined: 12 Jun 2005
Posts: 44
Location: Boston
|
|
|
|
I have a file with data as below
M**********xxxxxxxx*****************
V*************************xxxxxxxx**
When the first variable is 'M':
I have to check if the xxxxxxxx location is spaces. If it is spaces, I need to replace it with a some hard-coded date.
When the first variable is 'V':
I have to check if the other xxxxxxxx location is spaces. If it is spaces, I need to replace it with a some hard-coded date.
Can this be done using Syncsort? |
|
bipinpeter
Active User
.jpg)
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
Hi kkxlnc,
Use the below code
| Code: |
SORT FIELDS=COPY
INREC IFTHEN=(WHEN=(1,1,CH,EQ,C'M',AND,12,10,CH,EQ,C'XXXXXXXXXX'),OVERLAY=(12:C'12/10/2009')),
IFTHEN=(WHEN=(1,1,CH,EQ,C'V,AND,25,10,CH,EQ,C'XXXXXXXXXX'),OVERLAY=(12:C'11/10/2009')) |
Here i am assuming that the hard coded date which you are inserting is different in both cases.If the hard coded value is same you can use the second condition along with first codition using OR keyword. |
|
