Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to remove the delimiter from the column value within a file?
Top Forums UNIX for Advanced & Expert Users How to remove the delimiter from the column value within a file? Post 302982255 by RudiC on Tuesday 27th of September 2016 07:35:32 AM
Old 09-27-2016
I'm afraid this problem is not that easy to solve as it seems to come from a data/data entry error in the input file. We need to unambiguously identify the address field. Will records always consist of the same number of fields? Will the e-mail-addresses always be in the records' last field? Will they be the only fields containing a dot, or a common domain or set of domains?

Depending on what OS and sed version you use (which you fail to mention in your post), this might work for the conversion (without solving your problem yet):
Code:
sed 's/\x00/|/g' file
deptno dname location email
1|Sales|NY|abc@gmail.com
2|marketing|WA|xyz|gmail.com
3|Inventory|NJ|pqr@gmail.com

Don't you need the header line use the same separators?
Last edited by RudiC; 09-27-2016 at 08:42 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to read the first column in a flat file with ~ as delimiter

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)
Discussion started by: siri_886
4 Replies

2. Shell Programming and Scripting

Remove first column from file

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)
Discussion started by: srimitta
8 Replies

3. Shell Programming and Scripting

rearrange the column names with comma as column delimiter

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)
Discussion started by: madhav62
5 Replies

4. Shell Programming and Scripting

How to remove delimiter from specific column?

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)
Discussion started by: Shirisha
7 Replies

5. Shell Programming and Scripting

How to avoid Delimiter occuring in column values in .csv file

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)
Discussion started by: ritesh.bhawsar
10 Replies

6. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

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)
Discussion started by: Gaurav Martha
16 Replies

7. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

8. Shell Programming and Scripting

Perl Code to change file delimiter (passed as argument) to bar delimiter

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)
Discussion started by: JPB1977
2 Replies

9. Shell Programming and Scripting

Replace delimiter for a particular column in a pipe delimited file

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 ULTRIX

qmail-local

qmail-local(8)                                                System Manager's Manual                                               qmail-local(8)

NAME

       qmail-local - deliver or forward a mail message

SYNOPSIS

       qmail-local [ -nN ] user homedir local dash ext domain sender defaultdelivery

DESCRIPTION

       qmail-local reads a mail message and delivers it to user by the procedure described in dot-qmail(5).

       The  message's  envelope  recipient  is local@domain.  qmail-local records local@domain in a new Delivered-To header field.  If exactly the
       same Delivered-To: local@domain already appears in the header, qmail-local bounces the message, to prevent mail forwarding loops.

       The message's envelope sender is sender.  qmail-local records sender in a new Return-Path header field.

       homedir is the user's home directory.  It must be an absolute directory name.

       dash and ext identify the .qmaildashext file used by qmail-local; see dot-qmail(5).  Normally dash is either empty or a lone hyphen.  If it
       is  empty,  qmail-local  treats  a nonexistent .qmailext the same way as an empty .qmailext: namely, following the delivery instructions in
       defaultdelivery.

       The standard input for qmail-local must be a seekable file, so that qmail-local can read it more than once.

OPTIONS

       -n     Instead of reading and delivering the message, print a description of the delivery instructions.

       -N     (Default.) Read and deliver the message.

EXIT CODES

       0 if the delivery is completely successful; nonzero if any delivery instruction failed.  Exit code 111 indicates temporary failure.

SEE ALSO

       dot-qmail(5), envelopes(5), qmail-command(8), qmail-queue(8), qmail-send(8), qmail-lspawn(8)

                                                                                                                                    qmail-local(8)
All times are GMT -4. The time now is 01:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy