Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Formatting file data to another file (control character related)
Top Forums Shell Programming and Scripting Formatting file data to another file (control character related) Post 302704611 by Lem on Saturday 22nd of September 2012 12:41:25 PM
Old 09-22-2012
Uhm.
What's wrong with:
Code:
lem@biggy:/tmp$ while IFS="|" read -r T_NAME P_NAME P_CODE _PATH _DATE; do
cat <<END >>outfile
T_NAME  $T_NAME
P_NAME  $P_NAME
P_CODE  $P_CODE
PATH    $_PATH 
DATE    $_DATE

END
    done <infile
lem@biggy:/tmp$ cat outfile
T_NAME  SPARK
P_NAME  CYBER_DEF
P_CODE  XRS001
PATH    abcabc\\nababa\\tc
DATE    2012-09-09 12:34:54.005

lem@biggy:/tmp$

Or, according with your preferences:
Code:
lem@biggy:/tmp$ while IFS="|" read T_NAME P_NAME P_CODE _PATH _DATE; do
cat <<END >>outfile
T_NAME  $T_NAME
P_NAME  $P_NAME
P_CODE  $P_CODE
PATH    $_PATH
DATE    $_DATE

END
     done <infile
lem@biggy:/tmp$ cat outfile
T_NAME  SPARK
P_NAME  CYBER_DEF
P_CODE  XRS001
PATH    abcabc\nababa\tc
DATE    2012-09-09 12:34:54.005

lem@biggy:/tmp$

--
Bye
This User Gave Thanks to Lem For This Post:
hk6279
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Control character in a file

Hi All, I am looking for a solution to capture any ASCII control character in a file ( where the ASCII control character is in decimal value from 0 to 31 and 127 ( Hex value from 00 to 1F and 7F ) ) by returning any affected lines. The intended good file should contain "ASCII printable... (5 Replies)
Discussion started by: cursive
5 Replies

2. Shell Programming and Scripting

Checking for a control file before processing a data file

Hi All, I am very new to Shell scripting... I got a requirement. I will have few text files(data files) in a particular directory. they will be with .txt extension. With same name, but with a different extension control files also will be there. For example, Sample_20081001.txt is the data... (4 Replies)
Discussion started by: purna.cherukuri
4 Replies

3. UNIX for Dummies Questions & Answers

How to find the ^M(control M) character in unix file?

can any one say about command to find "^M" (Control M)characters in a unix text file. ^M comes when a file ftped from windows to unix without using bin mode. I need the command to find lik this, ex.txt: ------------------------------ ...,name,time^M go^M ...file,end^M... (5 Replies)
Discussion started by: prsam
5 Replies

4. Shell Programming and Scripting

formatting data file with awk or sed

Hi, I have a (quite large) data file which looks like: _____________ header part.. more header part.. x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 ... ... x59 x60 y1 y2 y3 y4... ... y100 ______________ where x1, x2,...,x60 and y1, y2,...y100 are numbers of 10 digits (so each line... (5 Replies)
Discussion started by: lego
5 Replies

5. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

6. Programming

Problem with control file and special character

I am getting error when loading data file using ctl file. I get this error only when there is special character. Below is some data. DataFile=> company_id|ciu_id|english_name|iso_country_code|active|partner_name 1-2JT-122||Expert Järvenpää|FI|A|Expert Järvenpää Control File=> LOAD DATA... (1 Reply)
Discussion started by: rshivarkar
1 Replies

7. Shell Programming and Scripting

perl cmd to remove the control-Z character at end of 10GB file

In a 10-50GB file , at end of file there is Control-z character tried the below options, 1. perl -p -i -e 's/^Z//g' new.txt 2. perl -0777lwi -032e0 new.txt and Sed command, dos2unix etc it takes more time to remove the control-z. need a command or perl program to GO TO LAST LINE OF FILE ... (7 Replies)
Discussion started by: prsam
7 Replies

8. Shell Programming and Scripting

control M character in unix file

in a file we are getting control character in a file , is there any way that they can be removed once we have the file for eg. BEGIN-PROCEDURE INITIALIZE ^M LET #row_count = 0^M ^M ^M (2 Replies)
Discussion started by: lalitpct
2 Replies

9. UNIX for Dummies Questions & Answers

Formatting data in a raw file by using another mapping file

Hi All, i have a requirement where i need to format the input RAW file ( which is CSV) by using another mapping file(also CSV file). basically i am getting feed file with dynamic headers by using mapping file (in that target field is mapped with source filed) i have to convert the raw file into... (6 Replies)
Discussion started by: ravi4informatic
6 Replies

10. Shell Programming and Scripting

Formatting data to put it in the excel file

Hello, I have a file with the below contents : Policy Name: Backup_bkp Policy Type: Catalog_bkp Active: yes Effective date: 08/07/2013 02:02:12 Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies

LEARN ABOUT FREEBSD

deb-old

deb-old(5)							    dpkg suite								deb-old(5)

NAME

       deb-old - old style Debian binary package format

SYNOPSIS

       filename.deb

DESCRIPTION

       The  .deb  format  is the Debian binary package file format. This manual page describes the old format, used before Debian 0.93. Please see
       deb(5) for details of the new format.

FORMAT

       The file is two lines of format information as ASCII text, followed by two concatenated gzipped ustar files.

       The first line is the format version number padded to 8 digits, and is 0.939000 for all old-format archives.

       The second line is a decimal string (without leading zeroes) giving the length of the first gzipped tarfile.

       Each of these lines is terminated with a single newline character.

       The first tarfile contains the control information, as a series of ordinary files. The file control must be present,  as  it  contains  the
       core control information.

       In  some  very  old  archives,  the  files  in  the  control  tarfile  may optionally be in a DEBIAN subdirectory. In that case, the DEBIAN
       subdirectory will be in the control tarfile too, and the control tarfile will have only files in that  directory.  Optionally  the  control
       tarfile may contain an entry for '.', that is, the current directory.

       The second gzipped tarfile is the filesystem archive, containing pathnames relative to the root directory of the system to be installed on.
       The pathnames do not have leading slashes.

SEE ALSO

       deb(5), dpkg-deb(1), deb-control(5).

1.19.0.5							    2018-04-16								deb-old(5)
All times are GMT -4. The time now is 01:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy