Sponsored Content
Full Discussion: Conversion of '|' delimiter
Top Forums Shell Programming and Scripting Conversion of '|' delimiter Post 302391654 by rdcwayx on Tuesday 2nd of February 2010 05:32:57 AM
Old 02-02-2010
Quote:
Originally Posted by ssachins
The above mentioned code is converting the first '|' to Tab delimited but unable to format the second '|' value to new line.

Also, I found another issue is like the input file does not contains the '|' at the end of each line hence when I execute the file using Ahmad's code, the format is getting changed from second line.

The actual data is coming like this -
Code:
NAME|ABC|LASTNAME|PQR|AGE|20|SEX|MALE
NAME|XYZ|LASTNAME|PDF|AGE|21|SEX|MALE

My code are not changed for your new INPUT_FILE.txt, but still get correct result.

Code:
$ cat INPUT_FILE.txt
NAME|ABC|LASTNAME|PQR|AGE|20|SEX|MALE
NAME|XYZ|LASTNAME|PDF|AGE|21|SEX|MALE

$ cat ssachins.sh
#!/usr/bin/ksh
FileName=INPUT_FILE.txt

if [[ -e $FileName ]]; then
  awk -F "|"  '{for( i = 1;i <= NF;++i)
      if( i % 2 == 0 ) printf("%s\n",$i)
      else
        printf("%s\t",$i) ; }{print ""}' $FileName
else
   echo "File $FileName  does not exists"
fi

$ ./ssachins.sh
NAME    ABC
LASTNAME        PQR
AGE     20
SEX     MALE

NAME    XYZ
LASTNAME        PDF
AGE     21
SEX     MALE

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

from - to delimiter

hey guys can you please help me out, i'm having problem in cutting strings. I need a delimiter to cut string. sample a.txt "ID", "1234" , "iam bighippo", "help!" "ID", "1235" , "again0", "xxxxxxx1" "ID", "1236" , "again1", "xxxxxxx2" "ID", "1237" , "again2", "xxxxxxx3" how do... (6 Replies)
Discussion started by: bighippo
6 Replies

2. UNIX for Dummies Questions & Answers

Delimiter

I am having the following file. I need to insert a delimiter in this file. I used sed but its not working. AAABBB 9 JJJ AAABBC 9 TTTTT AAABBA 8 JJJ AAABBC 7 TTTTT AAABBC 6 TTTTT Now i want the output file as: AAA|BBB| |9| |JJJ| AAA|BBC| |9| | |TTTTT| (3 Replies)
Discussion started by: sivakumar.rj
3 Replies

3. Shell Programming and Scripting

Substring based on delimiter, finding last delimiter

Hi, I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies

4. UNIX for Dummies Questions & Answers

unconstant delimiter

I have file with unconstatnt delimiter for each field which are non-printable characters like tab and space file 6271 manchester (tab) 11/09/09 200 accepted 6272 manchester (tab) 11/09/09 200 accepted I want only first... (7 Replies)
Discussion started by: tsurendra
7 Replies

5. Shell Programming and Scripting

Help regarding the delimiter

Hi, I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using... (3 Replies)
Discussion started by: smileyreddy
3 Replies

6. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43°13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies

7. Shell Programming and Scripting

how to get everything before the last delimiter?

hi all, i have a string with a number of "/"s as delimiter. and i want everything BEFORE the last delimiter i know to use basename to get everything after the last delimiter. thx a lot! (2 Replies)
Discussion started by: sunnydanniel
2 Replies

8. Shell Programming and Scripting

Delimiter Conversion(Generic Code)

Hi All, I am looking for a generic code which can search for the existing delimiter(what ever it may be) in a file and convert it to Pipeline. The file may have Pipeline delimiter already in that case just leave it. Please find below some sample records. Sample records1: ... (2 Replies)
Discussion started by: Arun Mishra
2 Replies

9. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies

10. Shell Programming and Scripting

Perl Code to change file delimiter (passed as argument) to bar delimiter

Hi, Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters. Any help would... (2 Replies)
Discussion started by: JPB1977
2 Replies
SPRIO(1)							  SLURM commands							  SPRIO(1)

