Find appearance of a particular char in File

puneetvirmani143 · New User Joined: 24 Jul 2007 Posts: 55 Location: noida

Hi,

I have a requirement to read a variable length file with each field delimited by "#". My requirement is to write 10 character to output file appearing after 6th occurence of "#".

Need help. Thanks

Regards
manoj

vasanthz · Posted: Wed Jul 27, 2011 11:37 am

Hello,
Show us the some sample data of the input and required output record layout & LRECL.

puneetvirmani143 · New User Joined: 24 Jul 2007 Posts: 55 Location: noida

01#222#4444#5555#555#66#ABCDEFGHIJ#123123#
002#335555#555#66666#99999#99999#PPPPPPPPPQ#345345

I want the 10 characters appearing after 6th apperance of # ie

ABCDEFGHIJ
PPPPPPPPPQ

vasanthz · Posted: Wed Jul 27, 2011 12:01 pm

Here,
ibmmainframes.com/archive/o_t__t_55402__start_0__index.html

puneetvirmani143 · New User Joined: 24 Jul 2007 Posts: 55 Location: noida

Hi,

The above solution will work when we know the length of each field.

For my case i do not know the length of each data appearing between 2 '#'.

I only know that i have to pick 10 characters appearing after 6th '#'

dbzTHEdinosauer · Posted: Wed Jul 27, 2011 1:05 pm

surya anem · New User Joined: 20 Dec 2007 Posts: 54 Location: Hyderabad

Hi,

I have taken the above link as an example and tried the below sort card.
Can you please check if it suits your requirement.

dbzTHEdinosauer · Posted: Wed Jul 27, 2011 2:24 pm

surya anem,

excellent,
your sort control cards will indeed provide the 10 chars following the 6th occurance of #,

but in case the TS has mistated his problem, and he only wants the characters between the 6th and 7th #, with a max length of 10

this control card will work:

%06=(ENDBEFR=C'#',FIXLEN=10)),

either way, hats off to you for the solution,
which the ts could not manage on his own.