Visit Our UNIX and Linux User Community


Text formatting to 132 columns


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Text formatting to 132 columns
# 1  
Old 04-17-2002
Text formatting to 132 columns

I want to take a file that is generated in 132 columns from a unix based report generator and transfer it to a windows environment and preserve the column length. Any ideas how I can do this so that whatever windows based text editor that reads the document will know it should be in 132 columns?

Thanks.

James
# 2  
Old 04-17-2002
What sort of column delimiter does the file have...?

I'm guessing that each row of the unix file is fairly lengthy....but I wouldn't see why the format will change.... what method of transfer are you using?
# 3  
Old 04-18-2002
I think that "columns" here, he means characters. IE, each line is 132 characters long.

Unix knows where one line end and the next begins because each line is followed by a newline character. The unix newline character and the ASCII linefeed (sometimes abbreviated LF) are the same thing. Windows will need each line to be terminated by a linefeed and a carriage return (LF/CR).

If you use ftp, you need to use ascii mode to tranfer the file. That will cause ftp to perform this translation.

Also, HP-UX has a pair of programs, dos2ux and ux2dos for this purpose. SunOS has dos2unix and unix2dos.
# 4  
Old 04-19-2002
I am running SCO unix and I am generating a text file from a database application that creates rows that are 132 characters long. I then want to e-mail that file to a windows exchange user.

I will see if SCO has some sort of unix2dos type function. Thanks.

James
# 5  
Old 04-19-2002
It may be that you can just email it. Have you tried this? I would expect it would work. Email software should handle everything.
# 6  
Old 04-19-2002
Unfortunately simply e-mailing it does not solve the problem. I e-mail it as an attachment to a Microsoft Exchange account and it doesn't preserve the 132 character line.
# 7  
Old 04-20-2002
I have prepared a file that is 132 characters per line. It has dozens of adjacent spaces. I have been unable to reproduce your problem. Even using mailx and mailing the file as the body worked. We are using Exchange as our mail server and I am using Outlook as my mail program.

Try to mail to file to yourself on your unix account. Maybe your unix mail program is garbling the file.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #1010
Difficulty: Easy
The number 200 in base 8 equals 128 in base 10.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash formatting data into columns

Hi guys, I'm trying to create a table of aggregated data using just bash commands. My data is in three columns, for example: 2014-01-01 testA 64 2014-01-01 testB 27 2014-02-01 testA 31 2014-02-02 testB 29 2014-02-02 testC 12 And the result I am looking for is: ... (4 Replies)
Discussion started by: mccmjc
4 Replies

2. Shell Programming and Scripting

Perl syntax for formatting columns and text

Dear all, Pzl let me know what is the syntax for converting the columns format to text as i have lots of values for but when i put these values in xls sheet the values are automatically converted to and one more question i have is how to call values from shell script into perl script eg. ... (3 Replies)
Discussion started by: sagar_1986
3 Replies

3. Shell Programming and Scripting

How to concatenate 2-columns by 2 -columns for a text file?

Hello, I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between. input file: 1 0 0 1... (10 Replies)
Discussion started by: huiyee1
10 Replies

4. Shell Programming and Scripting

Formatting columns in file

I have a script that creates a file with three column output. The columns look like this: Policy Name Name Volume VLS-EDWARDS-ARCHIVED_FILE-WINDOWS 10 12 XLZ-BASE-CYGWIN-ARCHIVED-FILE-LINUX 2 21 ZLX-GOLD-FILES-JAPANFILERS1-LINUX 20 27 ZLX-GOLD-FILES-JAPANFILERS2-LINUX13 29... (4 Replies)
Discussion started by: newbie2010
4 Replies

5. Shell Programming and Scripting

formatting columns

Hi I have a file that is several gigs in size and basically I want to change the format of it. Obviously I cannot go through it manually. The file looks like this: 897 2 901 2 905 2 909 2 913 2 917 2 921 2 925 2 929 2 933 2 937 2 941 2 945 2 949 0 (1 Reply)
Discussion started by: kylle345
1 Replies

6. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies

7. Shell Programming and Scripting

Formatting output in columns

I have a file which contains data in below format: nbkv28s MgmtReporting -> TradingDesk 1 nbkv28s RMBS -> Credits 178 nbkv28s RMBS -> PassThrough 96 nbkv28s RMBS -> Prepayment 111 nbkv28s RMBS -> RMBSHome 370 nbkv28s RMBS -> TradingStrategy 98 nbkvnze RMBS -> RMBSHome 85 nbkvugn GSF... (3 Replies)
Discussion started by: mohsin.quazi
3 Replies

8. UNIX for Dummies Questions & Answers

Formatting a line of data into columns

Hi all, I'm a little stuck with a data file I've been collecting data in. The file contains one field of data running continuously down the file and I can't work out how to format the data into three columns. This is a mock up of the file: Each r# is a random number and varies in length, this... (3 Replies)
Discussion started by: nistleloy
3 Replies

9. Shell Programming and Scripting

Formatting info into columns

Hi This question has kind of been asked before but I couldn't get any of the solutions to work. I need to format fields being cut from a file into columns so it looks like a table. e.g Full name Address Hiredate Joe Smith London 11.01.01 Bill King ... (8 Replies)
Discussion started by: straight_edge
8 Replies

Featured Tech Videos