Search Results

yes, it working . iam getting | in 4th position ,if field 4 is null.

I want overwrite in same file? by using sed command?

I want to write in same file ?

Hi I have file as given below
040|14300|40.0|563000
042|13200000|40.0
041|100|40.0
043|10000|40.0
045|102|40.0

I want to check
if field 4 is null then I have to place | in position 4.
...

Hi Ravinder,

its working :)

iam getting <<Thu 01 Jan 1970 10:00:00 AM AEST>>

I want the data as <<1970-01-01 10:00:00>>

Hi Ravinder,

it is working fine. I want it to change in whole file for 2nd column.

Note: I have to load data into Teradata table, so I required it to convert into timestamp(6) format.

Hi Team,

Could you please let me know ,how to convert Epoch column to timestamp in a flat file.

"57894"|"1454247163111"|"""HH"""
"57897"|"1454247163111"|"""HH"""...

Hi Rudic,

in some records we will have credate and in some records it will change.the code which you have provided it works fine.

for other records which is not having credate ,I have placed ...

Hi Rudic,

Thanks for your reply.
if my input file don't have credate.for example...

I have input file
...

Hi Rdrtx,

Still iam facing same issue. First record getting incorrect value for the both output.PFB error

Output1:
IDN|emp_sal|emp_value[/B]|1410
me:ram|XXXX|600000|CREDITCARD

Output2:...

Hi RDRTX,

Thanks for your reply :)

its working , but there is some discrepancy in the output of the first record. the first record in the file1 should be "01|ram|600000| CREDITCARD " and in...

could you please provide solution to split file and load into different files in shell script.


cat test.txt
"01"|""emp_name"":ram|""emp_sal"":600000|""emp_value"":""CREDITCARD""|""1410"":[[100...