Could you try grep -Po '\d+' instead?
On Wed, Jan 8, 2014 at 4:03 AM, yogesh kumar <[email protected]> wrote: > Hello Abe, > > the query > > VAR=$(sqoop-eval > --query "select max(Salary) from emp..." \ > --username ${user} \ > --password ${Pass} \ > | tee --append ${SQOOP_LOG} | awk '/([0-9]+)/{print $2}') > > some time give output like "| 201144 " > > say echo $VAR > o/p > | 201144 > > I want to remove the unwanted character and a space "| " , could you pls > suggest how to trim this and get proper value into a variable i.e 201144 > > pls suggest > > Thanks & Regards > Yogesh Kumar > > > > > On Tue, Dec 31, 2013 at 11:54 PM, Abraham Elmahrek <[email protected]>wrote: > >> Hey user, >> >> You should be able to use the "tee" command for something like that. >> >> VAR=$(sqoop-eval >> --query "select max(Salary) from emp..." \ >> --username ${user} \ >> --password ${Pass} \ >> | tee --append ${SQOOP_LOG} | awk '/([0-9]+)/{print $2}') >> >> -Abe >> >> >> On Tue, Dec 31, 2013 at 2:17 AM, yogesh kumar <[email protected]>wrote: >> >>> Thanks Abe. >>> >>> I have tried this >>> >>> VAR=$(sqoop-eval >>> --query "select max(Salary) from emp..." \ >>> --username ${user} \ >>> --password ${Pass} \ >>> >> ${SQOOP_LOG} 2>&1 | awk '/([0-9]+)/{print $2}') >>> >>> echo "The vale of VAR is " >>> echo $VAR >>> >>> It dosen't store the vale into VAR, It shows it into a Log file i have >>> used by passing through a config file >>> >>> *In here If if do remove " >> ${SQOOP_LOG} 2>&1 " it shows the result >>> and store the value into VAR but also the messages from sqoop to the >>> consol.* >>> I put all sqoop messages in a log file by using this . >>> >>> I was trying to put sqoop messages into a file and the result into a >>> VAR, >>> >>> Pls suggest whats I am missing here or how to get it >>> >>> Many thanks in advance and a very happy new year >>> >>> Thanks >>> Yogesh >>> >>> >>> >>> On Tue, Dec 31, 2013 at 2:55 AM, Abraham Elmahrek <[email protected]>wrote: >>> >>>> Sorry, >>>> >>>> To be more clear... you should be able to do something like: >>>> >>>> MYVAL=$(sqoop-eval -query "SELECT COUNT(*) FROM test" ... | awk >>>> '/([0-9]+)/{print $2}') >>>> >>>> or >>>> >>>> MYVAL=$(sqoop-eval -query "SELECT COUNT(*) FROM test" ... | grep -Po >>>> "\d+") >>>> >>>> -Abe >>>> >>>> >>>> On Mon, Dec 30, 2013 at 1:17 PM, Abraham Elmahrek <[email protected]>wrote: >>>> >>>>> Hey There, >>>>> >>>>> The Sqoop eval command is more for verification and preview purposes >>>>> than actual usage. With that being said... you can definitely pipe the >>>>> result of sqoop eval into a file and perform what ever formatting you see >>>>> fit (ie with AWK). >>>>> >>>>> -Abe >>>>> >>>>> >>>>> On Mon, Dec 30, 2013 at 2:09 AM, yogesh kumar >>>>> <[email protected]>wrote: >>>>> >>>>>> Hello all, >>>>>> >>>>>> I am doing some select operation with sqoop evel function. like >>>>>> >>>>>> sqoop eval -libjars .. >>>>>> --query "select max(salary) from employe where dept = HR" >>>>>> -- username abc >>>>>> --password abc >>>>>> >>>>>> >>>>>> Its working fine, I want to store the result of this query into a >>>>>> unix shell script variable.. >>>>>> for using this vale for further operations... >>>>>> >>>>>> >>>>>> Pls help and suggest how to stroe the value into a vriable. >>>>>> >>>>>> Thanks & Regards >>>>>> Yogesh Kumar >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >> >
