|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Rearrange fields of delimited text file
Post 303003164 by andy2000 on Friday 8th of September 2017 08:53:58 AM
09-08-2017
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a comma delimited file. I want to sort the fields alphabetically and again store them in a comma delimited file.
For example, My file looks like this.
abc,aaa,xyz,xxx,def
pqr,ggg,eee,iii,qqq
zyx,lmo,pqr,abc,fff
and I want my output to look like this, all fields sorted... (3 Replies)
Discussion started by: swethapatil
3 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
I have a large flat file with variable length fields that are pipe delimited. The file has no new line or CR/LF characters to indicate a new record. I need to parse the file and after some number of fields, I need to insert a CR/LF to start the next record.
Input file ... (2 Replies)
Discussion started by: clintrpeterson
2 Replies
4. Shell Programming and Scripting
Gents,
I have a large file and each line of the file contains more than 200 bytes.Please let me a way to have the new line to start when the word "FIT" appears.
I was trialling with 'tr' command but i am not sure how to get it based on bytes and so it wasn't working...
Current... (3 Replies)
Discussion started by: appu2176
3 Replies
5. UNIX for Advanced & Expert Users
I'm facing a strange problem, please help me out.
Here we go.
I want to count number of fields in particular file.
filename and delimiter character will be passed through parameter.
On command prompt if i type following i get 27 as output (which is correct)
cat customer.dat | head -1 | awk... (12 Replies)
Discussion started by: vikanna
12 Replies
6. Shell Programming and Scripting
Hi,
I have a comma (,) delimited file, in which few fields are enclosed with in double quotes " ". I have to print the records in the file which donot have expected number of field with the line number.
File1
====
name,desgnation,doj,project #header#... (7 Replies)
Discussion started by: machomaddy
7 Replies
7. Shell Programming and Scripting
Hi,
I need your help for below with shell scripting or perl
I/P
key, Sentence
customer1, I am David
customer2, I am Taylor
O/P
Key, Words
Customer1,I
Customer1,am
Customer1,David
Customer2,I
Customer2,am
Customer2,Taylor (4 Replies)
Discussion started by: monishathampi
4 Replies
8. Shell Programming and Scripting
Hi,
I am required to arrange columns of a file i.e make the 15th column into the 1st column.
I am doing
awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv
the problem is that column 15 gets to column 1 but it is not comma separated with the... (10 Replies)
Discussion started by: seddoubt
10 Replies
9. UNIX for Dummies Questions & Answers
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
10. Shell Programming and Scripting
For an Output like below
Input : <Subject A="I" B="1039502" C="2015-06-30" D="010101010101">
Output : <Subject D="010101010101" B="1039502" C="2015-06-30" A="I">
I have been using something like below but not getting the desired output :
awk -F ' ' '/Subject/ BEGIN{OFS=" ";}... (19 Replies)
Discussion started by: arunkesi
19 Replies
LEARN ABOUT DEBIAN
perlbal::manual
Perlbal::Manual(3pm) User Contributed Perl Documentation Perlbal::Manual(3pm) NAME
Perlbal::Manual - Guide and reference manual for Perlbal VERSION Perlbal 1.78. DESCRIPTION This is the comprehensive guide and reference manual for Perlbal. Perlbal::Manual::Configuration How to configure Perlbal: pools, services, syntax and more. Perlbal::Manual::Contributing How to contribute to Perlbal. Perlbal::Manual::Credits Author and contributor credits for Perlbal. Perlbal::Manual::Debugging How Perlbal's Debugging system works. Perlbal::Manual::FailOver How Perlbal's Fail Over mechanism works. Perlbal::Manual::HighPriority Perlbal's high/low priority queueing system and how to use it. Perlbal::Manual::Hooks Existing hooks and how they work. Perlbal::Manual::Install Installation procedures for Perlbal. Perlbal::Manual::Internals Perlbal's architecture at a glance. Useful for developers. Perlbal::Manual::LoadBalancer Setting up a Perlbal Load Balancing service. Perlbal::Manual::Logging How Perlbal's Logging system works. Perlbal::Manual::Management Setting up a "management" service, connecting to that service and managing Perlbal on-the-fly. Perlbal::Manual::Plugins Known plugins and how to create new ones. Perlbal::Manual::ReverseProxy Setting up a Perlbal "reverse_proxy" service. Perlbal::Manual::Roles Brief description of existing roles. Perlbal::Manual::Selector Setting up a Perlbal "selector" service. Perlbal::Manual::WebServer Setting up a Perlbal "web_server" service. AUTHORS
Bruno Martins and JosA~X Castro. SEE ALSO Perlbal::FAQ. There are sample configuration files under conf/, including samples for using and configuring existing plugins. perl v5.14.2 2011-01-23 Perlbal::Manual(3pm)