find string and get the rest of the line in a pipe delimited file
Hi friends,
I have a file where I should search for a string and get the rest of the line but without the delimiter using awk.
for example I have the series of string in a file:
input_string.txt
Code:
bbb
ccc
aaa
and the mapping file looks like this.
mapping.txt
Code:
aaa|12
bbb|23
ccc|43
i need to get the mapped number and use it in a variable. the code looks like this:
Code:
while read line;
do
mapped= ??AWK $line mapping.txt
....
....
done < input_string.txt
Is there a way to do this using awk or sed? Please help
i have a file whose data is like this::
osr_pe_assign|-120|wg000d@att.com|4|
osr_evt|-21|wg000d@att.com|4|
pe_avail|-21|wg000d@att.com|4|
osr_svt|-11|wg000d@att.com|4|
pe_mop|-13|wg000d@att.com|4|
instar_ready|-35|wg000d@att.com|4|
nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
#! /bin/csh
set delimiter = |
foreach i (*)
set str_deli="$i$delimiter"
question: how to retain the value of str_deli so i can build a pipe delimited string?
end (1 Reply)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Hi,
I have one requiremnet like this. I need to find some particular string (eg.IncludeDateTime = ) in a file. And wherever it finds the string the unix script has to delete the remaining text coming after the string (ie., 'IncludeDateTime = ' ) in the same line. I tried to write this script in... (5 Replies)
Hi,
I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please.
thanks in advance. (3 Replies)
Hi guys,
I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file
for eg:
file 1:
xx|yy|"xyz|zzz"|zzz|12...
using below awk command
awk 'BEGIN {FS=OFS="|" } print $3
i would get xyz
But i want as :
xyz|zzz to consider as whole column... (13 Replies)
Hi All,
I have a large dat file where each lines are pipe delimited values. I need to parse the file depending on the request. For example: sometimes I have told to remove all the values in the 7th column (this case remove values '3333' only from the first line and '3543' from the second line)... (4 Replies)
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)
I have a file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
2345|FirstName2|MiddleName3|LastName4|
Add1 || ADD2|
234|000000000
OUTPUT :
... (1 Reply)
Discussion started by: styris
1 Replies
LEARN ABOUT BSD
strsep
STRSEP(3) Library Functions Manual STRSEP(3)NAME
strsep - separate strings
SYNOPSIS
#include <string.h>
char *
strsep(stringp, delim)
char **stringp;
char *delim;
DESCRIPTION
The strsep() function locates, in the string referenced by *stringp , the first occurrence of any character in the string delim (or the
terminating ` ' character) and replaces it with a ` '. The location of the next character after the delimiter character (or NULL, if the
end of the string was reached) is stored in *stringp . The original value of *stringp is returned.
An ``empty'' field, i.e. one caused by two adjacent delimiter characters, can be detected by comparing the location referenced by the
pointer returned in *stringp to ` '.
If *stringp is initially NULL, strsep() returns NULL.
EXAMPLES
The following uses strsep() to parse a string, containing tokens delimited by white space, into an argument vector:
char **ap, *argv[10], *inputstring;
for (ap = argv; (*ap = strsep(&inputstring, " ")) != NULL;)
if (**ap != ' ')
++ap;
HISTORY
The strsep() function is intended as a replacement for the strtok() function. While the strtok() function should be preferred for porta-
bility reasons (it conforms to ANSI C X3.159-1989 (``ANSI C'')) it is unable to handle empty fields, i.e. detect fields delimited by two
adjacent delimiter characters, or to be used for more than a single string at a time. The strsep() function first appeared in 4.4BSD.
4.4 Berkeley Distribution January 12, 1996 STRSEP(3)
02-15-2012
