12-01-2010
Remove last space in a string?
I have a customer file now and would like to separate the names into two cells in a spreadsheet. Here is my data as an example:
SHAWN R KEEGAN
shawn r scroggin
Shawn Regan
Shawn Reilly
The first two have the middle initial so I'd like to include them in the "first name" field and the last name in the "last name" field. So what I need is a script to suck in the names in a text file and replace the last space in each line with a pipe so my data would look like this when converted:
SHAWN R|KEEGAN
shawn r|scroggin
Shawn|Regan
Shawn|Reilly
Best option please? I've searched the forum here and not found a way to do this specific example.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I need to unload some data from Informix database into text file.
But what happen is when i open the text file, some record split into 2 line, become uncomplete.
I had checked is due to some unregconized space in particular fields, i used many way to detect this unregconized space, but... (3 Replies)
Discussion started by: Ricole
3 Replies
2. UNIX for Dummies Questions & Answers
Hello
I have a file with data something like this in it :
texttexttext "text .lst" TEXT=" text "
texttexttext "moretext .lst" TEXT=" text "
Question is how do I get rid of space so that the files looks like this :
texttexttext "text.lst" TEXT="text"
texttexttext... (8 Replies)
Discussion started by: davebw
8 Replies
3. Shell Programming and Scripting
DATE=6/Jul/2010
6/Jul/2010
var="sed -n '/\
---------- Post updated at 11:49 AM ---------- Previous update was at 11:36 AM ----------
#!/bin/bash
DATE=`./get_date.pl 3`
DATE1=`./get_date.pl 2`
var1=$( echo "$DATE" | sed "s/ //g" )
var2=$( echo "$DATE1" | sed "s/ //g" )
var="sed -n... (1 Reply)
Discussion started by: sandy1028
1 Replies
4. Shell Programming and Scripting
Hello Folks..
I need your help ..
here the example of my problem..i know its easy..i don't all the commands in unix to do this especiallly sed...here my string..
dwc2_dfg_ajja_dfhhj_vw_dec2_dfgh_dwq
desired output is..
dwc2_dfg_ajja_dfhhj
it's a simple task with tail... (5 Replies)
Discussion started by: victor369
5 Replies
5. Shell Programming and Scripting
Hi guys,
I am new to shell scripting and I have a small problem...If someone can solve this..that would be great
I am trying to form a XML by reading a flat file using shell scripting
This is my shell script
LINE_FILE1=`cat FLEX_FILE1.TXT | head -1 | tail -1`
echo... (1 Reply)
Discussion started by: gowrishankar05
1 Replies
6. Shell Programming and Scripting
File A.txt
A005 -119.5 -119.5 -100.5
A006 -120.5 -119.5 -119.3
A008 0 0 0
Output
A005 -119.5 -119.5 -100.5
A006 -120.5 ... (1 Reply)
Discussion started by: asavaliya
1 Replies
7. UNIX for Advanced & Expert Users
I created a awk state to calculate the number of success however when the query runs it has a leading zero. Any ideas on how to remove the leading zero from the calculation?
Here is my query:
cat myfile.log | grep | awk '{print $2,$3,$7,$11,$15,$19,$23,$27,$31,$35($19/$15*100)}'
02:00:00... (1 Reply)
Discussion started by: bizomb
1 Replies
8. Shell Programming and Scripting
Hi Perl users,
I have another problem with text processing in Perl. I have a file below:
Linux Unix Linux Windows SUN
MACOS SUN SUN HP-AUX
I want the result below:
Unix Windows SUN
MACOS HP-AUX
so the duplicate string will be removed and also the keyword of the string on... (2 Replies)
Discussion started by: askari
2 Replies
9. Shell Programming and Scripting
I want to delete all matches in a text following this pattern:
Each match starts with linux-
Each match ends with a space
(Remove linux-* until immediate next space)
EXAMPLE:
From this text:
ibudev1 libudev1 libweather-ion7 libxatracker2 linux-generic linux-headers-generic... (4 Replies)
Discussion started by: Tribe
4 Replies
10. UNIX for Beginners Questions & Answers
Hello Folks ,
myfile contains 1000000 records as follows:
logver=56 idseq=63256 itime=1111 devid=TG-40 devname=PUI-C2 vd=USER date=2019_01_10 time=18:39:49 logid="000013" type="traffic" subtype="forward" level="notice" eventtime=134 srcip=1.1.1.1 srcport=1 srcintf="XYX-CORE.01"... (3 Replies)
Discussion started by: arm
3 Replies
LEARN ABOUT DEBIAN
devel::repl::plugin::multiline::ppi
Devel::REPL::Plugin::MultiLine::PPI(3pm) User Contributed Perl Documentation Devel::REPL::Plugin::MultiLine::PPI(3pm)
NAME
Devel::REPL::Plugin::MultiLine::PPI - read lines until all blocks are closed
SYNOPSIS
#!/usr/bin/perl
use lib './lib';
use Devel::REPL;
my $repl = Devel::REPL->new;
$repl->load_plugin('LexEnv');
$repl->load_plugin('History');
$repl->load_plugin('MultiLine::PPI');
$repl->run;
DESCRIPTION
Plugin that will collect lines until you have no unfinished structures. This lets you write subroutines, "if" statements, loops, etc. more
naturally.
For example, without a MultiLine plugin,
$ my $x = 3;
3
$ if ($x == 3) {
will throw a compile error, because that "if" statement is incomplete. With a MultiLine plugin,
$ my $x = 3;
3
$ if ($x == 3) {
> print "OH NOES!"
> }
OH NOES
1
you may write the code across multiple lines, such as in "irb" and "python".
This module uses PPI. This plugin is named "MultiLine::PPI" because someone else may conceivably implement similar behavior some other less
dependency-heavy way.
SEE ALSO
"Devel::REPL"
AUTHOR
Shawn M Moore, "<sartak at gmail dot com>"
COPYRIGHT AND LICENSE
Copyright (C) 2007 by Shawn M Moore
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-19 Devel::REPL::Plugin::MultiLine::PPI(3pm)