Replacing UNIX 1 byte delimiters to the pipe separator
Hi
I am new to Unix Shell scripting have a requirement where I have to replace the "unix 1 byte delimiter" with the "pipe" separator and also remove any carriage returns and line feeds if any
The Source File
Code:
4 QFH Jungle Hill 32-34 City Road London SE23 3UX
the output should be
Code:
4|QFH|Jungle Hill|32-34 City Road|London|SE23 3UX
Thanks
Last edited by Scrutinizer; 11-30-2015 at 01:11 PM..
Reason: need to add the command I am trying to execute; mod: code tags and removed excessive formatting
In my server migration requirement, I need to compare if one file on old server is exactly the same as the corresponding file on the new server.
For diff and comm, the inputs need to be sorted. But I do not want to disturb the content of the file and need to find byte-to-byte match.
Please... (4 Replies)
Hi,
I want to replace a field in a text delimited file with the actual number of records in the same file.
HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ
DTL|0|5464-1|0|02-02-2008|02-03-2008||||F|||||||||
DTL|1|5464-1|1|02-02-2008|02-03-2008|1||JJJ... (3 Replies)
Hello All,
I have a file with thousands of records:
eg:
|000222|123456987|||||||AARONSON| JOHN P|||PRIMARY |P
|000111|567894521|||||||ATHENS| WILLIAM k|||AAAA|L
Expected:
|000222|123456987|||||||AARONSON| JOHN |P|||PRIMARY |P
|000111|567894521|||||||ATHENS| WILLIAM |k|||AAAA|L
I... (6 Replies)
Hi
I have an input CSV file which contains some values
Format of file is as follows:
32R01000000003144476;32R01000000029054270;1000;6000;12/12/2007;0382521276;REG;Régulari
I just need to validate it whether it is ';' seperated ie (if any other seperator is used it shld give an error)
How do... (5 Replies)
Hi,
I need to split the fields in some text strings into separate variables.
The fields are separated by pipes.
The strings look roughly like this:
CUSTNAME|hostname|userid|gecos field|staff|disabled||SUDO
Currently I can do it using something like cut -d"|" -f1, but when I put that into... (4 Replies)
Hi,
I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values.
1|10/15/2011|fname1|lname1
2|10/15/2012|fname2|lname2
3|10/15/2013|fname3|lname3
Output file:
1||fname1|lname1
2||fname2|lname2
3||fname3|lname3
I tried this
... (2 Replies)
I have a pipe delimited file and I'm trying to write a script that will give the character/byte positions of each pipe in the file. There may be some simple way but I don't know what it is... Can someone help with this?
Ex: file has output below
abc|def|ghi|
I want the script to tell the... (1 Reply)
Discussion started by: basz808
1 Replies
LEARN ABOUT BSD
mcopy
MCOPY(1) General Commands Manual MCOPY(1)NAME
mcopy - copy MSDOS files to/from Unix
SYNOPSIS
mcopy [ -tnvm ] sourcefile targetfile
mcopy [ -tnvm ] sourcefile [ sourcefiles... ] targetdirectory
DESCRIPTION
Mcopy copies the specified file to the named file, or copies multiple files to the named directory. The source and target can be either
MSDOS or Unix files.
The use of a drive letter designation on the MSDOS files, 'a:' for example, determines the direction of the transfer. A missing drive des-
ignation implies a Unix file whose path starts in the current directory
Mcopy will allow the following command line options:
t Text file transfer. Mcopy will translate incoming carriage return/line feeds to line feeds.
n No warning. Mcopy will not warn the user when overwriting an existing file.
v Verbose mode.
m Preserve the file modification time.
If the target file already exists, and the -n option is not in effect, mcopy asks whether or not to overwrite the file.
MSDOS subdirectory names are supported with either the '/' or '' separator. The use of the '' separator or wildcards will require the
names to be enclosed in quotes to protect them from the shell.
The mcd command may be used to establish the device and the current working directory (relative to MSDOS), otherwise the default is A:/.
SEE ALSO mcd(1), mread(1), mwrite(1)BUGS
Unlike MSDOS, the destination directory may not be omitted.
The '+' operator (append) from MSDOS is not supported.
No other Mtools command requires the use of a drive letter designation on MSDOS files.
local MCOPY(1)