Hi,
I have tried to develop a sed script that inserts date and time in the third field in the first and second row below. The third row is an example and it shows where the date and time should be inserted. The script should check if the row already has date and time in the third field and if it... (2 Replies)
I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this:
abc ||| 5e-05 ||| bla
abc ||| 3 ||| ble
def ||| 1 ||| abc
def ||| 0.2 ||| def
As you can see it ignores the fact that 5e-05 is actually 0.00005... (1 Reply)
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)
Hello,
Hoping someone can help!
I have a file (fileA) with a potentially different number of | delimited fields the file looks like:
fileA
A|B|C|D|E|F|G|
A|B|C|D|E|F|G|
This file could have 100+ fields and have 2million+ records
I have another file (fileB) which contains an 8 digit... (3 Replies)
I have a '|' delimited file.
My file looks like below
23|nationalhoilday|feb12||||||||||||||california|northdistrict||
In the same way, each record has 164 fields. I have to insert one more field after the 85th field.
Expected output... (3 Replies)
Hello Mates,
I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434
Out put should be:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434
Can some one help me to... (8 Replies)
I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number.
As an example, let's assume there are only 4 fields in the file:
A,A,,32
A,A,,27
A,B,,43
C,C,,354
If I wanted to amend the 3rd field in this way my... (2 Replies)
Hi,
I have a file which looks like this:
A 01 00
B 02 00
C 04 00
D 00 01
E 01 01
F 02 01
G 01 04
H 02 04
I want to insert some text if the field if the last column changes. It should look like this:
Value 00
A 01 00
B 02 00
C 04 00
Value 01 (6 Replies)