07-16-2014
You probably just need to add DOS-style end-of-line markers (CRLF rather than LF) - check if you have unix2dos on your system, or use tr/sed.
If that doesn't work, you need to post a sample of your csv file.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Can a hard drive be formatted from unix server to windows 2000 professional? (4 Replies)
Discussion started by: howarddtp
4 Replies
2. UNIX for Dummies Questions & Answers
i have a txt file in which it contains some lines each line contains some 350-400 characters
but when i read the file line by line in ksh it is telling the max characters in each line is between 100-127 characters
in each line it contains some values with some spaces in between
when i try to... (2 Replies)
Discussion started by: trichyselva
2 Replies
3. Shell Programming and Scripting
Hi,
I am using the following format command for formatting my text file in unix.
awk -F":" '{ printf "%-50s%-1s%-50s\n", $1,":", $2}' filename > targetfile
The target file is then sent as an attachment via email.
When I view the target file in notepad multiple lines get spanned as a... (2 Replies)
Discussion started by: AAA
2 Replies
4. UNIX for Dummies Questions & Answers
I so desperately need a script to copy a windows csv file to my unix server and i know these should be at dummies but i have no bits. it is life & no job situation help please. thanks (1 Reply)
Discussion started by: zhegal
1 Replies
5. Shell Programming and Scripting
Hi ,
I have a text file noname.txt containing 1000+ records like this. One of the record I have given below.
Input will b e like this
BOT:
2010/06/01 00:25:59
21 = "private"
Access-Method = 31
NCC = GBR
01 =... (5 Replies)
Discussion started by: smalya
5 Replies
6. Shell Programming and Scripting
Hi Experts,
I have a requirement where i need to setup a batch job which runs everymonth and move the pdf files from unix server to windows servers.
Could some body provide the inputs for this.
and also please provide the inputs on how to map the network dirve in the unix like that... (1 Reply)
Discussion started by: ger199901
1 Replies
7. Shell Programming and Scripting
Hi,
Am using the following command to create a csv file
paste File_1.csv File_4.csv File_7.csv >Out1.csv
paste File_2.csv File_5.csv File_8.csv >>Out1.csv
paste File_3.csv File_4.csv File_9.csv >>Out1.csv
Input Data:
Expected Output:
Column 1 Column 2 ... (2 Replies)
Discussion started by: meva
2 Replies
8. Shell Programming and Scripting
Hi, I am new to this subject.....Can someone please help me out with the script...
unix usernm "sdhftst"
unix pwd "chsd13"
windows usernm "dfghtst"
windows pwd "chsd13"
path..../xxx/xxxxx/xxxxxx/xxxxxxx
please can u get me a script...its only one file to get ftp.
Thanks... (2 Replies)
Discussion started by: himakiran9
2 Replies
9. Shell Programming and Scripting
hi, please help me with the below
1)i have a file like below with data
389096
389097
389098
..and i need some thing like below
'389096','ZZ1111'
'389097','ZZ1111'
'389098','ZZ1111'
2)i have a file like below with data
8300003225
8300003223
8300006494 (7 Replies)
Discussion started by: kr123
7 Replies
10. UNIX Desktop Questions & Answers
Hi all,
I wish to know whether Unix can access window's file in Unix's terminal?
Apart from that, how to copy files or share files between Window and Unix? I get to know of secure copy, however, my company's Unix does not support the feature of secure copy? Any other method for me to share/... (5 Replies)
Discussion started by: jessy83
5 Replies
LEARN ABOUT OPENSOLARIS
unix2dos
unix2dos(1) User Commands unix2dos(1)
NAME
unix2dos - convert text file from ISO format to DOS format
SYNOPSIS
unix2dos [-ascii] [-iso] [-7]
[-437 | -850 | -860 | -863 | -865] originalfile convertedfile
DESCRIPTION
The unix2dos utility converts ISO standard characters to the corresponding characters in the DOS extended character set.
This command may be invoked from either DOS or SunOS. However, the filenames must conform to the conventions of the environment in which
the command is invoked.
If the original file and the converted file are the same, unix2dos will rewrite the original file after converting it.
OPTIONS
The following options are supported:
-ascii Adds carriage returns and converts end of file characters in SunOS format text files to conform to DOS requirements.
-iso This is the default. Converts ISO standard characters to the corresponding character in the DOS extended character set.
-7 Converts 8 bit SunOS characters to 7 bit DOS characters.
On non-i386 systems, unix2dos will attempt to obtain the keyboard type to determine which code page to use. Otherwise, the default is US.
The user may override the code page with one of the following options:
-437 Use US code page
-850 Use multilingual code page
-860 Use Portuguese code page
-863 Use French Canadian code page
-865 Use Danish code page
OPERANDS
The following operands are required:
originalfile The original file in ISO format that is being converted to DOS format.
convertedfile The new file in DOS format that has been converted from the original ISO file format.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
SEE ALSO
dos2unix(1), ls(1), attributes(5)
DIAGNOSTICS
File filename not found, or no read permission
The input file you specified does not exist, or you do not have read permission. Check with the SunOS command, ls -l (see ls(1)).
Bad output filename filename, or no write permission
The output file you specified is either invalid, or you do not have write permission for that file or the directory that contains it.
Check also that the drive or diskette is not write-protected.
Error while writing to temporary file
An error occurred while converting your file, possibly because there is not enough space on the current drive. Check the amount of
space on the current drive using the DIR command. Also be certain that the default diskette or drive is write-enabled (not write-pro-
tected). Notice that when this error occurs, the original file remains intact.
Translated tmpfile name = filename.
Could not rename tmpfile to filename.
The program could not perform the final step in converting your file. Your converted file is stored under the name indicated on the
second line of this message.
SunOS 5.11 14 Sep 2000 unix2dos(1)