Sponsored Content
Top Forums Shell Programming and Scripting How to split the comma separated file? Post 302769340 by jagdishrout on Tuesday 12th of February 2013 03:11:15 AM
Old 02-12-2013
Hi,
The code is working fine. But in my file each row does not have always 1 comma. It may vary from 1 to many.

its like

Code:
BUD,BDL
ABC,XYZ
MNB,JHG,KTR
JKL,KYH,TYP,GHY

the o/p should like


Code:
ABC,XYZ ABC
ABC,XYZ XYZ
MNB,JHG,KTR MNB
MNB,JHG,KTR JHG
MNB,JHG,KTR KTR
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY KYH
JKL,KYH,TYP,GHY TYP
JKL,KYH,TYP,GHY GHY

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove whitespaces between comma separated fields from file

Hello all, I am a unix dummy. I am trying to remove spaces between fields. I have the file in the following format 12332432, 2345 , asdfsdf ,100216 , 9999999 12332431, 2341 , asdfsd2 ,100213 , 9999999 &... (2 Replies)
Discussion started by: nitinbjoshi
2 Replies

2. Shell Programming and Scripting

Converting comma separated to pipe delimited file

Hi, I came across a very good script to convert a comma seperated to pipe delimited file in this forum. the script serves most of the requirement but looks like it does not handle embedded double quotes and commas i.e if the input is like 1234, "value","first,second", "LDC5"monitor",... (15 Replies)
Discussion started by: anijan
15 Replies

3. Shell Programming and Scripting

How to format file into comma separated field

Guys, Need you help, i have a a file content that look like this. Nokia 3330 <spaces><spaces><more spaces>+76451883874 Nokia 3610 +87467361615 so on and so forth, - there are so many spaces in between. - e.g.... (5 Replies)
Discussion started by: shtobias
5 Replies

4. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the... (4 Replies)
Discussion started by: avikaljain
4 Replies

5. Shell Programming and Scripting

Inserting string in between field in comma separated file

Hello Mates, I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G SE18 6RN,,,,5439070,1786840,,1000002148671600,123434 Out put should be: SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434 Can some one help me to... (8 Replies)
Discussion started by: krsnadasa
8 Replies

6. Shell Programming and Scripting

Comma separated file

Hi all, I have the following files types: FileA: 100, 23, 33, FileB: 22, 45, 78, and i want to make File C: 100,22 23,45 33,78 any nice suggestions for making it easy. (3 Replies)
Discussion started by: hen1610
3 Replies

7. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

8. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

9. Shell Programming and Scripting

Convert comma separated file to fix length

Hi, I am converting a comma separated file to fixed field lenght and I am using that: COLUMNS="25 24 67 26 39 63 20 34 35 14 397" ( cat $indir/input_file.dat | \ $AWK -v columns="$COLUMNS" ' BEGIN { FS=","; OFS=""; split(columns, arr, " "); } { for(i=1; i<=NF;... (5 Replies)
Discussion started by: apenkov
5 Replies

10. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies
dtsetup(8)						      System Manager's Manual							dtsetup(8)

NAME
dtsetup - Configure and Customize the Common Desktop Environment (CDE) SYNOPSIS
/usr/dt/bin/dtsetup X resources OPTIONS
Specifies the standard X11 resource options. For more information, see the X(1X) reference page. DESCRIPTION
The CDE Setup application, dtsetup, provides you with a mechanism to customize your Common Desktop Environment by using a graphical user interface. It also provides System Administrators a means to create a CDE environment for various types of users. When you invoke the CDE Setup application, a panel of four icons are displayed: Quick Setup, Desktop, Login, and Services. From the Quick Setup icon, you or the system administrator can provide minimal entries to configure CDE. The Desktop icon lets you or the system administrator set up the front panel, establish various window manager resources, define starting applications, and set parameters for the terminal, dtmail, and dtfile applications. The Login icon lets you provide information about your login session, while the system administrator can also set up the system login greetings, and set up the X server configuration. The Services icon has fields for various services configuration. You are restricted to the choice of whether to run the Motif/OpenLook DND gateway. The system administrator has additional choices regarding the ToolTalk Session and ToolTalk Database server, as well as disabling network dependency and allowing inbound remote process execution. The CDE Setup application provides an effortless way of assembling the CDE front panel from available controls. Furthermore, by providing various file names and other specifications, the CDE Setup application allows you to create your own controls. The CDE setup application can be invoked from: The CDE Application Manager. Application Group: System_Admin Desktop_Apps Subgroup: Configuration To start the dtsetup application from the command line, enter /usr/dt/bin/dtsetup. Online help is available for the dxmtools application. To get help, click on any Help button or use the Help pull-down menu. RESTRICTIONS
You must have superuser privileges to access the full functionality of this application. FILES
CDE setup application executable CDE setup online help volume SEE ALSO
Commands: dtlogin(1), ttdbserverd(1), ttsession(1), X(1X), xdm(1X), xprop(1X) Files: dtfpfile(4) Common Desktop Environment: User's Guide Common Desktop Environment: Advanced User's and System Administrator's Guide CDE Companion dtsetup(8)
All times are GMT -4. The time now is 06:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy