Sponsored Content
Top Forums Shell Programming and Scripting Converting comma separated to pipe delimited file Post 302420259 by anijan on Tuesday 11th of May 2010 06:29:02 AM
Old 05-11-2010
this will replace the comma in the substring with pipe

i.e 1234,"test,file" will be replaced as 1234|test|file
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies

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

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

4. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

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

6. Shell Programming and Scripting

Oracle table extract: all columns are not converting into pipe delimited in flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db... (5 Replies)
Discussion started by: express14
5 Replies

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

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

9. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies

10. Shell Programming and Scripting

Linux convert Comma delimited file to pipe

I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs. Example: Input: "2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456 Output: ... (4 Replies)
Discussion started by: shieksir
4 Replies
ISDNCONF(1)						      Linux System Utilities						       ISDNCONF(1)

NAME
isdnconf - manipulate or read ISDN phone number config files. SYNOPSIS
isdnconf DESCRIPTION
isdnconf can manipulate or read the file /etc/isdn/callerid.conf as well as ~/.isdn. Entries can be added or removed from these files. Additionally, entries can be searched for and displayed in a way similar to grep. An entry can be an own MSN ([MSN]) or a phone number ([NUMBER]). You can use this program to build your own phonebook. These files are used by many of the other ISDN utilities that use phone numbers, to display a number symbolicly instead of as a plain number. OPTIONS
Note: usage of the options -A and -D is dangerous! The complete structure of the file may be changed, and all comments are removed! Make backups of your data files before trying these. COMMAND OPTIONS: -A Add a new entry, which is read from standard input. The following values are asked for (here with examples): Alias: Fred Number: 0815/441777 SI: 0 Zone: 4 Interface: - Flags: I|O Program: /usr/local/bin/ring User: uucp Group: user Interval: Time: 8-20 Flags: (control-D here indicates end of flags) Alias: (control-D here indicated end of entries) If you want another [Flags] entry, simply enter the data for another program for this number at the point where the control-D was given above. If you want to add another number, simply enter the data for the next number at the Alias prompt. You can also pipe the data into this program; the input data then must correspond to the prompts that the program gives! Note that you can only add one number at a time then (there's no way of telling isdnconf that you want to stop giving Flags info and start giving the next Alias info). -D Delete one or more entries which match the data options given. How to supply the data to match is discussed below (see DATA OPTIONS). -V version: display the program's version and terminate. If both -A and -D are given together, isdnconf will terminate, as this is not a valid combination. If neither -A nor -D is given, then isdnconf will display entries which match the data given. DATA OPTIONS: (none applicable for -A) -n 'number' number: match the given number. It can contain wildcards. -a 'alias' alias: match the given alias name. The name can contain wildcards. Note: due to a bug, use '?' instead of '-'. -t 'SI' SI: match the given service indicator. -c 'code' code: match the area code of the phone number. Only usable for displaying (not for -A nor -D). -i ignore case for the -n and -a options. -w word: the parameters for -n and -a must match the whole value, not just a substring. Examples (here for -n): "*34*" matches 123456, 345677, 1234 "34*" matches 34567, 34111 but not 1234 "34??" matches 3411, 3456 "34" matches only 34 Without the -w option, these would match: "*34*" matches 123456, 345677, 1234 "34*" matches 123456, 345677, 1234, 34567, 34111 "34??" matches 123456, 345677, 1234, 3411, 3456 "34" matches 123456, 345677, 1234, 3411, 3456, 34567 -d and: by default the values given to options -n, -a and -t will be combined with a logical OR. If these should be combined with a logi- cal AND (which is probably what most people expect!) you must use this -d option. In this case you can only supply each of the -n, -a and -t options exactly once. OTHER OPTIONS: -q quiet: when using the -A or -D commands, the output is suppressed. When not using the -A or -D commands, only the alias of the match- ing number is shown, or just the number in case the alias is not found. -m MSN: when used in combination with the -A command, instructs isdnconf to create a new MSN entry; the default is to create a new NUMBER entry. Only the values alias, number, SI, zone and interface are applicable to an MSN entry. The following two options do not apply to the -A and -D commands. They only change the output format. -s short: only display the alias and the number. -l long: also display the programs to run ([START]). -f 'filename' file: usually isdnconf uses the /etc/isdn/callerid.conf and the ~/.isdn files. If isdnconf should be applied to another file, use this option. -g global: only applies to the -A and -D commands. Instead of editing ~/.isdn, /etc/isdn/callerid.conf is edited. -1 first: only delete or display the first entry. -M isdnmon: used internally by isdnmon to get alias info. AUTHOR
Andreas Kool <akool@isdn4linux.de> manpage adapted from the README by Paul Slootman <paul@isdn4linux.de> SEE ALSO
callerid.conf(5), isdnlog(8) isdn4k-utils-3.13 1998/12/29 ISDNCONF(1)
All times are GMT -4. The time now is 08:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy