04-23-2007
Extracting part of a string
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.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to extract the uncommon (better say incremental) part from 2 files say file_1 and file_2.
file_2 contains everything that is in file_1. That is file_2 has been created internally somehow :
cat file_1 temp_file > file_2
My objective is to extract the temp_file part from... (2 Replies)
Discussion started by: sabyasm
2 Replies
2. Shell Programming and Scripting
Hi,
I was wondering if there is an easy way to strip off the required basename. I have a script called apb0110021.sh and the contents of the script are
typeset -u MScript=`basename $0 | cut -d. -f1`
scriptname=sys.Audit.ksh
parms="PROJECT1 dsAudit $MScript 1 BEGIN"
$SCRIPTS/$scriptname... (3 Replies)
Discussion started by: madhunk
3 Replies
3. Shell Programming and Scripting
JADE TRADER 143W MYPEN 40 HC M X10 28 7 1 0
MYPEN 20 GP X X10 15 2 1 0
MYPEN 40 GP X X10 28 7 1 0
MYPEN 20... (6 Replies)
Discussion started by: finalight
6 Replies
4. Shell Programming and Scripting
Hi,
I am trying to extract part of a line using "awk". My requirement is to extract the value $6 (which is the last parameter) from a line. As the sixth value contains some space, i am getting only part of the string. so i am trying to extract from $6 to the end of the buffer.
How to do it... (7 Replies)
Discussion started by: venkat_k
7 Replies
5. Shell Programming and Scripting
Hi Guys,
I have a very large XML feed (2.7 MB) which crashes the server at the time of parsing. Now to reduce the load on the server I have a cron job running every 5 min.'s. This job will get the file from the feed host and keep it in the local machine.
This does not solve the problem as... (9 Replies)
Discussion started by: shridhard
9 Replies
6. Shell Programming and Scripting
Hi,
I have a file few hundred MB's with text like one below in single line.
20091117 abc xyg 20091117 def ghi 20091118 ppp ttt 20091118 zzz zzz xxx
I need to extract part of line from 1st occurence of pattern 20091117
till first occurence of another pattern 20091118.
I tried... (3 Replies)
Discussion started by: artistic94555
3 Replies
7. UNIX for Dummies Questions & Answers
I have the code
message={TP=2012:09:23:00:00:00:GMT,SD=2012:09:23:00:00:00:GMT,SP=2,FT=CCGT,FG=3605}
I want to extract the FG=3605 parts of this. Please help. I am trying to do this using awk or unix. (5 Replies)
Discussion started by: JenniferTopham
5 Replies
8. Shell Programming and Scripting
Hi,
I needed to extract some specific characters from a string based on user input. For example: After the script executes the user enters the following details:
Please enter the string: This is a shell script
Please enter the starting position: 11
Please enter the number of characters to be... (4 Replies)
Discussion started by: ChandanN
4 Replies
9. Shell Programming and Scripting
I have a string:
2015-04-16 07:30:05,625000 +0900 xxxx.com
I just want to extract the time from the above line I am using the below syntax
x=~ /(.*) (\d+)\:(\d+)\:(\d+),(.*)\.com/
$time = $2 . ':' . $3 . ':' . $4;
print $time
But it is not working. Can some1 please help (2 Replies)
Discussion started by: karan8810
2 Replies
10. Shell Programming and Scripting
Hi All,
I have log files as below.
log1.txt
<table name="content_analyzer" primary-key="id">
<type="global" />
</table>
<table name="content_analyzer2" primary-key="id">
<type="global" />
</table>
Time taken: 1.008 seconds
ID = gd54321bbvbvbcvb
<table name="content_analyzer"... (7 Replies)
Discussion started by: ROCK_PLSQL
7 Replies
LEARN ABOUT DEBIAN
innoextract
innoextract(1) General Commands Manual innoextract(1)
NAME
innoextract - tool to extract installers created by Inno Setup
SYNOPSIS
innoextract [-behlLqstv] [-ccolor] [-pprogress] installers ...
DESCRIPTION
innoextract is a tool that can extract installer executables created by Inno Setup.
innoextract will extract files from a installers specified on the command line.
To extract a multi-part installer with external data files, only the executable (.exe) file needs to be given as an argument to innoex-
tract.
OPTIONS
-c --color [enable]
By default innoextract will try to detect if the terminal supports shell escape codes and enable or disable color output accord-
ingly. Pass 1 or true to --color to force color output. Pass 0 or false to never output color codes.
--dump Don't convert Windows paths to UNIX paths and don't substitute variables in paths.
-e --extract
Extract all files to the current directory. This is the default action. You may only specify one of --extract , --list and --test
-h --help
Show a list of the supported options.
--language [lang]
Extract only language-independent files and files for the given language. By default all files are extracted.
--license
Show license information.
-l --list
List files contained in the installer but don't extract anything. You may only specify one of --extract , --list and --test
-L --lowercase
Convert filenames stored in the installer to lower-case before extracting.
-p --progress [enable]
By default innoextract will try to detect if the terminal supports shell escape codes and enable or disable progress bar output
accordingly. Pass 1 or true to --progress to force progress bar output. Pass 0 or false to never show a progress bar.
-q --quiet
Less verbose output.
-s --silent
Don't output anything except errors and warnings.
-t --test
Test archive integrity but don't write any output files. You may only specify one of --extract , --list and --test
-v --version
Show the innoextract version number and supported Inno Setup versions.
LIMITATIONS
innoextract currently only supports extracting all the data. There is no support for extracting individual files, components or languages.
Included scripts and checks are not executed.
Data is always extracted to the current directory and the mapping from Inno Setup variables like the application directory to subdirecto-
ries is hard-coded.
innoextract does not check if an installer includes multiple files with the same name and will continually overwrite the destination file
when extracting.
Names for data files in multi-file installers must follow the standard naming scheme.
Encrypted installers are not supported.
SEE ALSO
cabextract(1), unshield(1)
BUGS
No known bugs.
AUTHOR
Daniel Scharrer (daniel@constexpr.org)
1.2 2012-04-01 innoextract(1)