DSXchange

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

What kind of delimiter - field, record? Where?

A UNIX newline is a CHAR(10), by the way, depending on the 'where' you can use that function or perhaps the value '010' by itself.

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

What is your record delimiter?

, is my record delimiter

I guess you are looking for the usage of UNIX newline as record delimiter.

Can you show your input?

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
tr -s '\n' ','

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
tr -s '\n' ','

Just curious, why do you want to first convert newline to ',' character and then want to use ',' character as record delimiter.

Simply use UNIX newline as record delimiter without any substitution.

Simple tr command wont work for your case. Because tr converts entire input file into a single line where all fields and records are separated by comma.

Do you all 8 fields in all the records?

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

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

raji33 wrote:i dont know exactly what it is but what ever it may be iam converting that to , by using that command in filter

if you don't know exactly what it is, then how could you substitute it with another character.

Did you try using my other solution.

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 know y iam getting these errors in 7.5