REPLACING COMMA(,) IN INPUT FILE WITH A STRING

JayaprakashT · New User Joined: 05 Oct 2007 Posts: 3 Location: Hyderabad

Input file contains a query which looks like SELECT EMPID, EMPNAME, DEPNO FROM TABLE A WHERE EMPID = 100;

Output file should be a re-formatted query like SELECT CAST(EMPID AS VARCHAR(200)),',', CAST(EMPNAME AS VARCHAR(200),',', CAST(DEPNO AS VARCHAR(200) FROM TABLE A WHERE EMPID = 100;

Note: No of columns might vary based on the query.

Escapa · Posted: Thu Apr 07, 2011 5:24 pm

Please help me understand your problem..

You have query written in input file, you want to replace all , with ,',', ?

Is that correct?

JayaprakashT · New User Joined: 05 Oct 2007 Posts: 3 Location: Hyderabad

Dear Escapa,

Yes, I have a query written in input file. I need to format each column of input file like
input file-Column Output file-column
EMPID CAST(EMPID AS VARCHAR(200)),',',

Bill Woodger · Posted: Thu Apr 07, 2011 6:05 pm

So, seperate into words between SELECT and FROM, then "wrap" your words up with what you want. Stick it all back together. Many particular ways to do this. See what you think.