Hi Experts,
I have called file1.txt contains below
CREATE TABLE "IHUBDEV2"."TLM_BREAK_RULES"
( "OID" VARCHAR2(32) NOT NULL ENABLE,
"TLM_PAY_CLASS_OID" VARCHAR2(32) NOT NULL ENABLE,
"PUNCHED_BREAKS" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE,
"NORMAL_BREAKS"... (3 Replies)
How to extract multiple data based on character position. I need to fetch from 7-9 and 22-26 and there is no delimiter for 22-26 since it is part of the column. The file may have more than 1000 character long.I managed to pull any one but not both
for example
test data
12345 zxc vbnmlk... (1 Reply)
I would like to cut words based on the word count of a line. This over here inspired me with some ideas but I wasn't able to get what I needed.
https://www.unix.com/shell-programming-scripting/105841-count-words-each-line-file-using-xargs.html
If the line has 6 words I would like to use this.... (8 Replies)
hello!
i'd like to ask if there's a way using sed in order to cut every character of a line after a certain character.My output looks like this:
blabla blavbla blabla # bla bla bla
and i want it to be :
blabla blavbla blabla
thanks in advance (5 Replies)
I'm looking for what I hope might be a one liner along these lines:
sed '/a line with more than 3 pipes in it/d'
I know how to get the pipe count in a string and store it in a variable, but I'm greedy enough to hope that it's possible via regex in the /.../d context. Am I asking too much? ... (5 Replies)
cat fileanme.txt
custom1=, custom2=, userPulseId=3005, accountPolicyId=1, custom3=, custom4=, homeLocationId=0, i need to make the fields appear in next line based on identifier (,) ie comma
so output should read
cat fileanme.txt
custom1=,
custom2=,
userPulseId=3005,
... (8 Replies)
Hi,
My first time on this site, please excuse me if I've come to the wrong forum. I'm fairly new to Unix/Linux and hoping you can help me out.
I'm looking for a command line that will return a list of directories that are larger than 50M and older than 2 days.
I thought it may be... (6 Replies)
I have a file which has first 2 junk characters(X^C) at beginning of each line in file. When i run cut -c 2- filename it removes junk characters from all lines except on first line it keeps one junk character control C(^C). Not sure why it is not removing only from first line. (2 Replies)
I have a huge file which contains multiple lines. It need to check whether character length is not more than 255 each line. If its not then it should remove the
character up to column. I have described in the output below. If its more than that
the next line should start with call but if the... (1 Reply)
Discussion started by: JoshvaPeter
1 Replies
LEARN ABOUT PHP
db2_field_type
DB2_FIELD_TYPE(3) 1 DB2_FIELD_TYPE(3)db2_field_type - Returns the data type of the indicated column in a result setSYNOPSIS
string db2_field_type (resource $stmt, mixed $column)
DESCRIPTION
Returns the data type of the indicated column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns a string containing the defined data type of the specified column. If the specified column does not exist in the result set,
db2_field_type(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_TYPE(3)