Posted: Fri Feb 18, 2005 9:16 am Post subject: Date convertion
Hi All,
I have a date field in a file which iam extracting. If the date field is zeros , I want to replace with spaces.
This is the Sort utility i am using to extract few fields from file and also i need to to add conditions to convert the dates if zeros to spaces.
Quote:
SORT,FIELDS=(1,7,CH,A),
OUTREC FIELDS=(1:1,7,
8:8,1,
9:15,4,
13:19,6,
19:31,4,
23:35,2,
25:37,4,
29:41,6, -- If i get zeros, i should replace with spaces.
35:50,3,
38:54,3,
41:57,6,
47:63,6,
53:91,6,
59:147,6,
65:184,4,
69:249,1)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum