UPDATE PS_CA_BI_FF2_TA3 SET DELETE_ME = 'Y' WHERE PROCESS_INSTANCE BI.LAST_UPDATE_DTTM FROM PS_CA_BP_LINES LINE, PS_INTFC_BI BI WHERE EXISTS ( SELECT 'X' FROM PS_CA_BILL_PLAN BP WHERE BP.CONTRACT_NUM %Select(COUNTER4) SELECT COUNT(*) FROM PS_INTFC_BI WHERE INTFC_ID
I'm trying to extract all the words begining with " PS_" from the lines and only the words. The results should look like
I'm using the sed command: (x.x = filename containing these strings) but I keep getting the results that look like the following:
PS_CA_BI_FF2_TA3 SET DELETE_ME = 'Y' WHERE PROCESS_INSTANCE PS_CA_BP_LINES LINE, PS_INTFC_BI BI WHERE PS_INTFC_BI BI WHERE PS_CA_BILL_PLAN BP WHERE BP.CONTRACT_NUM PS_INTFC_BI WHERE INTFC_ID
How do I stop the extract to the end of the word or space after the word? Any suggestions would be appreciated.
Hi all,
I need to extract the Particular string from the whole word,the input file is :
123,345,aaaa,555,....,....
I need all the record from 345 so i need to eliminate the first record.
Output:
345,aaa,5555,....,.....,.....
Thanks in advance. (3 Replies)
Hi Guys,
Need you quick assistance on the below, trying to extract a word from a variable
i.e. acmi101acmi102acmi103acmi104
When i use the following code awk '{gsub(/cmi102/,"")};1' it leaves a space in the variable, need to get rid of the space that it leaves. Any ideas.
the above... (3 Replies)
Hi there!
Well, I'm writing a script to obtain certain information about files. Specifically, I want to get the information about those files which last access were in the last 24 hours, so I'm doing something like this:
find <directory_name> -atime -1 -printf '%f %a\n'
I would also... (4 Replies)
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)
Hello All,
I am extracting a part of file. the file looks as follows
USING CHARACTER SET UTF8 DEFINE JOB
(
DEFINE SCHEMA Flat_File_Schema
(
cntnt_id VARCHAR(10)
);
DEFINE OPERATOR o_mload
TYPE update
SCHEMA *
ATTRIBUTES
(
VARCHAR TdpId = @TdpId (5 Replies)
Hello.
from a text file, I want to get only the first word ( before blank ) following code=
grep -i -e "WORD1" "/path/to/text/file.txt | sed -n 's/WORD1\+//p' | sed -n 's/code=/\1/p'
return an error.
sed: -e expression #1, char 12: invalid reference \1 on `s' command's RHSFor debugging... (12 Replies)
Hi Folks,
Could you please advise what will be the SED command to replace a word in all xml's under a particular directory
for example let say I rite now at the following below location
$ cd /ter/rap/config
now under config directory there will be lots of xml file , now my objective is to... (1 Reply)