Sponsored Content
Top Forums Shell Programming and Scripting Replace comma delimiter by newline Post 302813847 by millan on Tuesday 28th of May 2013 08:23:10 AM
Old 05-28-2013
Replace comma delimiter by newline

The input file is as below
Code:
 
AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24
,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR
AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ
................
................

I am writting the below code .
I have to serch the lines containing strings in between the top name.
The top names are AR,AZ...

PHP Code:
echo "Give the top name"
read top
/usr/bin/sed -'/$top/,/$top/p' inputfile | /usr/bin/sed '/,/\\n/g' exclude_file 
example If the top name is AR,output will be
Code:
age
marks
roll
section
evin
25
80
456
A
atch
23
56
789
B
eena
24
78H245
C
Ps
ot
ecessary
hat
ame comes first then age and rest

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace comma with newline

Hi, for some reason I cant seem to figure this out. I have a file which looks something like this word word word word word,word,word word word word,word,word,word,word word word Basically I want this whole thing to be a list with 1 word on each line like this... word word word... (1 Reply)
Discussion started by: eltinator
1 Replies

2. Shell Programming and Scripting

comma delimiter and space

I have a csv file and there is a problem which I need to resolve. Column1,Column2,Colum3,Column4 ,x,y,z ,d,c,v t,l,m,n ,h,s,k ,k,,y z,j, ,p Now if you see column1 for row 1 and row 4 though they are null there is a space but in case of row2 and row 5 there is no space. I want row... (3 Replies)
Discussion started by: RubinPat
3 Replies

3. Shell Programming and Scripting

Replace newline with comma.

I have output from a file like this: 15,01,11,14:06 235 I would like to change this to: 15,01,11,14:06,235 Removing newline and change to "," I now this can be done with tr cat OUT | tr '\n' ','' My problem is that tr is not implemented in this shell. sed is, show it should be... (7 Replies)
Discussion started by: Jotne
7 Replies

4. Shell Programming and Scripting

Exporting data into Comma Delimiter.

Hi, Requirement: Exporting data from Oracle to UNIX into "Comma" delimiter. Help Needed: I was able to connect to Oracle and import the data. But please let me know while importing the data I need to make it into Comma delimiter flat file. For Example: Source Data - 100 ABC TLead... (6 Replies)
Discussion started by: arunvasu2
6 Replies

5. Shell Programming and Scripting

Change the delimiter from Comma to Pipeline

Hello All, I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it. Appreciate any help if awk can be used to do it. Mentioned below is the sample record of... (14 Replies)
Discussion started by: Arun Mishra
14 Replies

6. Shell Programming and Scripting

How to replace NewLine with comma using sed?

Hi , I have a huge file with following records and I want to replace the last comma with ',NULL'. I try using SED but could not create a correct script . In my opinion I need a script which can convert ,/n with ,NULL/n 1,CHANGE_MEMBER,2010-12-28 00:05:00, 2,CHANGE_MEMBER,2012-09-02... (8 Replies)
Discussion started by: Ajaypal
8 Replies

7. Shell Programming and Scripting

Command to replace newline with comma

Hi Experts, I need an urgent help in replacing newline characters in my single column file by a comma. I am using following command for this purpose: sed -n -e 'H;${x;s/\n/,/g;s/^,//;p;}' parameter.rtf | rev | cut -c 4- | revMy input file has: TABLE_1 TABLE_2 TABLE_3 What I need:... (11 Replies)
Discussion started by: neerndg123
11 Replies

8. Shell Programming and Scripting

Replace comma and blank with comma and number

I, I have a file and i need to replace comma and blank space with comma and 0. cat file.txt a,5 b,1 c, d, e,4 I need the output as cat file.txt a,5 b,1 c,0 d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies

9. Shell Programming and Scripting

Replace spaces with underscores up to first comma but not after the comma

I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file: EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies

10. UNIX for Beginners Questions & Answers

Replace newline with comma and append quotes

Hi, I have below requirement. Apple Orange Banana Required O/p in bash 'Apple,Orange,Banana' Can you please help. Please wrap your samples, codes in CODE TAGS as per forum rules. (3 Replies)
Discussion started by: Rtk
3 Replies
dc(1)								   User Commands							     dc(1)

