Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

replace special characters

When we are reading the files from the origin if the header value contains with spaces we get with quotes like below format. In the current input i got space is the delimiter but we are not sure in future we might get many. What all the stages are required to achieve the final output. Pls suggest

List Map output from Streamsets :
no:1
'e name':aaa
addr:bbb

For example my input file looks like in different patterns

Pattern 1 :  
no,e name,addr 
1,aaa,bbb
2,ccc,ddd

How do we achieve with below output for the Pattern 1

no,e_name,addr
1,aaa,bbb
2,ccc,ddd


Pattern 2 :  
"no","e name","addr" 
"1","aaa","bbb"
"2","ccc","ddd"

How do we achieve with below output for the Pattern 2

no,e_name,addr
1,aaa,bbb
2,ccc,ddd

replace special characters

When we are reading the files from the origin if the header value contains with spaces we get with quotes like below format. In the current input i got space is the delimiter but we are not sure in future we might get many. What all the stages are required to achieve the final output. Pls suggest

List Map output from Streamsets :
no:1
'e name':aaa
addr:bbb

For example my input file looks like in different patterns

Pattern 1 :

no,e name,addr 
1,aaa,bbb
2,ccc,ddd

How do we achieve with below output for the

Pattern 1

no,e_name,addr
1,aaa,bbb
2,ccc,ddd

Pattern 2 :

"no","e name","addr" 
"1","aaa","bbb"
"2","ccc","ddd"

How do we achieve with below output for the

Pattern 2

no,e_name,addr
1,aaa,bbb
2,ccc,ddd