File column separator


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File column separator
# 1  
Old 07-07-2009
File column separator

Hi
I have one file named pd.txt containing
Code:
0009910006101000001UNR OXYMETAZOLINE SPRAY 15ML 0831-30 OXYMETAZOLINE HCL PCK UNDEFINED NA 11420027305UNRURL PHARMA URL PHARMA NOSQC-SPRAY 0000--000000015000000001---1984-12-01ETH N006770831300999992 10006101023340000{0903032 X

0009910008001000004NV- 4-WAY SPRAY 15ML 4-WAY PCK UNDEFINED NA 11431009100NV-NOVARTIS CONS HLTH NOVARTIS CONS HLTH NOSQC-SPRAY 0000--000000015000000001---1987-11-01ETH N198100058010999992 10008001259320000{0901253 X

0009910008001000010NV- 4-WAY SPRAY 30ML 4-WAY PCK UNDEFINED NA 11431009100NV-NOVARTIS CONS HLTH NOVARTIS CONS HLTH NOSQC-SPRAY 0000--000000030000000001---1987-11-01ETH N000672086010999992 10008001259320000{0901253 X

0009910008001500015NV- 4-WAY SPRAY 15ML 0728-01 4-WAY PCK UNDEFINED NA 11420009100NV-NOVARTIS CONS HLTH NOVARTIS CONS HLTH NOSQC-SPRAY 0000--000000015000000001---1978-03-01ETH N198100575010999992 10008001259320000{0901253 X

I need to cut columns as
cut -c 001-019,020-059,060-089,090-101,102-113,114-131,132-136,137-137,138-142,143-147,148-150,151-180,181-210,211-213,214-216,217-221,222-229,230-233,234-235,236-244,245-253,254-256,257-266,267-270,271,272-282,283-284,285-288,289,290,291-297,315 pd.txt

but after every range of column I have to add one delimeter say"~"

Please help me
Thanks in advance
# 2  
Old 07-08-2009
Follow the same for other columns as well.

Code:
 
 sed -e 's/./&~/19' -e 's/./&~/59' -e 's/./&~/89' pd.txt

# 3  
Old 07-09-2009
Thanks for you help

Quote:
Originally Posted by lathavim
Follow the same for other columns as well.

Code:
 
 sed -e 's/./&~/19' -e 's/./&~/59' -e 's/./&~/89' pd.txt


Thank you
# 4  
Old 07-09-2009
Hi lathavim,
Can you please explain this 's/./&~/19' part.

thanks in advance
# 5  
Old 07-09-2009
Hi,

DOT indicates single character.

&~/19 - Append "~" symbol after 19th character.
# 6  
Old 07-09-2009
Thanks very much Lathavim
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

File command return wrong filetype while file holds group separator char.

hi, I am trying to get the FileType using the File command. I have one file, which holds Group separator along with ASCII character. It's a Text file. But when I ran the File command the FileType is coming as "data". It should be "ASCII, Text file". Is the latest version of File... (6 Replies)
Discussion started by: Arpitak29
6 Replies

2. Shell Programming and Scripting

CSV file column separator

Hi, I have a CSV file of 40 columns with "," as delimiter. I want to assign the value of each column to a variable. But some of the columns content inside contains "," so how can i split the columns and assign it to a variable. Regards, ARASU. (1 Reply)
Discussion started by: Arasu123
1 Replies

3. Shell Programming and Scripting

Putting a separator in file using awk/bash

I have a file with the following content: a-123-345-232 a-23343-4545-545 a-67676-45454-8787 a-129-8912-9824 b-564-78678-2322 b-5454-76767-8899 b-85554-124-152-29 c-34534-654543-323 (... and so on, actually these are pretty huge records) Now, I want that the file should not be broken in to... (8 Replies)
Discussion started by: askerbis
8 Replies

4. Shell Programming and Scripting

How to reverse all columns of a file having some field separator?

Hello, I have a file: xandyandz x & y & z x*y*z*a I require output as: zandyandx z & y & x a*z*y*x here all lines have different field seperator (and & * )based on that i want to reverse the column of a file. Pl. help. (8 Replies)
Discussion started by: nehashine
8 Replies

5. Shell Programming and Scripting

Rename a file based on a specific separator

Hello, I am new to shell I have a folder which contains a list of files, all the files contain the separator : I need to replace this character for all the filenames (by batch) ex: hello:world should become hello-world please help Thanks (3 Replies)
Discussion started by: sikilaklak
3 Replies

6. Shell Programming and Scripting

file separator issue

Dear All, this is very quick question from all the user need your real help. I have a file in a format like ############################### 20111213-01:00:00 ##################################################### |1002|0.7|3.9421424319336|/opt/bea/j2sdk1.4. |8241|0.5|0.43139228816|esd... (3 Replies)
Discussion started by: jojo123
3 Replies

7. Shell Programming and Scripting

embed a separator after each word in a text file

Folks, can anyone throw a code snippet here to insert a comma " , " after each word in a line when doing a file read and output the delimited text to a file. Appreciate your help Venu (9 Replies)
Discussion started by: venu
9 Replies

8. Shell Programming and Scripting

Help in formating a file with field separator

hi thanks a lot But pls help me if my input file is the below format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Name2 priya2 2010-09-21 10:43:49 TEXT ID 1 hi1 TEXT ID 2 how1 TEXT ID 3 r1 (4 Replies)
Discussion started by: bha148
4 Replies

9. Programming

Missing Separator Issue in Make file

Hi All, I am using Make to compile my java code. I am pasting the portion which is creating an issue. install: $(FPR_FILES) if test $OS = "Linux"; then @echo "TEST" -$(INS) -d -m 775 $(INSDIR)/linux/deployment cp -R $(ROOT)/deployment $(INSDIR)/linux/deployment ... (3 Replies)
Discussion started by: ngopalakrishna
3 Replies

10. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies
Login or Register to Ask a Question