Solved

Adding a PIPE delimiter at end of line

Posted on 2000-04-04
5
805 Views
Last Modified: 2012-08-13
I already have parsed a file and delimited it with PIPE (|) --- except after the last field.
Is there a way I can add the PIPE  (|) delimeter at the end of the line without doing the whole thing again? I need some sort of global pattern search and add or update feature.
0
Comment
Question by:tgbekele
  • 2
  • 2
5 Comments
 
LVL 16

Expert Comment

by:maneshr
Comment Utility
you can use the \n char as your reference, since \n indicates end of line. Basically search for \n and replace it with a | and \n

Eg.
lets say each line of your file is stored in a var called $var.
$var is in a loop.

open(FILE,"the_piped_file") || die $!;
while $var(<FILE>){
$var=~ s/\n/\|\n/;
}
close(FILE);

0
 

Author Comment

by:tgbekele
Comment Utility
maneshr,

thank you ... works great as long as the last column in the data is not blank ... for those lines that have a blank space, it is not placing the |.
Any ideas why?
0
 
LVL 84

Expert Comment

by:ozo
Comment Utility
{local $^I=''; local @ARGV=('the_piped_file');
  while( <> ){ s/$/|/; print }
}
0
 
LVL 16

Accepted Solution

by:
maneshr earned 50 total points
Comment Utility
replace


$var=~ s/\n/\|\n/;

with
$var=~ s/$/\|/;


and that will be solved too...
0
 

Author Comment

by:tgbekele
Comment Utility
Thank you very much ... that worked!!!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
perl to mysql 5 127
Perl 101 11 68
Awk Question 2 116
combine multiple lines 2 21
I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now