How to remove the delimiter from the column value within a file?
Hello All,
we have some 10 files wherein we are using the ASCII NULL as separator which is nothing but '^@' and we need to change it to pipe delimited file before loading to database. Most of the data seems to be fine but there are instances where this separator tends to appear in the middle of column value like email address "asbc^@gmail.com
Below is the example of data, where second rows seems to have '^' in email address.
we have manage to convert the data into pipe separated file but the problem is how to you tackle this extra '^
Any help would be great.
Thanks
Djha
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 09-27-2016 at 08:23 AM..
Reason: Added CODE tags.
I have one flat file like below
id1~col~batch1
id2~col2~batch2
id3~col3~batch3
I need to read the first column one by one and I need to write one db2 query based on that column1
Like
for (i=0;i<=10;i++)
do
insert into table column (con_id) values (select column from table where... (4 Replies)
Hi,
This is how data in test.txt file
| |abc|zxcv|xy12|
| |cvs|zzvc|a23p|
How can remove first column.
abc|zxcv|xy12|
cvs|zzvc|a23p|
Thanks
srimitta (8 Replies)
Hi,
I am new to shell scripting, i have requirement can any one help me out in this regrads,
in directory i have file like invoice1.txt, invoice2.txt in each file i have fixed number of columns, 62 in number but they are randomly arranged.like
for first file invoice1.txt can have columns... (5 Replies)
I have 5 column in sample txt file
where in i have to create report based upon 1,3 and 5 th column..
I have : in first and third coulmn. But I want to retain the colon of fifth coulmn and remove the colon of first column..
5th column contains String message (for example,... (7 Replies)
Hello Gurus,
I need to create a file from a .csv file extracting specific columns only.
File structure is
Column1,Column2,Column3,Column4
abcd,1234,"asdf, tew,123",123456
efgh,234,asdf,654321
My output file should have
abcd,123456
efgh,654321
Can you pls help me with the code.
... (10 Replies)
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
I have an input file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
Output :
1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000
OR
1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
LEARN ABOUT DEBIAN
email-reminder-editor
EMAIL-REMINDER-EDITOR(1) User Contributed Perl Documentation EMAIL-REMINDER-EDITOR(1)NAME
Email-Reminder-Editor - edit special occasion reminders
SYNOPSIS
Simple editor for modifying special occasion email reminders.
DESCRIPTION
Email-reminder allows users to define events that they want to be reminded of by email. Possible events include birthdays, anniversaries
and yearly events. Reminders can be sent on the day of the event and a few days beforehand.
This is a simple editor that allows users to add/modify their reminders. It saves changes automatically when the program is closed.
OPTIONS --help
Displays basic usage message.
--simulate
Does not actually save any changes.
--verbose
Prints out information about what the program is doing.
--version
Displays the version number.
FILES
~/.email-reminders
AUTHOR
Francois Marier <francois@email-reminder.org.nz>
SEE ALSO
collect-reminders, send-reminders
COPYRIGHT
Copyright (C) 2004-2010 by Francois Marier
Email-Reminder is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 3 of the License, or (at your option) any later version.
Email-Reminder is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with Email-Reminder; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
perl v5.14.2 2012-05-28 EMAIL-REMINDER-EDITOR(1)