Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Remove Special Characters from Mainframe File

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Rodger Zhang

New User


Joined: 04 Jul 2016
Posts: 3
Location: Canada

PostPosted: Wed Jul 06, 2016 1:12 am    Post subject: Remove Special Characters from Mainframe File
Reply with quote

Hi there,

Retrieve and output a file in Mainframe using SAS. Various special characters appear in front of some character strings which shift the position of the columns. Looked at mainframe output file, it's empty (space) in EDIT mode but dots can be seen in BROWSER mode. Detail can be seen from attachment.

Any help is appreciated.

Thanks.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Jul 06, 2016 1:34 am    Post subject:
Reply with quote

Welcome!!
How did you download it with what options? Next time, please paste here the code and wrap under the code tags which will preserve space than uploading.
This is not a DFSORT question, is it? May need to be moved to 'All Other Mainframe Topics'
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Wed Jul 06, 2016 1:35 am    Post subject:
Reply with quote

Did you look at the data in hex mode (EDIT or BROWSE)? Are they different characters or the same character? Do you know if they are in the original source or just appear after the SAS program runs?
Back to top
View user's profile Send private message
Rodger Zhang

New User


Joined: 04 Jul 2016
Posts: 3
Location: Canada

PostPosted: Wed Jul 06, 2016 5:18 pm    Post subject: Reply to: Remove Special Characters from Mainframe File
Reply with quote

Thanks everyone.

Viewed with HEX ON, the same - it's a empty (space) in EDIT mode and dot (.) in BROWSER mode. It probably has something to do with the format, but can't figure it out by googling.

Thanks.

Rodger
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Jul 06, 2016 6:03 pm    Post subject:
Reply with quote

I think you may be need to see for SAS character Encoding options or colition Capabilities used during the download.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Wed Jul 06, 2016 6:20 pm    Post subject:
Reply with quote

Quote:
Viewed with HEX ON, the same - it's a empty (space) in EDIT mode and dot (.) in BROWSER mode.
If this is true, there is something SERIOUSLY wrong. Here is a couple of lines in EDIT mode:
Code:
Command ===>                                                  Scroll ===> CSR   .
000210 //* ëëç.....(Ñ>ÀèÁÊ_¬.....(Ñ>ÀÂÊÑÅÇÈ.ëëç..                               .
000300 //                                                                       .
****** **************************** Bottom of Data **************************** .
and the same two lines with HEX ON:
Code:
 Command ===>                                                  Scroll ===> CSR   
 000210 //* ëëç.....(Ñ>ÀèÁÊ_¬.....(Ñ>ÀÂÊÑÅÇÈ.ëëç..                               
        665455444444466656765444444666676667455444444444444444444444444444444444
        11C0338BBBBBD9E4452DFBBBBBD9E4229784B338BB000000000000000000000000000000
 ------------------------------------------------------------------------------ 
 000300 //                                                                       
        664444444444444444444444444444444444444444444444444444444444444444444444
        110000000000000000000000000000000000000000000000000000000000000000000000
 ------------------------------------------------------------------------------ 
 ****** **************************** Bottom of Data ****************************
If you turned HEX ON, you should be seeing the hexadecimal representations of the data -- in BROWSE or EDIT mode. If you are not, as I said there is something SERIOUSLY wrong and you need to contact your site support group IMMEDIATELY for assistance.
Back to top
View user's profile Send private message
Rodger Zhang

New User


Joined: 04 Jul 2016
Posts: 3
Location: Canada

PostPosted: Wed Jul 06, 2016 9:59 pm    Post subject: Reply to: Remove Special Characters from Mainframe File
Reply with quote

Thanks.

As some of the dots in front of the fields turn to be strange characters after downloading, I tried and tested moving the position from source file. It seemed that I got the right values after moving 2 positions further right than the layout specified. So I think we are good now.

Thanks again for everyone's advice and contribution. Much appreciated.

Rodger
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us