06-11-2012
Ascii Mode appending extra records to csv file
I am relatively new to this forum and Unix scripting.
ksh script:
part 1 :will call a PL\SQL program will create 3 CSV file at the unix directory.
part 2 : will sftp the files to the EFT server.
Once the EFT server receives these file , it will transfer them to a shared windows folders.
EFT team uses tumbleweed tools to configure there settings,
Initially with auto transfer mode, each records in the csv file at the windows shared folder has a weird character "[]" at the end of each line to avoid this we changed the tranfer mode setting to "ascii" . The process runs just fine for small files ( say below 2200 records) for a csv with 2700 records , the EFT received the file right ( size was correct say 10mb) but the file when leaving EFT(with ascii setting on ) increases its size (to say 15 mb) and the final CSV when looked at windows shared folders has 3500+ records (instead of 2700+) records.
when the transfer mode is set back to "auto" , its transfers the file right but with a"[]" at the end of each line.
10 More Discussions You Might Find Interesting
1. SCO
I am unbale to uncompress a file which was compress then moved to another pc in ascii mode instead of binary mode. Is there any way to recover it. Please help us. While uncompress it is giving corrupt input. (3 Replies)
Discussion started by: raj2610
3 Replies
2. Shell Programming and Scripting
I have situation, wherein while reading the file, I intend to write the same file & loop ahead until the end of file.
Problem I am facing is I can only read the file. Like ...
cat file | while read row; do
....
done
So if I write anything to this file within while block, is not read... (4 Replies)
Discussion started by: videsh77
4 Replies
3. Shell Programming and Scripting
Hi Gurus,
I need to find out, if i have transferred a file from ftp thro bin mode or ascii mode. Say if i have a file called "dec.sh"( u shuld normally transfer thro ascii mode). How can i find out that dec.sh is tranferred from ftp server thro ascii mode or bin mode?
Any help would be... (9 Replies)
Discussion started by: Ashok_oct22
9 Replies
4. Shell Programming and Scripting
Hi,
I have a sample file which contains records.
Input File :
1 user1 username1\password@database-name
2 user2 username2\password@database-name
3 user3 username1\password@database-name
I should search for a 'username1\' in those records. If 'username1\' is found in those records, that record... (7 Replies)
Discussion started by: siri_886
7 Replies
5. Shell Programming and Scripting
Trying in this forum. Not sure if it is permitted.... but in need of help.
Please find the requirements in the below link.
https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179
Thanks in Advance. (1 Reply)
Discussion started by: chillblue
1 Replies
6. UNIX for Dummies Questions & Answers
Hi ,
Based on my previous requirement the code works fine for comma as delimiter.
Now my Req is widened up a bit ..
There will be two set of files .. one with comma as delimiter and other with semi-colon ; as delimiter.
Second Sample file.
With Double Quotes (Semi-Colon... (1 Reply)
Discussion started by: chillblue
1 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I got this requirement to process a complex CSV file.
Eg File.
Line 1: Name:,XYz
Line 2: Age:,15
Line 3: Grade:,7
Line 4:
Line 5: English, Maths, Science,Spanish
Line 6:10,11,13,14
As you can see the maximum column is 4 . The file i need to make is
Line 1: Name:,XYz,,... (12 Replies)
Discussion started by: chillblue
12 Replies
8. Shell Programming and Scripting
Hi Freinds ,
I have 2 files .
File 1
|nag|HYd|1|Che
|esw|Gun|2|hyd
|pra|bhe|3|hyd
|omu|hei|4|bnsj
|uer|oeri|5|uery
File 2
|nag|HYd|1|Che
|esw|Gun|2|hyd
|uer|oi|3|uery
output : (9 Replies)
Discussion started by: i150371485
9 Replies
9. Shell Programming and Scripting
Hi Tech Guru,
I have a test file as below , which needs some more fields to be populated randomly :
dks3243;12;20130823;1420;25m;0;syt
dks3243;rocy;10
dks3243;kiop;18
sde21p4;77;20151210;8479;7py;9;vfr
sde21p4;temp;67
sfq6i01;12;20120123;3412;4rd;7;jui
sfq6i01;uymk;90
sfq6i01;kiop;51
... (8 Replies)
Discussion started by: Lokesha
8 Replies
10. Shell Programming and Scripting
Hello Experts,
I got a requirement i have a input file which am getting from different source,Now i want to add extra 3 columns to this file like BASE,ACTUAL and DATE.
Input File Looks like
QUAL CHGE TYP LAW COM1 COM2
A 1 X SED HO ASE
B 3 Z CDE SE ... (5 Replies)
Discussion started by: ahmed.vaghar
5 Replies
TFTP(1) BSD General Commands Manual TFTP(1)
NAME
tftp -- trivial file transfer program
SYNOPSIS
tftp [host]
DESCRIPTION
Tftp is the user interface to the Internet TFTP (Trivial File Transfer Protocol), which allows users to transfer files to and from a remote
machine. The remote host may be specified on the command line, in which case tftp uses host as the default host for future transfers (see
the connect command below).
COMMANDS
Once tftp is running, it issues the prompt and recognizes the following commands:
? command-name ...
Print help information.
ascii Shorthand for "mode ascii"
binary Shorthand for "mode binary"
connect host-name [port]
Set the host (and optionally port) for transfers. Note that the TFTP protocol, unlike the FTP protocol, does not maintain connec-
tions betwen transfers; thus, the connect command does not actually create a connection, but merely remembers what host is to be
used for transfers. You do not have to use the connect command; the remote host can be specified as part of the get or put com-
mands.
get filename
get remotename localname
get file1 file2 ... fileN
Get a file or set of files from the specified sources. Source can be in one of two forms: a filename on the remote host, if the
host has already been specified, or a string of the form hosts:filename to specify both a host and filename at the same time. If
the latter form is used, the last hostname specified becomes the default for future transfers.
mode transfer-mode
Set the mode for transfers; transfer-mode may be one of ascii or binary. The default is ascii.
put file
put localfile remotefile
put file1 file2 ... fileN remote-directory
Put a file or set of files to the specified remote file or directory. The destination can be in one of two forms: a filename on the
remote host, if the host has already been specified, or a string of the form hosts:filename to specify both a host and filename at
the same time. If the latter form is used, the hostname specified becomes the default for future transfers. If the remote-direc-
tory form is used, the remote host is assumed to be a UNIX machine.
quit Exit tftp. An end of file also exits.
rexmt retransmission-timeout
Set the per-packet retransmission timeout, in seconds.
status Show current status.
timeout total-transmission-timeout
Set the total transmission timeout, in seconds.
trace Toggle packet tracing.
verbose Toggle verbose mode.
BUGS
Because there is no user-login or validation within the TFTP protocol, the remote site will probably have some sort of file-access restric-
tions in place. The exact methods are specific to each site and therefore difficult to document here.
HISTORY
The tftp command appeared in 4.3BSD.
Linux NetKit (0.17) August 15, 1999 Linux NetKit (0.17)