Sponsored Content
Operating Systems Linux Selecting substring (like SQL Server function) Post 302452602 by ProGrammar on Saturday 11th of September 2010 08:26:21 PM
Old 09-11-2010
lemme rephrase...

what keywords should I research to find more about the use/features/options of the ":#:#" convention??

e.g. does that feature have a name?!

You know variable expansion covers how the shell interprets variables, but if people don't know the term "expansion", they might query for the wrong things. You get my point...

I've read lots of documentation and have never come across that, I'm thoroughly familiar with sed, my awk knowledge needs to catch up though.

Dude, I really appreciate this technique. It'll be very helpful when extracting certain portions of uniformly-formatted strings and storing to variables.

So if you know of a particular name (keyword) for that string:#:# technique, I'd appreciate it.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. Shell Programming and Scripting

PL/SQL function from shell script

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

Execute PL/SQL function from Unix script (.sql file)

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

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... (7 Replies)
Discussion started by: anilvvnn
7 Replies

7. Shell Programming and Scripting

Call a pl sql function from unix

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

Passing sql as parameter to unix function

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

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

10. 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
lorder(1)						      General Commands Manual							 lorder(1)

NAME
lorder - find ordering relation for an object library SYNOPSIS
[files] DESCRIPTION
The input consists of one or more object or archive library files (see ar(1)) placed on the command line or read from standard input. The standard output is a list of pairs of object file names, meaning that the first file of the pair refers to external identifiers defined in the second. Output can be processed by to find an ordering of a library suitable for one-pass access by (see tsort(1) and ld(1)). Note that the link editor is capable of multiple passes over an archive in the archive format and does not require that be used when building an archive. Using the command may, however, allow for a slightly more efficient access of the archive during the link edit process. The symbol table maintained by allows to randomly access symbols and files in the archive, making the use of unnecessary when building ar- chive libraries (see ar(1)). EXTERNAL INFLUENCES
Environment Variables The following internationalization variables affect the execution of Determines the locale category for native language, local customs and coded character set in the absence of and other environment variables. If is not specified or is set to the empty string, a default of (see lang(5)) is used instead of Determines the values for all locale categories and has precedence over and other environment variables. Determines the locale category for character collation. Determines the locale category for character handling functions. Determines the locale that should be used to affect the format and contents of diagnostic messages written to standard error. Determines the locale category for numeric formatting. Determines the location of message catalogues for the processing of If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to See envi- ron(5). International Code Set Support Single- and multi-byte character code sets are supported. EXAMPLES
Build a new library from existing files: When creating libraries with so many objects that the shell cannot properly handle the expansion, the following technique may prove useful: WARNINGS
Object files whose names do not end with are overlooked, even when contained in library archives. Their global symbols and references are attributed to some other file. FILES
temporary files SEE ALSO System Tools: ar(1) create archived libraries ld(1) invoke the link editor Miscellaneous: tsort(1) produce an ordered list of items (topological sort) STANDARDS CONFORMANCE
lorder(1)
All times are GMT -4. The time now is 11:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy