Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

cut a line into different fields based on identifiers

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting cut a line into different fields based on identifiers
# 1  
Old 09-04-2012
cut a line into different fields based on identifiers
Code:
cat fileanme.txt
custom1=, custom2=, userPulseId=3005, accountPolicyId=1, custom3=, custom4=, homeLocationId=0,

i need to make the fields appear in next line based on identifier (,) ie comma

so output should read

Code:
cat fileanme.txt
custom1=,
 custom2=, 
userPulseId=3005,
 accountPolicyId=1,
 custom3=, 
custom4=, 
homeLocationId=0,

any help is deeply appreciated
Last edited by vivek d r; 10-14-2012 at 02:54 AM..
# 2  
Old 09-04-2012
Code:
awk  '{for(i=1; i<=NF; i++) {printf("%s\n", $i) }' infile

This assumes there is a space or newline after each comma.
# 3  
Old 09-04-2012
Code:
sed 's/,/,\n/g' fileanme.txt

The above command will filter based on comma(,) and enters an empty line in the next line.
Last edited by Franklin52; 09-05-2012 at 08:31 AM.. Reason: Please use code tags for data and code samples
# 4  
Old 09-04-2012
Quote:
Originally Posted by rajkumarin
sed 's/,/,\n/g' fileanme.txt


The above command will filter based on comma(,) and enters an empty line in the next line.
This would leave an extra empty line at the end of the file...
# 5  
Old 09-04-2012
Code:
cat fileanme.txt | sed 's/,/,\n/g'  |  sed '/^$/d'

Check with above command now
Last edited by Franklin52; 09-05-2012 at 08:31 AM.. Reason: Please use code tags for data and code samples
# 6  
Old 09-04-2012
Quote:
Originally Posted by rajkumarin
cat fileanme.txt | sed 's/,/,\n/g' | sed '/^$/d'


Check with above command now
Appriciate that, but cat filename is not an ideal way to use file for editing.. it will cause an issue when file size is huge.. also since you are using 2 sed it has to pass through the file twice again an issue if file is huge...
# 7  
Old 09-04-2012
Yes!! You are correct. In case of huge file we can use 'awk' command it works much faster than 'sed'.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Cut each line based on the character size

Hello All, I have a file which contain below lines. The starting word of each line is call and the end line is semi colon. I need to find the character size of each line and then move it to a file. If the character size is more than 255 then I need to push that line to a next file and I need... (6 Replies)
Discussion started by: JoshvaPeter
6 Replies

2. Shell Programming and Scripting

Grep a part of file based on string identifiers

consider below file contents cat myOutputFIle.txt 8 CCM-HQE-ResourceHealthCheck: Resource List : No RED/UNKNOWN resource Health entries found ---------------------------------------------------------- 9 CCM-TraderLogin-Status: Number of logins: 0... (4 Replies)
Discussion started by: vivek d r
4 Replies

3. Shell Programming and Scripting

Remove part of a file based on identifiers

here below is a part of the file cat fileName.txt NAME=APP-VA-va_mediaservices-113009-VA_MS_MEDIA_SERVER_NOT_PRESENT-S FIXED=false DATE= 2013-02-19 03:46:04.4 PRIORITY=HIGH RESOURCE NAME=ccm113 NAME=APP-DS-ds_ha-140020-databaseReplicationFailure-S FIXED=false DATE= 2013-02-19... (4 Replies)
Discussion started by: vivek d r
4 Replies

4. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies

5. Shell Programming and Scripting

Extracting lines based on identifiers into multiple files respectively

consider the following is the contents of the file cat 11.sql drop procedure if exists hoop1 ; Delimiter $$ CREATE PROCEDURE hoop1(id int) BEGIN END $$ Delimiter ; . . . . drop procedure if exists hoop2; Delimiter $$ CREATE PROCEDURE hoop2(id int) BEGIN END $$ (8 Replies)
Discussion started by: vivek d r
8 Replies

6. Shell Programming and Scripting

Extracting few lines from a file based on identifiers dynamically

i have something like this in a file called mysqldump.sql -- -- Table structure for table `Table11` -- DROP TABLE IF EXISTS `Table11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Table11` ( `id` int(11) NOT NULL... (14 Replies)
Discussion started by: vivek d r
14 Replies

7. UNIX for Advanced & Expert Users

cut words based on the word count of a line

I would like to cut words based on the word count of a line. This over here inspired me with some ideas but I wasn't able to get what I needed. https://www.unix.com/shell-programming-scripting/105841-count-words-each-line-file-using-xargs.html If the line has 6 words I would like to use this.... (8 Replies)
Discussion started by: cokedude
8 Replies

8. Shell Programming and Scripting

Match data based on two fields, and append to a line

I need to write a program to do something like a 'vlookup' in excel. I want to match data from file2 based on two fields (where both match) in file1, and for matching lines, add the data from two of the fields from file2 to file1. If anyone knows something in perl or awk that can do this, I'd be... (20 Replies)
Discussion started by: jamessmith01
20 Replies

9. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies

10. Shell Programming and Scripting

Print Selection of Line between two Identifiers.

I have a following containing DATA in the following format: DATA....------ --------------- -------------- DATA.....------ -------------------- ------------------ DATA....------ --------------- -------------- I want to extract the selective DATA in between identifiers and ... (4 Replies)
Discussion started by: parshant_bvcoe
4 Replies
Login or Register to Ask a Question