Visit Our UNIX and Linux User Community


How to do String manipulations using Substring function in Shell


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to do String manipulations using Substring function in Shell
# 1  
Old 08-18-2009
How to do String manipulations using Substring function in Shell

Hi,

I have a scenario to just plug out the file name from the following location path.

/opt/project/data/int/holdFiles/csv195687.csv

So, how do I get just file name which is "csv195687.csv" from the above line using awk/shell scripting? Can we use indexOf and Substring in awk to get last indexOf "/" and then end of String to get file name?

Thanks.
# 2  
Old 08-18-2009
if u made a little search, you could have get what u wanted by urself....

Code:
 
str="/opt/project/data/int/holdFiles/csv195687.csv"
echo ${str##*/}
csv195687.csv

# 3  
Old 08-18-2009
Thanks for quick reply. It is a cool answer. From next time onwards, I will definitely search the forum before I ask the question.
# 4  
Old 08-18-2009
Code:
$
$ str="/opt/project/data/int/holdFiles/csv195687.csv"
$ basename $str
csv195687.csv
$
$ echo $str | sed 's/.*\///'
csv195687.csv
$
$ echo $str | awk -F/ '{print $NF}'
csv195687.csv
$
$ echo $str | perl -lne '/.*\/(.*)/ && print $1'
csv195687.csv
$

tyler_durden
# 5  
Old 08-18-2009
Thanks Tyler. Hmmm...lot of options.
# 6  
Old 11-04-2009
basename

str="/opt/project/data/int/holdFiles/csv195687.csv"
basename $str
# 7  
Old 11-04-2009
Code:
echo "/opt/project/data/int/holdFiles/csv195687.csv" |awk -F[/] '{print $NF}'


Previous Thread | Next Thread
Test Your Knowledge in Computers #338
Difficulty: Easy
telnet is considered safer than ssh for most remote login applications.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting substring within string between 2 token within the string

Hello. First best wishes for everybody. here is the input file ("$INPUT1") contents : BASH_FUNC_message_begin_script%%=() { local -a L_ARRAY; BASH_FUNC_message_debug%%=() { local -a L_ARRAY; BASH_FUNC_message_end_script%%=() { local -a L_ARRAY; BASH_FUNC_message_error%%=() { local... (3 Replies)
Discussion started by: jcdole
3 Replies

2. Shell Programming and Scripting

Pass a variable string in To_Date Oracle function in shell script

Hello, I am trying to execute an SQL query from shell script. A part of script is something like this: fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"` $ORACLE_HOME/sqlplus -s /nolog <<EOD1 connect $COSDBUID/$COSDBPWD@$COSDBSID spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies

3. UNIX for Dummies Questions & Answers

Substring Function

I have a file in which there are other file path and names /home/data/abc.txt /home/data/sdf.txt /home/data/sdg.txt how can I get the file names i.e. abc.txt sdf.txt sdg.txt I searched the forum for sed command but it was confusing to me (10 Replies)
Discussion started by: eskay
10 Replies

4. Shell Programming and Scripting

Substring a returned function value

Hello, I have something that should be very simple yet I am losing my head in figuring out how to get it to work: I am calling a function passing a parameter, this will return a particular string, next I want to substring the returned value and break it apart. All of this I want to do on a... (2 Replies)
Discussion started by: gio001
2 Replies

5. Linux

Selecting substring (like SQL Server function)

Hey, geniuses of the world (no--facetious is NOT the word of the day;))! I was wondering if there's a way to extract a specific portion from a string of characters in UNIX/LINUX. Give me the generic capabilities (assuming they exist) and I'll figure out the small details. But if you know... (8 Replies)
Discussion started by: ProGrammar
8 Replies

6. Shell Programming and Scripting

help for shell script of finding shortest substring from given string by user

please give me proper solution for finding a shortest substring from given string if string itself and first char and last char of that substr are also given by user if S="dpoaoqooroo" and FC="o" and LC="o",then shortest substr is "oo" and rest of the string is "dpoaoqroo" i have code but it is... (1 Reply)
Discussion started by: pankajd
1 Replies

7. Shell Programming and Scripting

Using Awk in shell script to extract an index of a substring from a parent string

Hi All, I am new to this shell scripting world. Struck up with a problem, can anyone of you please pull me out of this. Requirement : Need to get the index of a substring from a parent string Eg : index("Sandy","dy") should return 4 or 3. My Approach : I used Awk function index to... (2 Replies)
Discussion started by: sandeepms17
2 Replies

8. Shell Programming and Scripting

Substring Function

Just so you know guys, I am a SAP Person and I am very new to UNIX. I need a help on a one line code. In one of our script we are referring to a variable ($PN) which has the value /interfaces/DA1/DEV291/outbound/INVOIC which is being used in ftp command. I am just looking for a command to... (1 Reply)
Discussion started by: sasikumar_l
1 Replies

9. UNIX for Dummies Questions & Answers

Substring function in UNIX shell script

Hi All, Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box: /home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH& /opt/tools/ds/Template/&PH& /data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH& /data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (5 Replies)
Discussion started by: csrazdan
5 Replies

10. Shell Programming and Scripting

Substring function in UNIX shell script

Hi All, Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box: /home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH& /opt/tools/ds/Template/&PH& /data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH& /data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (1 Reply)
Discussion started by: csrazdan
1 Replies

Featured Tech Videos