10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I need to find and replace a date format in a SQL script with sed. The original lines are like this:
ep.begin_date, ep.end_date, ep.facility_code,
AND ep.begin_date <= '01-JUL-2019'
ep.begin_date, ep.end_date, ep.facility_code,
AND ... (15 Replies)
Discussion started by: duke0001
15 Replies
2. Shell Programming and Scripting
Hi,Below is the output for p3fi_dev services
1/app/oracle> . ./oraprofile_p3fi_dev
p3fi_dev_01 (P):/devoragridcn_01/app/oracle> srvctl config service -d p3fi_dev
p3fi_p3fi_dev.world PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
pplnet_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
nexus_p3fidev PREF:... (3 Replies)
Discussion started by: Vishal_dba
3 Replies
3. Shell Programming and Scripting
here are the few scenarios...
isoSizeKB text NOT NULL,
reserved1 varchar(255),
KEY `deviceId` (`deviceId`)
`d5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dHead` enum('HistoryInfo','Diversion') COLLATE utf8_unicode_ci,
`ePR` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
... (7 Replies)
Discussion started by: vivek d r
7 Replies
4. UNIX for Dummies Questions & Answers
Hi
I have a asterisk (*) delimited file and there are some fields which contain data having asterisk , now i want to double quote the fileds which contain data with asterisk
Ex:
input file
ID*NAME*EMAIL
1*BILL*BILL@AOL.com
2*J*OY*JOY@msn.com
in the 2nd record JOY has a asterisk value in... (11 Replies)
Discussion started by: halmstad
11 Replies
5. Shell Programming and Scripting
Hi All,
I wanted to find 200th field value in delimiter file using awk.?
awk '{print $200}' inputfile
I am getting error message :-
awk: The field 200 must be in the range 0 to 199.
The source line number is 1.
The error context is
{print >>> $200 <<< }
using... (4 Replies)
Discussion started by: Jairaj
4 Replies
6. Shell Programming and Scripting
I have a file in which the following pattern is there
TAG001^A<value>^A
I want to find all such values(words) which comes right next to "TAG001^A" and before the next "^A".
^A is the delimiter here.
Please help!
Note: I think ^A in unix resolves to \001 as delimiter (7 Replies)
Discussion started by: royzlife
7 Replies
7. Shell Programming and Scripting
Hi All,
Is there any method we can use to find what is the delimiter used in a text file, asuming the files has fixed number of colomns.
Thanks in advance.
Js (9 Replies)
Discussion started by: jisha
9 Replies
8. Shell Programming and Scripting
Hi All,
I have totally 10 source files. I want to count the delimiter In my source files line by line and need to store the result in another file. I got the output for the total count of delimiter for one file. But I am struggling to get the delimiter count line by line for each my files. Plz... (6 Replies)
Discussion started by: suresh01_apk
6 Replies
9. UNIX for Dummies Questions & Answers
Hi ,
I have extract a single field from the 2nd row of a file of which the format is as given below
"Field1","Field2","Field3",...,"Field17",...
I need to cut Field17 as such (no quotes required)..
I give the command
head -2 file_name | tail -1 | cut -d "," -f17
But the output is... (2 Replies)
Discussion started by: nivin_govindan
2 Replies
10. Shell Programming and Scripting
Hi
I have lines like this
a=1, b=2, c=3,
a=1, d=4, e=5, b=225,
I need to extract the b=nnn... value. I dont know how many other entries will be before and after it in each line. Ive tried a basic line like
awk '/b=/, $NF ~ /,/ ' myfile.txt
but I think that it doesnt care which comma it... (5 Replies)
Discussion started by: rebelbuttmunch
5 Replies