To find the last 2 chars in each line using SORT

sridevi_l01 · New User Joined: 10 Jun 2005 Posts: 2

Hi,
I need to find the last 2 characters of each line in a file using SORT (not ICETOOL).
Eg
ab123;45;kjg; -> g;
12;ddd;45;88 -> 88
ytr;55;;; -> ;;

The position where the last 2 chars occurs in the file is not fixed.
Pls help me with a sort card to achieve the same.

Thanks.

Alain Benveniste · New User Joined: 14 Feb 2005 Posts: 88

What do you mean by find. Do you want to extract records if a condition is met, do you want only the 2 last characters of the records or what else.
Could you clarify your need

Alain

sridevi_l01 · New User Joined: 10 Jun 2005 Posts: 2

I want to extract the last 2 chars present in each line of the file.

MGIndaco · Posted: Fri Jun 10, 2005 7:06 pm

I can't understand your request about the use of DFSORT or ICETOOL.
But in each case... which is its record format and the LRECL?

Frank Yaeger · Posted: Fri Jun 10, 2005 9:42 pm

sridevi_l01,

I assume you're trying to extract the last 2 characters before the first blank in each line ... right? SORT products do not have any built-in functions for doing this kind of find and extract operation.

I'd suggest using programming logic (REXX, COBOL, an E15 exit, whatever you're comfortable with) to do this.

Frank Yaeger · Posted: Tue May 09, 2006 5:01 am