Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cut rowcount from one file to another

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut rowcount from one file to another
# 15  
Old 07-10-2009
Quote:
Originally Posted by PsmakR
Hi!

I'd like to have only this row:

Code:
COMPANY_CODE;COMPANY_NAME;COMPANY_DESC;CORPORATION_CODE;CORPORATION_NAME;CORPORATION_DESC;SOURCE_SYSTEM;LEGAL_ENTITY

without any special characters after it like CHR(13) and CHR(10).

Regards,

Psmakr
In this case there is no need to substitute ; with space as ksh-ji did.
You can simply say
Code:
 head -1 inputfile

Where am I miunderstanding the requirement?
# 16  
Old 07-10-2009
Maybe need to remove chr(13)
cat dosfile | tr -d "\015" > file
after that works my script.

---------- Post updated at 11:11 AM ---------- Previous update was at 11:08 AM ----------

Code:
#!/usr/bin/ksh
# read one line from file = 1st
cat orgfile | tr -d "\015" > file
read first < file
# replace all ; -> space
first=${first//;/ }
echo $first > somefile

chmod a+rx thisscript

If you have not ksh, maybe bash ?
#!/usr/bin/bash
# 17  
Old 07-10-2009
rakeshawasthi,

you head command doesnt work, still after all the characters there are chr(13) and chr(10).

PsmakR


---------- Post updated at 03:17 AM ---------- Previous update was at 03:14 AM ----------

Hi!

cat dosfile | tr -d "\015" > file

Im not sure if it works yet because it cuts more then first row ;/

PsmakR
# 18  
Old 07-10-2009
Why dont you trim the chr(13) and chr(10) the way ksh-ji suggested after doing head -1.
Else Please share the output you got with my command.
# 19  
Old 07-10-2009
Reading more carefully the real need, this is my answer ... 1st remove chr(13) and then print out without newline.
Code:
echo -n "$(cat orgfile | tr -d "\015"  | head -1 )"  > newfile
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using :<<cut / cut to comment out block of bash script

I am using : << cut / cut to comment out block of code. Works fine on few lines of script, then it gives me this cryptic error when I try to comment out about 80 lines. The "warning " is at last line of script. done < results 169 echo "END read all positioning parameters" 170... (8 Replies)
Discussion started by: annacreek
8 Replies

2. Shell Programming and Scripting

How to cut a pipe delimited file and paste it with another file to form a comma separated outputfile

Hello ppl I have a requirement to split (cut in unix) a file (A.txt) which is a pipe delimited file into A1.txt and A2.txt Now I have to join (paste in unix) this A2.txt with external file A3.txt to form output file A4.txt which should be CSV (comma separated file) so that third party can... (25 Replies)
Discussion started by: etldev
25 Replies

3. Shell Programming and Scripting

Help required the cut the whole contents from one file and paste it into new file

Hi, First of all sincere apologies if I have posted in a wrong section ! Please correct me if I am wrong ! I am very new to UNIX scripting. Currently my problem is that I have a code file at the location /home/usr/workarea/GeneratedLogs.log :- Code :- (Feb 7, 571 7:07:29 AM),... (4 Replies)
Discussion started by: acidburn_007
4 Replies

4. Shell Programming and Scripting

cut the variable from the line and use it to find the file and read the content of that file

Hi, I am working on one script..I am having files in the below format file 1 (each line is separated with : delimeter) SPLASH:SPLASH:SVN CIB/MCH:MCH:SVN Now I want from file 1 that most left part of the first line will store in... (6 Replies)
Discussion started by: rohit22hamirpur
6 Replies

5. Shell Programming and Scripting

cut lines from log file and save it another file

Dears, i want cut the lines from a log file. Example of the log file as follows.. May 27, 2011 5:54:51 PM com.huawei.ivas.utilities.sm.client.SMDeliverContrUtil isDeliverSM FINE: May 27, 2011 5:54:51 PM com.huawei.ivas.utilities.sm.client.SMUtil addSysUpMsgLog INFO: . The message content... (1 Reply)
Discussion started by: tonypalokkaran
1 Replies

6. Shell Programming and Scripting

Creating file from an existing file using CUT, is it the best option?

Dear All, I have a requirement in which i have to load a file placed in FTP location onto my database. The process i'll follow is as below: 1) Get the files using FTP. 2) Create the desired load files as i have to load only 19 fields out of the 104 available in the file. The fields i require... (7 Replies)
Discussion started by: abhishekakaomi
7 Replies

7. Shell Programming and Scripting

Cut Command error cut: Bad range

Hi Can anyone what I am doing wrong while using cut command. for f in *.log do logfilename=$f Log "Log file Name: $logfilename" logfile1=`basename $logfilename .log` flength=${#logfile1} Log "file length $flength" from_length=$(($flength - 15)) Log "from... (2 Replies)
Discussion started by: dgmm
2 Replies

8. Shell Programming and Scripting

Compare the rowcount from tables of two databases

All, I have to create a shell script to comapre the rowcount of 120 tables from two oracle databases. In fact, using informatica the data is loading from 120 source tables to 120 staging tables. After that, they want to have a shell script to comapre the rowcount of all these tables. 1) I... (3 Replies)
Discussion started by: Maya_Pillai
3 Replies

9. UNIX for Dummies Questions & Answers

Need to find a rowcount

Hi All, I have a sequential file, with that I want to know row count within. As know we can use, wc -l filename, to find out a row count. But, I found this command works well , if a file is small. It fails to give me rowcount, if File is pretty big. It keeps on processing after we give the... (3 Replies)
Discussion started by: videsh77
3 Replies
Login or Register to Ask a Question