Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Linux convert Comma delimited file to pipe
Top Forums Shell Programming and Scripting Linux convert Comma delimited file to pipe Post 303006705 by Scrutinizer on Monday 6th of November 2017 03:00:26 PM
Old 11-06-2017
Hi, try:
Code:
awk '{for(i=1; i<=NF; i+=2) gsub(",","|",$i)}1' FS=\" OFS= file


Code:
2017-09-30|ACBD,TVF|01234|NULL|18|NULL|686091802|BANK OF ABCD, LIMITED, THE|790456


--
On Solaris use /usr/xpg4/bin/awk
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert a pipe delimited file to a':" delimited file

i have a file whose data is like this:: osr_pe_assign|-120|wg000d@att.com|4| osr_evt|-21|wg000d@att.com|4| pe_avail|-21|wg000d@att.com|4| osr_svt|-11|wg000d@att.com|4| pe_mop|-13|wg000d@att.com|4| instar_ready|-35|wg000d@att.com|4| nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Discussion started by: priyanka3006
6 Replies

2. Shell Programming and Scripting

how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies

3. UNIX for Advanced & Expert Users

Urgent! need help! how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies

4. 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

5. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD... (7 Replies)
Discussion started by: nithins007
7 Replies

6. Shell Programming and Scripting

Linux - Script to generate the output delimited by Comma/Pipe

Hi All, I have a requirement where I need to go to a directory, list all the files that start with person* (for eg) & read the most recent file from the list of files. While browsing through the forum, i found that the command ls -t will list the files. I am trying to generate the output... (1 Reply)
Discussion started by: dsfreddie
1 Replies

7. Shell Programming and Scripting

how to convert comma delimited file to tab separator

Hi all, How can i convert comma delimited .csv file to tab separate using sed command or script. Thanks, Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies

8. Shell Programming and Scripting

Need a script to convert comma delimited files to semi colon delimited

Hi All, I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies

9. Shell Programming and Scripting

How to cut a pipe delimited file and paste it with another file to form a comma separated outputfile

Hello ppl I have a requirement to split (cut in unix) a file (A.txt) which is a pipe delimited file into A1.txt and A2.txt Now I have to join (paste in unix) this A2.txt with external file A3.txt to form output file A4.txt which should be CSV (comma separated file) so that third party can... (25 Replies)
Discussion started by: etldev
25 Replies

10. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

LEARN ABOUT DEBIAN

pdebuild-user-mode-linux

pdebuild-user-mode-linux(1)					     pbuilder					       pdebuild-user-mode-linux(1)

NAME

       pdebuild-user-mode-linux - pbuilder-user-mode-linux way of doing debuild

SYNOPSIS

       pdebuild-user-mode-linux [pdebuild-user-mode-linux options] -- [pbuilder-user-mode-linux options]

DESCRIPTION

       A  convenience  program	for  pbuilder-user-mode-linux which invokes pbuilder after obtaining appropriate root privilege in a Debian source
       directory.  One must be inside the source tree containing the debian directory, in order to make it work.

PDEBUILD OPTIONS

       --buildsourceroot [fakeroot]
	      The command used to gain root privilege for invoking dpkg-buildpackage

       --auto-debsign

	      Invoke debsign at the end of pdebuild process.

       --debsign-k [key-id]

	      Pass -k option to debsign to specify which keyid to sign.

       --buildresult [Directory for build results]

	      The place which build result is stored.

       --configfile [Extra config file to use]

	      The configuration file is used, but not passed on to pbuilder-user-mode-linux.

       --debbuildopts [options to pass to dpkg-buildpackage]

	      The space-delimited list of options are passed to dpkg-buildpackage.  This option appends to pbuilder option --debbuildopts and  may
	      also be used to reset the list of options by passing the empty string.

       --use-pdebuild-internal
	      Uses a different implementation of pdebuild, which calls clean and build inside the chroot, using bind-mounts.

	      pdebuild-internal tries to run debian/rules clean inside the chroot.  To achieve the goal, the working directory is passed on inside
	      the chroot, in the form of bind-mounting and debuild is run.

	      This option will not protect the working directory and its parent directories from the build scripts.

       -- [pbuilder options]

	      After the -- symbol, an arbitrary number of pbuilder options can be specified.  See  pbuilder-user-mode-linux.1  for  full  list	of
	      options.

	      There is an exception that --buildresult needs to be specified as pdebuild option before the -- to be effective.

FILES

       /etc/pbuilderrc
	      The configuration file for pbuilder-user-mode-linux, used in pdebuild-user-mode-linux.

       /usr/share/pbuilder/pbuilderrc
	      The default configuration file for pbuilder-user-mode-linux, used in pdebuild-user-mode-linux.

       ${HOME}/.pbuilderrc
	      Configuration file for pbuilder-user-mode-linux, used in pdebuild-user-mode-linux, overrides what is written in /etc/pbuilderrc

AUTHOR

       Initial coding, and main maintenance is done by Junichi Uekawa <dancer@debian.org>.

       The homepage is available at http://pbuilder.alioth.debian.org

SEE ALSO

       /usr/share/doc/pbuilder/pbuilder-doc.html, pbuilder-user-mode-linux(1), pbuilderrc(5), pbuilder-uml.conf(5)

Debian								    2006 May 24 				       pdebuild-user-mode-linux(1)
All times are GMT -4. The time now is 10:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy