DSXchange

I mean there are more then 10 fields but some times may be only 5 or 6 fields may be present like nsert_job: template job_type: c box_name: box1 command: ls -l machine: localhost owner: lyota01@TANT-A01 permission: gx,ge,wx,we,mx,me date_conditions: 1 and i want to accomplish my o/p as insert_job jo...

In autosys we scheduled the jobs and jill file is job information language which consists of details of job scheduled below is sample jil file insert_job: template job_type: c box_name: box1 command: ls -l machine: localhost owner: lyota01@TANT-A01 permission: gx,ge,wx,we,mx,me date_conditions: 1 da...

Hi All, I have to parse jill file and load the data into table previously i have used one filter command tr -s '\n' ',' in sequential file and is working fine as i have only one format but now the structure of it is varying from job to job how can i make it generic so that it can be used for any str...

Thanks All i got to know that i missed to mention /usr/bin/tr -s '\n' ','
istead i placed just command tr -s '\n' ',' in filter command which is causing the above error.

this problem is not resolved can any one help on this iam getting the following error when i try to view data in the source sequential file, an i checked in the command prompt its working fine... load_job__test..Sequential_File_0.DSLink3: ds_seqopen() - Error in filter command "tr -s '\n' ','&q...

when i checked in the command prompt the command is working fine

Hi All, Iam getting the following error when i try to view the data. Load_job..Sequential_File_0.DSLink3: ds_seqopen() - Error in filter command "tr -s '\n' ','" - Load_job..Sequential_File_0.DSLink3: ds_seqopen() - Error in execv() - No such file or directory. any suggestions appreciated.

you may be right but iam idea was i want complete input to come in oneline saylike this Job type command machine nsert_job: template job_type:c command: ls -l machine: localhost now in transformer Field(inputcolumn,':',2) this will be iam derivation and i have implemented in 8.01 version but i dnt k...

yes anbu that what exactly i want then in transformaer i will use field function and pick the 2nd field

sorry for the confussion nitkaur newline is not , i dont know exactly what it is but what ever it may be iam converting that to , by using that command in filter

ya your right my input is jill file insert_job: template job_type:c command: ls -l machine: localhost owner: lyota01@TANT-A01 days_of_week: all description: "description field" std_err_file: /tmp/std_err this by filter commnad iam changing,nelinw as , with filter command in sequential file...

ya your right my input is jill file insert_job: template job_type:c command: ls -l machine: localhost owner: lyota01@TANT-A01 days_of_week: all description: "description field" std_err_file: /tmp/std_err this by filter commnad iam changing,nelinw as , with filter command in sequential file...

, is my record delimiter

Hi craig,

I have actually used the filter command in sequential file i used this command

tr -s "\n" ','

but it is saying error in command

Hi,

Can we use new line character as delimiter?

If yes, can anyone please suggest me how to use the \n as delimiter.

Thanks in advance