Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Trailing spaces chopped off - MF to Unix FTP.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Trailing spaces chopped off - MF to Unix FTP.
# 1  
Old 08-10-2007
Trailing spaces chopped off - MF to Unix FTP.
We receive fixed width ASCII (not EBCIDIC) file from MF to UNIX server. We have trailing spaces in the file.

What happens during FTP transmission, those trailing spaces gets chopped off. Is there any option in FTP when to transfer file from mainframes to unix not to chop off those spaces?
# 2  
Old 08-10-2007
transfer as 'binary'.
# 3  
Old 08-10-2007
Porter

Do you mean transfer mode should be used as 'bin'? If we do that, we will receive data in EBCDIC format.

Data file originally on the mainframe is in EBCDIC format during FTP transmission we choose 'ascii' option.
# 4  
Old 08-10-2007
Ok - I am not a mainframe programmer. At least, not IBM.

We had a similar issue at a previous company. Required them to put an X in the last column, to force the spaces to be maintained.

Just a thought.
# 5  
Old 08-10-2007
videsh,

This is based on my experience.

If the Record Format of your file on Mainframe is 'VB' (Variable Block) then during FTP transmission (ascii mode) the trailing spaces will be removed.

If the Record Format of your file on Mainframe is 'FB' (Fixed Block) then during FTP transmission (ascii mode) the trailing spaces of the line will be displayed on unix.

Smilie
# 6  
Old 08-10-2007
Quote:
Originally Posted by videsh77
If we do that, we will receive data in EBCDIC format.
Use 'dd' to convert from EBCDIC to ASCII.
# 7  
Old 08-13-2007
Hemang, the transmission team told me they are sending file in Fixed Block format in ascii transmission mode.
Is it possible for you to provide the command from your transmission team please?

awk,
At moment we are using the approach you have suggested as a temporary fix. In the long run we are asked not to use this temporary solution.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Trim trailing spaces from file

I have a file like this. hari,corporationbank,2234356,syndicate ravi,indian bank,4567900000000,indianbank,accese raju,statebank of hyderabad,565866666666666,pause Here each record has different record length and there are blank spaces... (8 Replies)
Discussion started by: kshari8888
8 Replies

2. UNIX for Dummies Questions & Answers

Want to add trailing spaces to the variable

I want to keep string/varible length to 10 even its actual length is less than 10(may be no value). so, i want to add trailing spaces to my string. :wall: "typeset -L10 myvarible" is not working, its saying invalid typset -L option. Can you please advise. (4 Replies)
Discussion started by: djaks111
4 Replies

3. Shell Programming and Scripting

How to remove trailing spaces from a variable?

I am getting a value from a csv file using CUT command, however the command extracting the records with trailing spaces. I am using the result into a sql session to fetch data, because of the trailing spaces the sql session is unable to fetch any data. Please let me know, how to remove this... (2 Replies)
Discussion started by: mady135
2 Replies

4. Shell Programming and Scripting

[solved] Trailing spaces

Hello People How to check whether lines in a text file have trailing spaces or not and if a line have trailing spaces then how many trailing spaces line have? Regards ARvind kumar (5 Replies)
Discussion started by: arvindk.monu
5 Replies

5. Shell Programming and Scripting

remove trailing spaces from a line

I want to remove the trailing spaces from any line of file. line ending does not follow any pattern. plz help (3 Replies)
Discussion started by: vikas_kesarwani
3 Replies

6. UNIX for Dummies Questions & Answers

Remove Trailing spaces after a delimiter

Hi, I am trying to remove trailing white spaces using this command in awk nawk -F '|' '/^TR/{t = $4 }/^LN/{gsub(/ */,"");printf "%s|%s\n", t, $0 }' $i>>catman_852_files.txt My delimiter is '|'. THere are some description fields which are being truncated. I dont want to remove spaces... (1 Reply)
Discussion started by: kiran_418
1 Replies

7. UNIX for Dummies Questions & Answers

How to remove trailing spaces

Hi, I have a file like this (ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa ------------------------------------------------------------ 2007-06-30 00:00:00 I have a requirement where i need just the date. When i do: tail -1... (2 Replies)
Discussion started by: mahek_bedi
2 Replies

8. Shell Programming and Scripting

Strip leading and trailing spaces only in a shell variable with embedded spaces

I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help. echo $SH_VAR | command_line Syntax. The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies

9. UNIX for Dummies Questions & Answers

Adding Trailing Spaces to a file

I have a text file which is not fixed width. I want to put trailing spaces to each line and make it a 100 byte fixed width file. Can someone please help me as soon as possible? Thanks, Denis (1 Reply)
Discussion started by: 222001459
1 Replies

10. Shell Programming and Scripting

Leading and Trailing Spaces

Hi, how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line example of a line in the input data: Amy Reds , 100 , /bin/sh how to i get it to be: Amy Read,100,/bin/sh i saw something on this on the Man pages for AWK... (7 Replies)
Discussion started by: sleepster
7 Replies
Login or Register to Ask a Question