Get information like substring Post: 302283676

Sponsored Content

Top Forums Shell Programming and Scripting Get information like substring Post 302283676 by cfajohnson on Tuesday 3rd of February 2009 09:42:41 PM

02-03-2009

Registered User

Quote:

Originally Posted by uativan

Really sorry about the misleading. Since I am not familiar with shell script, I can just tell you what I can see from the screen.

1. Single line
before asking

name=$(pgsql -c "select name from teacher")
echo $name

I can see only a single line display out there.
name ------------ Mary Lee (1 row)

Try:
Code:
echo "$name"

Quote:

Now I know that it is an array.

No, it's not. It is a scalar variable containing more than one line.

Quote:

name
------------
Mary
Lee
(1
row)

There are no white spaces.

What command produced that?

Quote:

2. "quote"

Because from the screen of
name=$(pgsql -c "select name from teacher")
name=${name% (*}
echo "${name#*- }"

I found some white spaces next to Mary Lee, so want to show you there are some white spaces only.

It should be like that
 name
------------
 Mary Lee
(1 row)

3. Latest code

LF='
'
name=$(pgsql -c "select name from teacher")
name=${name%$LF(*}
echo "${name#*-$LF}"

------------
Mary Lee
<<blank line>>

Sorry again for the misinformation.

What is the output from:
Code:
pgsql -c "select name from teacher" | od -c

cfajohnson

View Public Profile for cfajohnson

Find all posts by cfajohnson

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

getting a substring

Hi, I have several lines like this ones: 123456789abcde /aa/bb/123456_$data.log 123456789abcde /aa/bb/123456_not_a_data_log 987654321ab /aa/bb/xpto123456_$data.log ... How do I get into a variable the value "/aa/bb/123456_$data.log" , searching only for the beggining and ending...

2. Shell Programming and Scripting

Getting a substring

This is probably pretty simple butI'm not sure how to best go about it. If I have FILE="myBigLongFileName_1.xls" FILE_PREFIX=`echo $FILE| cut -d"." -f1` # that gives "myBigLongFileName_1" All i want to do now is chop the "_1" from the end of $FILE_PREFIX Any ideas anyone?

3. Shell Programming and Scripting

how to get substring

i have a strings abc-def.csv ghi-jkl.csv i want to make it as abc-*-def.xyz ghi-*-jkl.xyz How to do it?.

4. UNIX for Dummies Questions & Answers

substring

Hi, I have a value of a filepath in a variable DATAFILE with value as "customtop/gpsore37/gepspo/1.0/bin/ashoka.csv ". Now i want the value of last 4 charcters in to another variable. That is EXTENSION = .csv How can i do this in Shell scripting Thanks in advance Alla Kishore

5. UNIX for Dummies Questions & Answers

Need help with substring

I need to check the occurrence of one string within another. code ******************** if ;then do something done ******************** Thanks

6. UNIX for Dummies Questions & Answers

Substring

Hi I use the below cmd to get the list of files that are modified than <temp> file in the <path> diretory cmd:find <path> -name '*.zip' -type f -newer <temp> -print i am getting all the list of files that are new or modified, with abs path, i want to copy all of these files to a...

7. Shell Programming and Scripting

substring

I have a string '<Hi>abc</Hi>" How to print "abc"

8. UNIX for Dummies Questions & Answers

Getting Substring

Hi, I hav a string lets say aa.txt:bb:txt length of the string can vary.. I have to keep the token inside a array and the delimiter is : plz send me the code

9. Shell Programming and Scripting

Get the substring

Hi All, I have a ouput string likes 'u8wos' or 'u10acsd' or somthing else 'u{number}{any characters}'and I want to get the number behind the letter 'u' by bash shell. Thanks Damon

10. UNIX for Dummies Questions & Answers

Substring

Hi, My requirement is to get the substring and then remove special character. Ex I have data like T_SYSTEM_XXXXX_YYYY_ZZZ I want to get XXXXXYYYYZZZ the part after T_SYSTEM is varying it might be XXX_YY or just XX can you tell me which all commands i have to use. i understand i...

LEARN ABOUT DEBIAN

xmlindent

xmlindent(1)															      xmlindent(1)

NAME

       xmlindent - XML stream reformatter

SYNTAX

       xmlindent [-o output file] [-i indent level] [-l max columns] [-n newline position] [-t] [-c] [-f] [-w] [-h] [-v]

DESCRIPTION

       XML Indent is a XML stream reformatter written in ANSI C. It is analogous to GNU indent.

OPTIONS

       -o output file
	      Write indented XML to output file

       -i indent level
	      Indent each level indent level spaces deeper

       -l max columns
	      Wrap lines longer than max columns

       -t     Use tabs instead of spaces

       -nas   Suppress newline after start-tag

       -nae   Suppress newline after end-tag

       -nbs   Suppress newline before start-tag

       -nbe   Suppress newline before end-tag

       -f     Force newline on elements without children

       -w     Overwrite original file

       -v     Show version

       -h     Show command line help

AUTHORS

       Pekka Enberg <penberg@iki.fi>
       Thomas Fischer <th.fischer@gmx.net> (man page)

SEE ALSO

       indent(1)

Thomas Fischer							      0.2.17							      xmlindent(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

getting a substring

Discussion started by: Scarlos

2. Shell Programming and Scripting

Getting a substring

Discussion started by: djkane

3. Shell Programming and Scripting

how to get substring

Discussion started by: senthilk615

4. UNIX for Dummies Questions & Answers

substring

Discussion started by: alla.kishore

5. UNIX for Dummies Questions & Answers

Need help with substring

Discussion started by: w020637

6. UNIX for Dummies Questions & Answers

Substring

Discussion started by: Naveen_5960

7. Shell Programming and Scripting

substring

Discussion started by: sandy1028

8. UNIX for Dummies Questions & Answers

Getting Substring

Discussion started by: Deekay.p

9. Shell Programming and Scripting

Get the substring

Discussion started by: Damon_Qu

10. UNIX for Dummies Questions & Answers

Substring

Discussion started by: Mohammed_Tabish

LEARN ABOUT DEBIAN

xmlindent