Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

manipulate the textfile having strings

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting manipulate the textfile having strings
# 1  
Old 01-21-2010
manipulate the textfile having strings
i have text files named like vho1.txt, vho2.txt... vho15.txt.In all there are 15 in number.
each file has strings like
Code:
\Movies On Demand\Action & Adventure|X-Men: Wolverine|2009-09-29 00:01:00|2010-03-24 23:59:00|Active|3
\Movies On Demand\Free\Free1|My movie 14|2010-01-11 00:00:00|2010-03-01 23:59:59|Active|4

i have to introduce pipes in the same string after the second pipe(|) depending on the number at the last column (if the number is 3, it should have 3 ||| in that string, if 4 , |||| pipes).

Please help me out.
Thanks in Advance.
Last edited by Franklin52; 01-21-2010 at 02:02 PM.. Reason: Please use code tags!
# 2  
Old 01-21-2010
you mean like this way???
Code:
\Movies On Demand\Action & Adventure|X-Men: Wolverine||||2009-09-29 00:01:00|2010-03-24 23:59:00|Active|3
\Movies On Demand\Free\Free1|My movie 14|||||2010-01-11 00:00:00|2010-03-01 23:59:59|Active|4

then try this..
Code:
awk -F"|" '{printf "%s|%s",$1,$2}{for(i=0;i<=$NF;i++){printf "|"}}{printf "%s|%s|%s|%s\n",$3,$4,$5,$6}' filename

# 3  
Old 01-21-2010
Another one:
Code:
awk -F"|" '{for(i=0;i<$NF;i++){$2=$2"|"}}1' OFS="|" file

# 4  
Old 01-21-2010
Thanks for the answers. i have tried like this but it didn't work

Code:
#looping through all the files VHO1.txt,VHO2.txt....
for i in `ls VHO?.txt`
do
 #getting the last column value
  var2=echo $i|cut -f 6 -d "|" $i
# this is done to conditonally insert the pipes in each line based on the last column value.
if [ $var2 -eq 3 ]
then 
#inserting the pipes as suggested and redirecting to file
awk -F"|" '{printf "%s|%s",$1,$2}{for(i=0;i<=$NF;i++){printf "|"}}{printf "%s|%s|%s|%s\n",$3,$4,$5,$6}', $i > F$
fi
done

pls. correct me where it is wrong.it just prints last column value on the console..
Last edited by pludi; 01-21-2010 at 04:16 PM.. Reason: code tags, please...
# 5  
Old 01-21-2010
Quote:
Originally Posted by ramse8pc
Thanks for the answers. i have tried like this but it didn't work

#looping through all the files VHO1.txt,VHO2.txt....
for i in `ls VHO?.txt`
do
#getting the last column value
var2=echo $i|cut -f 6 -d "|" $i
# this is done to conditonally insert the pipes in each line based on the last column value.
if [ $var2 -eq 3 ]
then
#inserting the pipes as suggested and redirecting to file
awk -F"|" '{printf "%s|%s",$1,$2}{for(i=0;i<=$NF;i++){printf "|"}}{printf "%s|%s|%s|%s\n",$3,$4,$5,$6}', $i > F$
fi
done

pls. correct me where it is wrong.it just prints last column value on the console..
this will do the whole part.. check the last column value and if its 3 inserts the 3 pipe...
Code:
 
awk -F"|" '$NF==3{{printf "%s|%s",$1,$2}{for(i=0;i<=$NF;i++){printf "|"}}{printf "%s|%s|%s|%s\n",$3,$4,$5,$6}}' $i > F$

# 6  
Old 01-21-2010
awesome!. it worked. thanks guys.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Variablecontent in a Textfile

I want to save a variablecontent in a Textfile. How can i do that? These works only with ls shell_exec("ls > text.txt");Please use code tags, thanks (2 Replies)
Discussion started by: Linuxmann
2 Replies

2. Shell Programming and Scripting

Replicating certain lines in a textfile

I am very new to to shell scripting and facing a problem that I can't seem to solve. I want to write a bash script that edits file1.txt and saves it as file2.txt. This is what the files should look like: file1: textline1 textline2 startCopy copyThis endCopy textline3 textline4 file2: ... (6 Replies)
Discussion started by: sandy90
6 Replies

3. Shell Programming and Scripting

How to separate sorte different characters from one textfile and copy them in a new textfile?

My first post, so don't kill me :) Say i open some textfile with some example like this. on the table are handy, bread and wine Now i know exactly what is in and i want to separate and sorted it in terminal to an existing file with another 2 existing lines in like this: table plane ... (3 Replies)
Discussion started by: schwatter
3 Replies

4. Windows & DOS: Issues & Discussions

Use Textfile for variables ?

So... I have a text file that contains this (hex.txt): #8C7CA6 #6C70A5 #75777C #959A90 #7A7C6C #867DAB #80867E #8A87BD #6B71C6 #8F8A79 #9A9DCE #7E87D0 #69709E #82968C #7C8F81 #A3917B (5 Replies)
Discussion started by: pasc
5 Replies

5. Shell Programming and Scripting

Change value in a textFile

Hi everyone, I need to make a script to take three parameters: -> KEY -> NEW_VALUE -> FILE The FILE is a text plane file. The KEY is a variable to configure, for example: KEY1 = HOLA KEY2= HOLA KEY3=HELLO KEY4 =HOLA And the... (4 Replies)
Discussion started by: Xedrox
4 Replies

6. UNIX for Dummies Questions & Answers

Creating textfile from arguments

Hi all I'm new to this forum and I really hope someone can help me out with a (for you guys) fairly easy question. I want to have a script that takes 1-14 arguments, all numbers 1-14, say myscript 1 3 4 5 7 what the script shall do is basically generare a textfile that contains 16... (5 Replies)
Discussion started by: Tobbev
5 Replies

7. Shell Programming and Scripting

awk search strings from array in textfile

I am wanting to take a list of strings and loop through a list of textfiles to find matches. Preferably with awk and parsing the search strings into an array. // Search_strings.txt tag string dummy stuff things // List of files to search in textfile1.txt textfile2.txt The... (6 Replies)
Discussion started by: sdf
6 Replies

8. Shell Programming and Scripting

How to extract more than 1 line in a textfile ?

Hi, I'm starting a little project with a shell script but I'm don't know how to do it. Maybe someone can help me. I have un text file like this : I'd like to do a script who will extract from my file from @ADDLINE1@ to @ADDLINE4@ only and I have no idea how to do this. Any idea ? ... (7 Replies)
Discussion started by: Poulki
7 Replies

9. Shell Programming and Scripting

Textfile lesson

Tag allerseits Ich habe ein umfangreiches Script. Darin möchte ich zu Beginn ein textfile lesen. Den ersten Satz. Dann kommen mehrere Instruktionen und dann soll wieder gelesen werden. Den zweiten Satz. Etc. Ich kann also das herkömmliche while read xyz / do ... done nicht benützen. ... (0 Replies)
Discussion started by: lazybaer
0 Replies

10. Shell Programming and Scripting

plugging out value from a textfile

Hi, need some help from all of you as i'm a beginner in shellscript. Currently i have a textfile(filename.txt) with the below content: TOTAL: 30 RECORDS: 300 anyone one know how do i plug out the value of 30 and put into a variable(var1) and 300 into another variable(var2)?I'm coding using... (7 Replies)
Discussion started by: snowfrost
7 Replies
Login or Register to Ask a Question