Thanks Akshay for the code , Apologies for not mentioning the delimeter but you had it right pipe delimiter is the one which I thought as well .
Also I think I got confused with my input and output .
Desired output
The strings need not be delimiter with | . Apologies for confusion .
Hi
I have a pipe-delimited file where I eventually need to replace a string stored on the 3th field on a specific record.
This is how the file looks like:
A|Mike|Lvl 1|...
B|...
A|Maria|Lvl 1|...
C|...
B|...
A|Jimmy|Lvl 2|...
C|...
A|Carry|Lvl 0|...
C|...
B|...
A|John|Lvl 8|...... (2 Replies)
Hello,
I have data in a file something like this -
UNB+UNOA:1+006415160:1+AR0000012360:ZZ+080701:0552+2++DELFOR++++T'UNH+2+DELFOR:D:97A:UN
Here, the delimiters used are + , : and ' . I have a set of such files in which these delimiters vary from one file to another.
I am developing a... (4 Replies)
Hello,
this thread is more about scripting style than a specific issue.
I've to grep from a output some lines and from them obtain a specific entry delimited by < and >.
This is my way :
1) grep -i user list | awk '{FS="<";print $NF}' | sed -e 's/>//g'
2) grep -i user list | cut -d","... (10 Replies)
I'm trying to do a split using two delimiters. The first delimiter is ": " (or we could call it :\s). The second is "\n".
How can or these delimiters so I can toss the values into an array without issue?
I tried @array = split /:\s|\n/, $myvar;
This doesn't seem to be working.
Any an... (3 Replies)
Line from input file
a : b : c " d " e " f : g : h " i " j " k " l
output
k b a
Its taking 7th word when " is the delimiter, 2nd and 1st word when : is the delimiter and returning all in one line.... I am on solaris
Thanks..... (1 Reply)
Hello
I have a csv file which I need to insert addtional commas into. The csv is of the format
field1,field2,field3,field4,...etc...,field13,field14
I need to add extra commas in each record so that the final output looks like
... (1 Reply)
I have a file which is separated by delimiter "|", but the prob is one of my column do contain delimiter as description so how can i differentiate it?
PS : the delmiter does have backslash coming before it, if occurring in column
Annual|Beleagured|Desc|Denver... (2 Replies)
Discussion started by: nikhil jain
2 Replies
LEARN ABOUT SUNOS
tr
tr(1B) SunOS/BSD Compatibility Package Commands tr(1B)NAME
tr - translate characters
SYNOPSIS
/usr/ucb/tr [-cds] [ string1 [string2]]
DESCRIPTION
The tr utility copies the standard input to the standard output with substitution or deletion of selected characters. The arguments string1
and string2 are considered sets of characters. Any input character found in string1 is mapped into the character in the corresponding posi-
tion within string2. When string2 is short, it is padded to the length of string1 by duplicating its last character.
In either string the notation:
a-b
denotes a range of characters from a to b in increasing ASCII order. The character , followed by 1, 2 or 3 octal digits stands for the
character whose ASCII code is given by those digits. As with the shell, the escape character , followed by any other character, escapes
any special meaning for that character.
OPTIONS
Any combination of the options -c, -d, or -s may be used:
-c Complement the set of characters in string1 with respect to the universe of characters whose ASCII codes are 01 through 0377
octal.
-d Delete all input characters in string1.
-s Squeeze all strings of repeated output characters that are in string2 to single characters.
EXAMPLES
Example 1: Creating a list of all the words in a filename
The following example creates a list of all the words in filename1, one per line, in filename2, where a word is taken to be a maximal
string of alphabetics. The second string is quoted to protect `' from the shell. 012 is the ASCII code for NEWLINE.
example% tr -cs A-Za-z '