awk loop - substr and sub query


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk loop - substr and sub query
# 15  
Old 08-17-2012
MySQL

Thanks for that.
Working as expected.
I don't think I would considered this syntax.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk and substr

Hello All; I have an input file 'abc.txt' with below text: 512345977,213458,100021 512345978,213454,100031 512345979,213452,100051 512345980,213455,100061 512345981,213456,100071 512345982,213456,100091 512345983,213457,100041 512345984,213451,100011 I need to paste the first field... (10 Replies)
Discussion started by: mystition
10 Replies

2. Shell Programming and Scripting

HELP : awk substr

Hi, - In a file test.wmi Col1 | firstName | lastName 4003 | toto_titi_CT- | otot_itit - I want to have only ( colones $7,$13 and $15) with code 4003 and 4002. for colone $13 I want to have the whole name untill _CT- or _GC- 1- I used the command egrep with awk #egrep -i... (2 Replies)
Discussion started by: georg2014
2 Replies

3. Shell Programming and Scripting

awk substr

Hello life savers!! Is there any way to use substr in awk command for returning one part of a string from declared start and stop point? I mean I know we have this: substr(string, start, length) Do we have anything like possible to use in awk ? : substr(string, start, stop) ... (9 Replies)
Discussion started by: @man
9 Replies

4. Shell Programming and Scripting

Substr with awk

Hi to all, I'm here again, cause I need your help to solve another issue for me. I have some files that have this name format: date_filename.csv In my shell I must rename each file removing the date so that the file name is filename.csv To do this I use this command: fnames=`ls ${fname}|... (2 Replies)
Discussion started by: leobdj
2 Replies

5. Shell Programming and Scripting

awk substr

HI I am using awk and substr function to list out the directory names in the present working directory . I am using below code ls -l | awk '{ if ((substr($1,1,1)) -eq d) {print $9 }}' But the problem is i am getting all the files and directories listed where as the requirement i wrote... (7 Replies)
Discussion started by: prabhu_kumar
7 Replies

6. Shell Programming and Scripting

Help with awk and substr

I have the following to find lines matching "COMPLETE" and extract parts of it using substr. sed -n "/COMPLETE/p" 1.txt | awk 'BEGIN { FS = "\" } {printf"%s %s:%s \n", substr($3,17,3),substr($6,4,1), substr($7,4,1)}' | sort | uniq > temp.txt Worked fine until the numbers in 2nd & 3rd substr... (5 Replies)
Discussion started by: zpn
5 Replies

7. Shell Programming and Scripting

awk substr

Hi I have multiple files that name begins bidb_yyyymm. (yyyymm = current year month of file creation). What I want to do is look at the files and where yyyymm is older than 1 month I want to remove the file from the server. I was looking at looping through the files and getting the yyyymm... (2 Replies)
Discussion started by: colesga
2 Replies

8. UNIX for Dummies Questions & Answers

awk or substr

i have a variable 200612 the last two digits of this variable should be between 1 and 12, it should not be greater than 12 or less than 1 (for ex: 00 or 13,14,15 is not accepted) how do i check for this conditions in a unix shell script. thanks Ram (3 Replies)
Discussion started by: ramky79
3 Replies

9. Shell Programming and Scripting

How to use awk substr ?

Hi all, I have a flatfile I would like to get ext = 7950 , how do I do that ? if ($1 == "CTI-ProgramStart") { ext = substr($9,index($9,"Extension")+11,4); But why it is not working ???? Please help . Thanks (1 Reply)
Discussion started by: sabercats
1 Replies

10. Shell Programming and Scripting

awk substr?

Sorry if this has been posted before, I searched but not sure what I really want to do. I have a file with records that show who has logged into my application: 2003-03-14:I:root: Log_mesg: registered servername:userid. (more after this) I want to pull out the userid, date and time into... (2 Replies)
Discussion started by: MizzGail
2 Replies
Login or Register to Ask a Question
QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME
qrencode - Encode input data in a QR Code and save as a PNG or EPS image. SYNOPSIS
qrencode [OPTION]... [STRING] DESCRIPTION
Libqrencode is a library for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness. Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image. OPTIONS
-h, --help display help message. -o FILENAME, --output=FILENAME write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured symbols are written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified) -s NUMBER, --size=NUMBER specify the size of dot (pixel). (default=3) -l {LMQH}, --level={LMQH} specify error collectin level from L (lowest) to H (highest). (default=L) -v NUMBER, --symversion=NUMBER specify the version of the symbol. (default=auto) -m NUMBER, --margin=NUMBER specify the width of margin. (default=4) -d NUMBER, --dpi=NUMBER specify the DPI of the generated PNG. (default=72) -t {PNG,EPS,ANSI,ANSI256}, --type={PNG,EPS,ANSI,ANSI256} specify the type of the generated image. (default=PNG) -S, --structured make structured symbols. Version must be specified. -k, --kanji assume that the input text contains kanji (shift-jis). -c, --casesensitive encode lower-case alphabet characters in 8-bit mode. (default) -i, --ignorecase ignore case distinctions and use only upper-case characters. -8, --8bit encode entire data in 8-bit mode. -k, -c and -i will be ignored. -M, --micro encode in a Micro QR Code. (experimental) -V, --version display the version number and copyrights of the qrencode. [STRING] input data. If it is not specified, data will be taken from standard input. EXAMPLES
qrencode -l L -v 1 -o output.png 'Hello, world!' encode into a symbol version 1, level L. qrencode -iSv 1 --output=output.png read standard input and encode it into a structured-appended symbols in case-insensitive mode. AUTHOR
Written by Kentaro Fukuchi. RESOURCES
Main Web Site: http://fukuchi.org/works/qrencode/ Source code repository: https://github.com/fukuchi/libqrencode/ COPYRIGHT
Copyright (C) 2006-2012 Kentaro Fukuchi. qrencode 3.3.0 Feb. 29, 2012 QRENCODE(1)