IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Remove Special Characters from Mainframe File


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Wed Jul 06, 2016 1:34 am
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Jul 06, 2016 1:35 am
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
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Wed Jul 06, 2016 6:03 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Jul 06, 2016 6:20 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
Search our Forums:

Back to Top