Search Results

Hi,

All my source files are having the format of tar.gz . When we have loaded the data in our target output file, we are getting some characters also in our output file like this

Actual...

I resolved my problem. Thanks ahamed.

Thanks for your reply ahamed.

In my two output files I am getting the source filenames in my target output files. Now, I need to load the data in target file without having source filenames. I...

Hi All,

I havae 2 files like this
File1.dat.tar.gz--- has
+667866066123|20110506
+667866066866|20110405

File2.dat.tar.gz -----contains
+447866066123|20110505
+447866066866|20110405
...

Hi All,
I have totally two server. First server name is ABC which contains the file name is Sum.txt and Second server name is Sun here one file generate during the runtime.

Currently I am in...

Hi guys,

I have a problem in unix shell script for abinitio.
if i'm using air sandbox parameters command to set the parameter
ABC_FILE_MASK to this value ^abc_rules_[0-9][0-9].csv$ , it is...

really thanks for quick response and thanks for your timely help

Hi All,

I have different type of file (.txt,.csv,.xml) format in my current directory. My requirement is that I need to remove the last character from the file format.

Example
count.txt$...

Really Thanks for your quick replies

Hi Folks,

I have different type of file in my current directory. From my current directory i need to move the file which is start with csp_rules and if the file is having the string payg , then I...

Thanks for you reply. I am new to unix. If any ideas are really helpful for me.

Hi Everyone,

I have a file with 10000 records. For all the source records I need to create a Unique key values.
Day 1
I am loading the data into target table. Now it has 10000 records with...

File1.txt
Columns:

Header - Transaction Date - currentdate(2011-15-09)
Trailer - TotCnt - 2500

File2.txt

Last_ETL_Proccess_date
(2011-10-09)

Logic:

1....

I have checked in search forum. I have not find any Information related to my Issue. Any Input is really helpful for me

Hi All,

I have received new business requirement. I have mentioned below that requirement. As I am new to Unix, Please guide me how to do this.

I have a file. It contains Header record , few...

Hi,

I have to invoke an URL from the shell script. As I am new to Unix, I don't have Idea how to achieve this. Experts please guide me how to achieve this logic?:confused:

Hi yinyuemi,

Thx for your response. Can you explain the command what it does? It will be really helpful for me

Hi All,

I have problem in my file. It has two date variable.

There are 2 variables which has the values as below
1. START_MONTH = “Date(YYYYMM) format” Ex: 201008
2. END_MONTH = ...

My source file having one date column. The formate of the date column is yyyymm. I need to validate whether all the rows are in same format in the given file. If it is not I have captured that...

nawk -F "|" '{print FNR,NF-1}' infile

I tried this query. It's working fine. Thanks to everyone. Plz one more help

can you tell me how can I fetch 1st row with corresponding delimiter

I...

I would like to thanks for your response. I have tried all your options. But It was throwing erros. My requirement Is If I have 100 records in one file, then my output should be like this. The...

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...

Hi Rajesh,

Thanks for your reply. I want total count of the delimiter for my source file. The output I want to store in one file. Then I should move that file into my unix directory. I hope I...

Hi,
I am new to shell script. I want to count to Delimiter count for my source file. For that I have written script. When I tried to execute the script I could not able to view the results. It...