MVSFORUMS.com

Vish · Posted: Mon Sep 22, 2003 12:04 pm Post subject: A problem with delimited file

Friends,
I have a delimited file containing 3 filelds being uploaded to mainframe.
Here below I am pasting 2 records
When I go in the Browse mode
206.200.SEATTLE
206.201.BAINBDG IS

When I go in the Edit mode
206 200 SEATTLE
206 201 BAINBDG IS

Hex on (Edit)
206 200 SEATTLE
FFF0FFF0ECCEEDC44444444
20652005251333500000000
-----------------------
206 201 BAINBDG IS
FFF0FFF0CCCDCCC4CE44444
20652015219524709200000

My requirement is to remove the gap between the filelds. I need the modified records like 206200SEATTLE. How can I do this with the simplest possible way ?
_________________
Vish

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

c all p'.' ''

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Please check if ISPF edit can be used. If the file length is longer this process may through the file out of balance. Try to use the hex value thru a sort process to eliminate the non-displayable characters.

kolusu · Posted: Mon Sep 22, 2003 1:44 pm Post subject:

Vish,

If the fileds are of fixed length then you can use sort to remove the tab character(x'05'). If it is variable then sort may not the right tool to get the desired results.

Easytrieve is one tool which comes to my mind to achieve the desired results.

Hope this helps...

cheers

kolusu