Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Tab Delimiter to csv in python:perl Post 303046314 by Perlbaby on Thursday 30th of April 2020 01:59:16 PM
Old 04-30-2020
Tab Delimiter to csv in python:perl

Hi
How do we handle delimiter values in python or perl to convert the field values from 3 columns to 2 columns into csv file

Columns Values

Product : Contain one value
ID : Ignore this
Features : Contains multiple values separated by tab

$cat Check_File
Code:
Product                ID                   Features 
Apple-for-Laptop 1.2.13.22 itunes app-stores health    # [ Product1 ]
Samsung-for-Mobile 5.43.67  music play-store long-battery    # [ Product2 ]
Nokia 4.1.2 long-battery    # [ Product3 ]


Expected format :
Code:
Product, Features
Apple-for-Laptop,itunes
Apple-for-Laptop,app-stores
Apple-for-Laptop,health   
Samsung-for-Mobile,music 
Samsung-for-Mobile,play-store 
Samsung-for-Mobile,long-battery 
Nokia,long-battery

Is there better way to handle this in python/perl . The file is big with 200 Million records.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cutting a tab delimiter file

I have a 30 column tab delimited record file. I need to extract the first 10column. The following command to cut was not working cut -f 1-10 -d "\t" filename. Could any one keep on this . Thanks in Advance (4 Replies)
Discussion started by: vinod.thayil
4 Replies

2. Shell Programming and Scripting

append data in a file by using tab delimiter

Hi, I need to append the data in to a file by using tab delimiter. eg: echo "Data1" >> filename.txt echo "\t" >> filename.txt (its not working) echo "Data2" >> filename.txt. the result sould be like this. Data1 Data2 (6 Replies)
Discussion started by: Sharmila_P
6 Replies

3. UNIX for Advanced & Expert Users

how to search delimiter tab in a line and replace it

hi every one plz help me i want to search for a line contains tabspace This is a line The should be changed see the above line is seperated with tab space i want to replace that tab space in to # as This is a line#The should be changed i have tried with... (4 Replies)
Discussion started by: kkraja
4 Replies

4. UNIX for Dummies Questions & Answers

Delimiter: Tab or Space?

Hello, Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another. Thanks, G (4 Replies)
Discussion started by: Gussifinknottle
4 Replies

5. Shell Programming and Scripting

Selecting Specific Columns and Insert the delimiter TAB

Hi, I am writing a Perl Script for the below : I have a data file that consists of the header information which is 231 Lines and the footer information as 4 lines. The total number of line including the header and footer 1.2 Million with Pipe Delimited file. For example: Header Information:... (4 Replies)
Discussion started by: filter
4 Replies

6. UNIX for Dummies Questions & Answers

set output delimiter as tab in cut command

I can not make it work, it prints \t rather than introduce tabs. cut -d "," -f 4,8 Samples.csv --output-delimiter="\t" | sort > out Since I am running this command within a shell script, I tried manually inserting tab in this command, still does not work. I am using bash shell Suggestions... (8 Replies)
Discussion started by: analyst
8 Replies

7. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

How can i make a tab delimiter file to a comma delimiter??? (13 Replies)
Discussion started by: saggiboy10
13 Replies

8. Shell Programming and Scripting

Compare two tab-delimiter files

Hi, I have two files like: file1 chr1 40 chr1 50 chr2 10 chr2 60 file2 chr1 30 chr1 50 chr2 15 chr2 20 and want to get the difference of column 2 when column 1 is the same in both files. (4 Replies)
Discussion started by: linseyr
4 Replies

9. Shell Programming and Scripting

CSV Delimiter Settings

Hi All, I am really new to Shell Scripting and would appreciate any help here. I have a script that runs throguh a cron job on a daily basis, problem is when the file is attached and e-mailed, it uses a comma delimiter to seperate fields. How can I prevent the script from using a comma... (2 Replies)
Discussion started by: SalientAnimal
2 Replies

10. 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
mip6mod(7)						 Miscellaneous Information Manual						mip6mod(7)

NAME
mip6mod - Mobile IPv6 STREAMS Module SYNOPSIS
Use the mip6admin utility to start, stop, configure, and manage (see for details). User applications should not use directly. DESCRIPTION
a kernel-resident STREAMS module for Mobile IPv6, implements the Correspondent Node and Home Agent functionality. The STREAMS moudle is responsible for processing and generating all Mobile IPv6 Mobility Header messages: Binding Update (BU), Binding Acknowledgement (BA), Binding Refresh Request (BRR), Binding Error (BE), Home Test Init (HoTI), Care-of Test Init (CoTI), Home Test (HoT), Care-of Test (CoT). The following Mobile IPv6 ICMPv6 messages are handled by the IPv6 Router Advertisement Daemon, Mobile Prefix Solicitation/Advertisement (MPS/MPA), Dynamic Home Agent Discovery Request/Reply (DHAAD Request/Reply). When the system is configured as a Correspondent Node, supports Route Optimization using the Return Routability Procedure. During the Return Routability Procedure, the Correspondent Node and the Mobile Node exchange HoTI/HoT and CoTI/CoT messages in order to establish a binding management key (Kbm) for authenticating the BU and BA messages. You can configure to send out BRR messages when the remaining lifetime of the binding entry drops below the system-configured BRR threshhold value (see for details) When the system is configured as a Home Agent, the IPv6 Router Advertisement Daemon ( ) must alos be running on the system to provide home link prefix information to Multiple home links are supported if the correct home link prefixes are configured on each home link interface. On a Home Agent, IPsec is used to proctect the signalling messages (i.e. BU, BA, HoTI, HoT, MPS, and MPA) between the Mobile Node and the Home Agent. If IPsec ESP is used, the Alternate Care-of Address option must be included within the BU message as the ESP protocol will not be able to protect the Care-of Address (i.e. source address) in the IPv6 header. For troubleshooting purpose, IPsec authentication can be turned off on via to allow Home Agent to accept plain BU messages from the Mobile Node without out IPsec AH or ESP protection. You can configure to include Binding Refresh Advice (BRA) option within the Binding Acknowledgement from the Home Agent when the remaining lifetime of the binding entry drops below the system-configured BRA interval value (see for details). For better performance on high-end systems, multiple instances of can be configured to run on the system processing Mobility Header mes- sages in parallel (see for details). For diagnostics purposes, supports five different levels of diagnostic message logging (i.e. ALERT, ERROR, WARN, INFO, and DEBUG) via the standard mechanism. By default, the system is configured to log at ERROR level. NOTE
provides Mobile IPv6 server functionality (i.e. Home Agent and Correspondent Node). does not provide Mobile Node functionality which is not required on server. AUTHOR
was developed by HP. SEE ALSO
mip6admin(1M), mip6config(1M), rtradvd(1M), syslog(3C) IETF Document Mobility Support in IPv6 IETF Document Using IPsec to Protect Mobile IPv6 Signaling between Mobile Nodes and Home Agents mip6mod(7)
All times are GMT -4. The time now is 04:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy