Sponsored Content
Top Forums UNIX for Advanced & Expert Users How to remove the delimiter from the column value within a file? Post 302982262 by gandolf989 on Tuesday 27th of September 2016 09:50:11 AM
Old 09-27-2016
You might be able to do a three pass solution where you change the ^@ in the email addresses first to something temporary, then change everything else, then go back and change the temporary characters to what you want. Are all of the email addresses .com? or are there any .edu or .org. That might help to simplify the problem.
 

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
dhcpv6client_ui(1)					      General Commands Manual						dhcpv6client_ui(1)

NAME
dhcpv6client_ui - DHCPv6 client interface for requesting configuration parameters from the DHCPv6 server SYNOPSIS
interface_name interface_name config_options] vendor_specific_options] list_of_addresses DESCRIPTION
is the interface through which a user contacts the client daemon, to obtain IPv6 addresses and other configuration parameters from the server. The default configuration parameters are specified as command line options when the DHCPv6 client daemon is invoked. When requests for IPv6 addresses or other configuration parameters, the client daemon obtains them from the server and stores in the file. is executed on the same machine on which the client daemon is configured. Ensure that the client daemon is up and running before is exe- cuted. Options supports the following options: Request the client daemon to obtain IPv6 addresses for the named interface, interface_name, from the DHCPv6 server daemon if the option is not specified. Specify the other configuration parameters that the client daemon must request from the server daemon. This option must be used in conjunction with the option. The configuration parameters that the client can request are listed below: Obtain one or more DNS server addresses Obtain the DNS domain list Obtain one or more SIP server addresses Obtain the SIP domain list Obtain one or more NIS server addresses Obtain the NIS domain name Obtain one or more NIS+ server addresses Obtain the NIS+ domain name Obtain all the above listed parameters Obtain all the default parameters configured in the dhcpv6 client daemon Specify the vendor-specific options that the client daemon must request from the server daemon. This option must be used in conjunction with the option. Release the specified IPv6 addresses. Get the temporary addresses from the dhcpv6 client daemon. Print the version information of the client daemon. Request only the other configuration parameters. Do not request IPv6 addresses. Notify the client daemon to utilize the IPv6 addresses already obtained for an interface instead of requesting new IPv6 addresses from the server. This option must be used in conjunction with the option. Get both temporary and non-temporary addresses from the client daemon. When there is no or option specified obtains only non-temporary addresses. RETURN VALUES
returns 0 on success and 1 on failure. EXAMPLES
obtains IPv6 address for the interface: obtains IPv6 address for the interface and additional configuration parameters: obtains only the DNS parameters for the interface: AUTHOR
was developed by Hewlett-Packard. FILES
All the data obtained from the server daemon is saved to this file. SEE ALSO
dhcpv6clientd(1M), dhcpv6db2conf(1M), dhcpv6d(1M). dhcpv6client_ui(1)
All times are GMT -4. The time now is 07:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy