Thanks for all the replies guys. The closest I get to work on the actual (real) file I am using is ygemici's suggestion.
The actual file I am using looks like :
After running :
I get this file concatenated together :
What I was hoping for was the file tabulated into neat columns (probably using the spaces as delimiters)
---------- Post updated at 07:48 AM ---------- Previous update was at 07:45 AM ----------
*NOTE* on my last post - the file I am using as input has staggered rows with spaces in between - NOT concateneated as has appeared in the paste above - sorry! But the output is concatenated as I said.
Last edited by Franklin52; 05-01-2012 at 10:23 AM..
Reason: Please use code tags
hi experts
lets say my format file is B
B
=========
column no,name,type,length
1,ee,N,12
3,hj,N.4
4,kl,N,5
source file
========
d e f g h i
5 8 9 7 6 5
1 3 4 5 6 6 (2 Replies)
I have a file that gets created by pasting 3 files together to get the one file. The output of the 3 files follows.
sft.rtf
c3_critappdb_u5 start 04:22:20 end 08:03:41
c3_critappdb_u6 start 18:01:31 end 20:21:19
c3_critappdb_u7 start 00:02:50 end 08:30:17
c3_critappdb_u8 start 17:00:42 end... (2 Replies)
Hi,
I have a shell script to unload all the empname who have salary >50000 from the emp table into a text file(empname.txt) .
m_db unload "$dbc_file" -column_delimiter ',' -select "SELECT empname FROM emp where salary > 50000" >> empname.txt
Now my text file have data in the following format ... (3 Replies)
Hi,
I have a file with different width for each line. like first line with 45characters and second line of 30 characters. But I want to make all the lines to 45 characters in file.
Appreciate your inputs
Thanks
Arun: (1 Reply)
i have a text file in this format:
name1^A1^B1^
name2^A2^B2^
...
namex^Ax^Bx^
name1^AA1^
name2^AA2^
...
namex^AAx^
name1^AAA1^BBB1^
name2^AAA1^BBB2^
...
namex^AAAx^BBBx^
name1^AAAA1^
name2^AAAA2^
...
namex^AAAAx^
i want to generate a file: (2 Replies)
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
Hi Experts,
Anybody out there figure out on how to achieve in shell scripts or tools. I have done googling to find solutions but no luck.
I have thousands of .txt files to batch process, please see the below sample text content after -------- start here --------. What I want to achieve is to... (10 Replies)