NAME
dc - desk calculator SYNOPSIS
/usr/bin/dc [filename] /usr/xpg6/bin/dc [filename] DESCRIPTION
dc is an arbitrary precision arithmetic package. Ordinarily it operates on decimal integers, but one may specify an input base, output base, and a number of fractional digits to be maintained. The overall structure of dc is a stacking (reverse Polish) calculator. If an argument is given, input is taken from that file until its end, then from the standard input. bc is a preprocessor for dc that provides infix notation and a C-like syntax that implements functions. bc also provides reasonable control structures for programs. See bc(1). USAGE
/usr/bin/dc, /usr/xpg6/bin/dc The following constructions are recognized under both /usr/bin/dc and /usr/xpg6/bin/dc: number The value of the number is pushed on the stack. A number is an unbroken string of the digits 0-9. It may be preceded by an underscore (_) to input a negative number. Numbers may contain decimal points. sx The top of the stack is popped and stored into a register named x, where x may be any character. If the s is capitalized, x is treated as a stack and the value is pushed on it. lx The value in register x is pushed on the stack. The register x is not altered. All registers start with zero value. If the l is capitalized, register x is treated as a stack and its top value is popped onto the main stack. d The top value on the stack is duplicated. p The top value on the stack is printed. The top value remains unchanged. P Interprets the top of the stack as an ASCII string, removes it, and prints it. f All values on the stack are printed. q Exits the program. If executing a string, the recursion level is popped by two. Q Exits the program. The top value on the stack is popped and the string execution level is popped by that value. x Treats the top element of the stack as a character string and executes it as a string of dc commands. X Replaces the number on the top of the stack with its scale factor. [ ... ] Puts the bracketed ASCII string onto the top of the stack. <x >x =x The top two elements of the stack are popped and compared. Register x is evaluated if they obey the stated relation. v Replaces the top element on the stack by its square root. Any existing fractional part of the argument is taken into account, but otherwise the scale factor is ignored. ! Interprets the rest of the line as a shell command. c All values on the stack are popped. i The top value on the stack is popped and used as the number radix for further input. I Pushes the input base on the top of the stack. o The top value on the stack is popped and used as the number radix for further output. O Pushes the output base on the top of the stack. k The top of the stack is popped, and that value is used as a non-negative scale factor: the appropriate number of places are printed on output, and maintained during multiplication, division, and exponentiation. The interaction of scale fac- tor, input base, and output base will be reasonable if all are changed together. K Pushes the current scale factor on the top of the stack. z The stack level is pushed onto the stack. Z Replaces the number on the top of the stack with its length. ? A line of input is taken from the input source (usually the terminal) and executed. Y Displays dc debugging information. ; : Used by bc(1) for array operations. /usr/bin/dc The following construction is recognized under /usr/bin/dc, using the scale of whatever the result is. + - / * % ^ The top two values on the stack are added (+), subtracted (-), multiplied (*), divided (/), remaindered (%), or exponenti- ated (^). The two entries are popped off the stack; the result is pushed on the stack in their place. Any fractional part of an exponent is ignored. /usr/xpg6/bin/dc The following construction is recognized under /usr/xpg6/bin/dc. The results of division are forced to be a scale of 20. + - / * % ^ The top two values on the stack are added (+), subtracted (-), multiplied (*), divided (/), remaindered (%), or exponenti- ated (^). The two entries are popped off the stack. The result is pushed on the stack in their place. Any fractional part of an exponent is ignored. Ensures that the scale set prior to division is the scale of the result. EXAMPLES
Example 1: Printing the first ten values of n! This example prints the first ten values of n!: [la1+dsa*pla10>y]sy 0sa1 lyx ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWesu | +-----------------------------+-----------------------------+ SEE ALSO
bc(1), attributes(5) DIAGNOSTICS
x is unimplemented x is an octal number. out of space The free list is exhausted (too many digits). out of stack space Too many pushes onto the stack (stack overflow). empty stack Too many pops from the stack (stack underflow). nesting depth Too many levels of nested execution. divide by 0 Division by zero. sqrt of neg number Square root of a negative number is not defined (no imaginary numbers). exp not an integer dc only processes integer exponentiation. exp too big The largest exponent allowed is 999. input base is too large The input base x: 2<= x <= 16. input base is too small The input base x: 2<= x <= 16. output base is too large The output base must be no larger than BC_BASE_MAX. invalid scale factor Scale factor cannot be less than 1. scale factor is too large A scale factor cannot be larger than BC_SCALE_MAX. symbol table overflow Too many variables have been specified. invalid index Index cannot be less than 1. index is too large An index cannot be larger than BC_DIM_MAX. SunOS 5.10 29 Aug 2003 dc(1)
All times are GMT -4. The time now is 11:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy