Extracting part of a string

sam_78_nyc · #1 (**permalink**) 04-23-2007

Hi all,
I have to extract only the second part of a database column (VARCHAR) and the value is seperated by a "~"

xyz~
chxyz36r~
abder~000082685
mnops~000083554
fulfil302~00026

Above are some examples of the values and for each record I have to extract the value after "~" , if there is a value by using shell scripts. As you can see they are multiple lenghts and in multiple formats and the only way to seperate them is by a "~".
Thanks in advance.

Perderabo · #2 (**permalink**) 04-23-2007

How about this...

Code:

$ cat script
#! /usr/bin/ksh

echo "xyz~
chxyz36r~
~whatif
abder~000082685
mnops~000083554
fulfil302~00026" | while read line ; do
        one=${line%%~*}
        two=${line##*~}
        printf "%30s %15s %15s \n" "$line" "$one" "$two"
done
exit 0
$ ./script
                          xyz~             xyz
                     chxyz36r~        chxyz36r
                       ~whatif                          whatif
               abder~000082685           abder       000082685
               mnops~000083554           mnops       000083554
               fulfil302~00026       fulfil302           00026
$

kapilraj · #3 (**permalink**) 04-23-2007

awk -F "~" '{print $2}'

If you don;t want empty lines ,

awk -F "~" '{print $2}' | grep -v ^$

ghostdog74 · #4 (**permalink**) 04-23-2007

Code:

awk -F "~" '$2 !~ /^$/ {print $2 }' "file"

napster_san · #5 (**permalink**) 04-24-2007

cat $filaname | sed 's/.*~$.*$/\1/'

anbu23 · #6 (**permalink**) 04-24-2007

Code:

cut -d"~" -f2 filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
need help extracting this part	finalight	Shell Programming and Scripting	6	05-20-2008 06:03 AM
Extracting a string from one file and searching the same string in other files	mohancrr	Shell Programming and Scripting	1	09-19-2007 03:17 AM
Extracting part of the basename	madhunk	Shell Programming and Scripting	3	02-13-2007 11:54 AM
extracting uncommon part between two files	sabyasm	Shell Programming and Scripting	2	11-06-2005 01:25 PM
extracting from a string	preetikate	Shell Programming and Scripting	1	03-11-2004 08:08 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by