|
|
Sponsored Content
Operating Systems
Linux
Selecting substring (like SQL Server function)
Post 302452525 by ProGrammar on Friday 10th of September 2010 11:29:55 PM
09-11-2010
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 the unique syntax, I'd prefer to do it in bourne shell and I'm using Linux RedHat Enterprise ver 2.6.9-55.ELsmp (if that makes a diff).
e.g. in SQL Server and I know this is a far cry from Linux, but this is just to demonstrate what I hope to achieve:
they have a substring function:
SELECT SUBSTRING(abcdefgh,4,3)
which produces "def" as a result
abcdefgh = expression, 4 specifies the starting character position, and the three specifies how many characters to extract FROM the starting character position
how, if desired, could I accomplish similar results using UNIX/LINUX?!
Thanks for your time/attention in advance!!
your friendly-neighborhood ProGrammar.
)!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 the unique syntax, I'd prefer to do it in bourne shell and I'm using Linux RedHat Enterprise ver 2.6.9-55.ELsmp (if that makes a diff).
e.g. in SQL Server and I know this is a far cry from Linux, but this is just to demonstrate what I hope to achieve:
they have a substring function:
SELECT SUBSTRING(abcdefgh,4,3)
which produces "def" as a result
abcdefgh = expression, 4 specifies the starting character position, and the three specifies how many characters to extract FROM the starting character position
how, if desired, could I accomplish similar results using UNIX/LINUX?!
Thanks for your time/attention in advance!!
your friendly-neighborhood ProGrammar.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
Hi All,
I have a shell script in which i want to invoke PL/SQL function and importantly get the return value from the PL/SQL function.
Pls let me know how to go about this.
Regards,
Krishna (0 Replies)
Discussion started by: KrishnaSaran
0 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. Shell Programming and Scripting
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... (7 Replies)
Discussion started by: anilvvnn
7 Replies
7. Shell Programming and Scripting
hi,
I want to know how to call a pl sql function testfunction(param1,..) that returns a value and grab that value in a shell variable.
Thnx in advance
---------- Post updated 03-30-10 at 11:58 AM ---------- Previous update was 03-29-10 at 03:49 PM ----------
thnx a lot jim (0 Replies)
Discussion started by: austinhell3_16
0 Replies
8. Shell Programming and Scripting
Hi,
I have a function which connects to the db and runs the sql.
it works fine when I run it like: function "select empname from emp;"
but when I try to pass the sql string to a variable which in turn in fed to the function , it throws error.
please advise.
Thanks,
Arnie. (1 Reply)
Discussion started by: itsarnie
1 Replies
9. Shell Programming and Scripting
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
10. UNIX for Dummies Questions & Answers
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
LEARN ABOUT OSF1
wcsstr
wcsstr(3) Library Functions Manual wcsstr(3) NAME
wcsstr - Finds a wide-character substring LIBRARY
Standard C Library (libc) SYNOPSIS
#include <wchar.h> wchar_t *wcsstr( const wchar_t *s1, const wchar_t *s2); STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: wcsstr(): XSH5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. PARAMETERS
Specifies the wide-character string being searched. Specifies the wide-character substring to be located. DESCRIPTION
The wcsstr() function locates the first occurrence in the wide-character string pointed to by the s1 parameter of the sequence of wide characters in the wide-character string pointed to by the s2 parameter, excluding the terminating null wide character. RETURN VALUES
Upon successful completion, the wcsstr() function returns a pointer to the located wide-character substring or a null pointer when the sub- string is not found. If the s2 parameter points to a wide-character substring having 0 (zero) length, the wcsstr() function returns the entire wide-character string pointed to by parameter s1. [Tru64 UNIX] On error, the function returns a null pointer. RELATED INFORMATION
Functions: strstr(3), wcswcs(3) Standards: standards(5) delim off wcsstr(3)