MVSFORUMS.com

sateesh_gontla · Posted: Wed May 18, 2005 1:43 pm Post subject: How to extract delimited data

Hi

I have the following record layout and like to have as :

"R97446","ABC D EFGHI","ABC.D.EFGHIxyz.com"

O/p should be :
Here "XXXXX" are 5 spaces between each word.

R9744XXXXXABC D EFGHIXXXXXABC.D.EFGHIxyz.com

Could anyone get this done using SYNCSORT ? Please help me.

Thanks.

kolusu · Posted: Wed May 18, 2005 1:48 pm Post subject:

sateesh_gontla,

Is the position of the comma and the double quotes fixed?

ex:

sateesh_gontla · Posted: Wed May 18, 2005 1:52 pm Post subject:

Thanks for quick reply,

No, every record has its own length and the delimiter vary for every record. But max record length for 1 record is 80 chars.

Thanks,
sateesh.
_________________
Regards,
Sateesh

kolusu · Posted: Wed May 18, 2005 2:09 pm Post subject:

sateesh_gontla,

There are no built-in features of sort that can used on variable delimiters. However you can write a quick easytrieve or sas pgm to delimit the record.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Frank Yaeger · Posted: Thu May 04, 2006 11:54 am Post subject:

advoss · Beginner Joined: 23 Aug 2005 Posts: 26 Topics: 0

If you have SAS available and are proficient with it you can easily parse out this file using INFILE DELIMITER="," DSD TRUNCOVER;
_________________
Alan Voss