Search Results

Hi,

i have a flat file namely temp.txt with this data below
ID|name|contact_date
101|Kay|2013-12-26
102|let|2013-12-26

I need to modify the date data in the flat file into MM/DD/YYYY...

Hello,

I have a file name like FIRST_DPF_DAILY_CUST_0826152322.txt

i need to extract the string after the third "_" underscore upto timestamp ends i.e CUST_0826152322

can anyone help me...

Hi,

I need to modify the header of the flat file, can you provide me the code

example: Temp.txt
header: list_col1|list_col2|list_col3
data: 1|2|3

in the above header should be...

1. table name and schema name should be passed as input parameters to the script
2. taking those inputs it should validate all the database objects
3. after validating it should write to a .csv or...

Hi,

I need a sample script to validate all the database objects like

1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc

thank you!

Hi,

I cannot run ftp on the tempfile, i can run only on $direcorylocation/$filename - this value is predefined.

Hi,

Thanks for the update!

But i need to modify the columnname from "standard" to "standardand" in the flat file before it is FTPied to a particular location.

a filename with directory...

Hi,

Can anyone let me know the sed command usage

requirement:

sed 's/standard/standard_and/' <new.txt>new.txt

here it needs to search for the pattern "standard" in the file new.txt...

Hi,

i will not have access to their server, what are all i need to do is

1. i need to FTP a flat file with extension .txt
2. immediate step after the flat file was ftpied is i need to...

Hi,

I have a FTP server and a directory location where i will be FTPing the flat file.

My requirement is
After the flat file was generated to the location, i need to write some trigger file...

Hi,

Thank you for the reply.

can you pls tell me what's the difference between these two

awk 'NR==1 || FNR>1' flatfile1_v_*


awk 'NR==1 || FNR>1{print;}' file_list

I didnt get from you what is double post

Hi,

My requirement is search for the flat files in the location that are generated in a day and merge them into a single flat file.

In the merged file as well particular column value should...

awk 'NR=1 FNR>1' $(ls -rt flatfile1_v_*)

when i use this command for merging the flat files into a single file header is coming two times in a single file, but i wanted it only one what i need to...

sorry i forgot to mention, there is separator for the data as well.

---------- Post updated at 03:20 AM ---------- Previous update was at 03:14 AM ----------

can you explain me what this code...

Hi,

Thank you!

There is a location like:

scripts/new/projectdir/

in which there is a chance of generating a two or three flat files per day,
they will be with name as...

Hi,

My requirement is,there is a directory location like:

:camp/current/

In this location there can be different flat files that are generated in a single day with same header and the...

Hi,
i understood the script you have sent but i have a config file which is sent to us
which have the details
1.fileheader=2
2.filefooter=2
3.location:/scripts/filename.txt ---this file where...

Hi,

Issue is like i will be having a config file where i will have the details like

1.fileheader:2
2.filefooter:2
3.Filelocation:/......../

all these i will take these details and need...

Hi,

Can you please tell me the Unix shell script for removing footer from the datafile while loading into external table using sqlloader

we will be skipping the header like this while...

Hi,

How to add trailer record at the end of the flat file in the unix ksh shell scripting

can you please let me know the procedure

Regards
Srikanth

Hi,

I have a situation like

awk '/\|~\|$/{$0=$0" "}1' filename.txt > output.txt

in the above code filename.txt is coming from other server

so i cant use this line in a generic...

Hi,

Thanks bartus11 for the very useful information

can you please expalin me how this highlighted line is working....?

awk '/\|~\|$/{$0=$0" "}1' file > new_file

Hi,

I just want one single space if the records ends with a delimter.
if the record doesnt end with delimter nothing should be appended

Thanks!

Hi,

Can you please give me the script,because i didnt know how to read the flat file and rotate the loop for each and every record in the flat file