NAME
sprio - view the factors that comprise a job's scheduling priority SYNOPSIS
sprio [OPTIONS...] DESCRIPTION
sprio is used to view the components of a job's scheduling priority when the multi-factor priority plugin is installed. sprio is a read- only utility that extracts information from the multi-factor priority plugin. By default, sprio returns information for all pending jobs. Options exist to display specific jobs by job ID and user name. OPTIONS
-h, --noheader Do not print a header on the output. --help Print a help message describing all options sprio. -j <job_id_list>, --jobs=<job_id_list> Requests a comma separated list of job ids to display. Defaults to all jobs. -l, --long Report more of the available information for the selected jobs. -M, --clusters=<string> The cluster to issue commands to. Only one cluster name may be specified. -n, --norm Display the normalized priority factors for the selected jobs. -o <output_format>, --format=<output_format> Specify the information to be displayed, its size and position (right or left justified). The default formats when all factors have been assigned non-zero weights are default "%.7i %.10Y %.10A %.10F %.10J %.10P %.10Q" -l, --long "%.7i %.8u %.10Y %.10A %.10F %.10J %.10P %.10Q %.6N" The format of each field is "%[.][size]type". size is the minimum field size. If no size is specified, whatever is needed to print the information will be used. . indicates the output should be left justified. By default, output is right justified. Valid type specifications include: %a Normalized age priority %A Weighted age priority %f Normalized fair-share priority %F Weighted fair-share priority %i Job ID %j Normalized job size priority %J Weighted job size priority %N Nice adjustment %p Normalized partition priority %P Weighted partition priority %q Normalized quality of service priority %Q Weighted quality of service priority %u User name for a job %Y Job priority %y Normalized job priority -u <user_list>, --user=<user_list> Request jobs from a comma separated list of users. The list can consist of user names or user id numbers. --usage Print a brief help message listing the sprio options. -v, --verbose Report details of sprios actions. -V , --version Print version information and exit. -w , --weights Display the configured weights for each factor. This is for information purposes only. Actual job data is suppressed. ENVIRONMENT VARIABLES
If no corresponding commandline option is specified, sprio will use the value of the following environment variables. SLURM_CLUSTERS Same as --clusters EXAMPLES
Print the list of all pending jobs with their weighted priorities > sprio JOBID PRIORITY AGE FAIRSHARE JOBSIZE PARTITION QOS 65539 62664 0 51664 1000 10000 0 65540 62663 0 51663 1000 10000 0 65541 62662 0 51662 1000 10000 0 Print the list of all pending jobs with their normalized priorities > sprio -n JOBID PRIORITY AGE FAIRSHARE JOBSIZE PARTITION QOS 65539 0.00001459 0.0007180 0.5166470 1.0000000 1.0000000 0.0000000 65540 0.00001459 0.0007180 0.5166370 1.0000000 1.0000000 0.0000000 65541 0.00001458 0.0007180 0.5166270 1.0000000 1.0000000 0.0000000 Print the job priorities for specific jobs > sprio --jobs=65548,65547 JOBID PRIORITY AGE FAIRSHARE JOBSIZE PARTITION QOS 65547 62078 0 51078 1000 10000 0 65548 62077 0 51077 1000 10000 0 Print the job priorities for jobs of specific users > sprio --users=fred,sally JOBID USER PRIORITY AGE FAIRSHARE JOBSIZE PARTITION QOS 65548 fred 62079 1 51077 1000 10000 0 65549 sally 62080 1 51078 1000 10000 0 Print the configured weights for each priority component > sprio -w JOBID PRIORITY AGE FAIRSHARE JOBSIZE PARTITION QOS Weights 1000 100000 1000 10000 1 COPYING
Copyright (C) 2009 Lawrence Livermore National Security. Produced at Lawrence Livermore National Laboratory (cf, DISCLAIMER). CODE-OCEC-09-009. All rights reserved. This file is part of SLURM, a resource management program. For details, see <http://www.schedmd.com/slurmdocs/>. SLURM is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. SLURM is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. SEE ALSO
squeue(1), sshare(1) sprio 2.3 May 2011 SPRIO(1)
All times are GMT -4. The time now is 01:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy