Sponsored Content
Top Forums Shell Programming and Scripting ::select statement return value with correct field size:: Post 302309433 by devtakh on Tuesday 21st of April 2009 10:54:27 PM
Old 04-21-2009
you might want to do

str_out=$(echo $data_type_SQL | sed -e 's/^|//g' -e 's/|$//g' )
loc_TYPE=$(echo $str_out| cut -d\| -f1)
ware_HOUSE=$(echo $str_out| cut -d\| -f2)
local_ID=$(echo $str_out| cut -d\| -f3)


cheers,
Devaraj Takhellambam
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Error : Field $() is not correct

Hi All, I'm new to shell scripting. Trying to extract substring using awk script as shown below : Flag=$1 Length=`echo ${#Flag}` NewLen=$Length-2 NewFlag=`echo $Flag|awk '{print substr($Flag,0,$NewLen)}'` echo "New string is : $NewFlag" exit When I execute this script the following... (3 Replies)
Discussion started by: abbey
3 Replies

2. UNIX and Linux Applications

Oracle Select IN statement

If I recall, when I used informix I could do a sql statement like: SELECT Value from Table WHERE ID in (100,200,300); How do I do this in Oracle? I believe I am using Oracle 10 if that matters. Thanks. (1 Reply)
Discussion started by: benefactr
1 Replies

3. Shell Programming and Scripting

How can i assign an select statement into a variable?

I am trying to assign an select statement into a variable. Can someone hel me with this. example : a='select * from dual' echo $a should give me select * from dual But this is not working. I trying with \ before * and quotes too. (1 Reply)
Discussion started by: rdhanek
1 Replies

4. Shell Programming and Scripting

Please help inserting the correct if-then-else statement

Hi All, I have this script below that checks rpm code version to Linux and Solaris servers. The script is run using arguement ($1) which is server_list.txt. It runs as: $ ./scriptname server_list.txt #!/bin/bash QUERY="/opt/rpm/bin/rpm -qa --queryformat '%{installtime}... (0 Replies)
Discussion started by: linuxgeek
0 Replies

5. Shell Programming and Scripting

Select variable within a if statement

i want to select a variable created and use it in a if statement, but not getting the desired results LINE='device for 0101a01: lpd://172.25.41.111:515' prt=`echo $LINE | awk '{print $3 }' | cut -c 1-7` echo $prt My if statement to select just what i want.. IFS=$":" while read prt... (11 Replies)
Discussion started by: ggoliath
11 Replies

6. UNIX for Dummies Questions & Answers

How to select correct partition and kernel argument for grub?

I use command-line mode of GRUB to load kernel, but I can not know how to chose the partition and kernel argument, as followed : please tell me how to do deal with , thanks! (0 Replies)
Discussion started by: cqlouis
0 Replies

7. Shell Programming and Scripting

if statement is not giving correct op

Hi I am using a awk command but not getting required o/p. input file a.txt 2 ak 3 cb 4 de 5 gh 6 ij awk program BEGIN { x=0 } {if ($1>3) {x=x+1}{print $0} } END { print "I found " x " line have value more than 3" } output 2 ak 3 cb 4 de 5 gh 6 ij (3 Replies)
Discussion started by: aaysa123
3 Replies

8. UNIX for Dummies Questions & Answers

Select Command - return

Hello everyone, A simple question which may have a suggested solution: I am using, and loving, the select command in a ksh93 script on AIX 6.1 to present users with menus. I have been successful in controlling all of key input by the users, I still have an issue with the RETURN key. When the... (4 Replies)
Discussion started by: gio001
4 Replies

9. Shell Programming and Scripting

Problem with select statement

Hi I have run out of ideas as to why this select doesn't work in a script I am writing. The script sources a file of common functions and I am trying to use a select statement within one of the functions - PS3="Try? " select X in CONT EXIT; do if ] ... (4 Replies)
Discussion started by: steadyonabix
4 Replies

10. Shell Programming and Scripting

Id command does not return correct username

On server1 the "id" command works fine and returns "myuser" user as was expected. Below are the details of the good server. $ id -nu 501 myuser $ cat /etc/system-release Red Hat Enterprise Linux Server release 7.6 (Maipo) $ uname -a Linux server1 3.10.0-957.el7.x86_64 #1 SMP Thu Oct 4... (10 Replies)
Discussion started by: mohtashims
10 Replies
WORDWRAP(3)								 1							       WORDWRAP(3)

wordwrap - Wraps a string to a given number of characters

SYNOPSIS
string wordwrap (string $str, [int $width = 75], [string $break = "0], [bool $cut = false]) DESCRIPTION
Wraps a string to a given number of characters using a string break character. PARAMETERS
o $str - The input string. o $width - The number of characters at which the string will be wrapped. o $break - The line is broken using the optional $break parameter. o $cut - If the $cut is set to TRUE, the string is always wrapped at or before the specified $width. So if you have a word that is larger than the given width, it is broken apart. (See second example). When FALSE the function does not split the word even if the $width is smaller than the word width. RETURN VALUES
Returns the given string wrapped at the specified length. EXAMPLES
Example #1 wordwrap(3) example <?php $text = "The quick brown fox jumped over the lazy dog."; $newtext = wordwrap($text, 20, "<br /> "); echo $newtext; ?> The above example will output: The quick brown fox<br /> jumped over the lazy<br /> dog. Example #2 wordwrap(3) example <?php $text = "A very long woooooooooooord."; $newtext = wordwrap($text, 8, " ", true); echo "$newtext "; ?> The above example will output: A very long wooooooo ooooord. Example #3 wordwrap(3) example <?php $text = "A very long woooooooooooooooooord. and something"; $newtext = wordwrap($text, 8, " ", false); echo "$newtext "; ?> The above example will output: A very long woooooooooooooooooord. and something SEE ALSO
nl2br(3), chunk_split(3). PHP Documentation Group WORDWRAP(3)
All times are GMT -4. The time now is 10:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy