Hi, I have a flat file, in that the data starts with quotation mark ' " ' something like "H. I have to remove that row from file before loading to another file. for that I'm using the ConditionalSplit and put a condition like Row = ""H" which is not working. Can anyone let me know how to write the condition for this.

That kind of condition won't work - you need to "escape" the quotation mark. If your column name is called "Row", then this condition ought to be closer to working: Row == "\"H" If that does not work, please describe how it's not working. Does the conditional split editor show an error? Does the conditional split allow you to save the expression, but when the package is run, reports an error? Specific information is essential. Talk to me now on

How to remove the Quotation marks? I doo have the footer...how do I remove that..?? and the file is comma delimited and each record starts with quotation marks, so How do I remove those?

To remove the footer you can use conditional split component. In conditional split write an expresison to check the presence of quotation mark as: SUBSTRING(FirstColName,1,1) == "\"". Take the filtered output from conditional split to a derived column to create new column with the expression as: REPLACE(FirstColName,"\"","") Nitesh Rai- Please mark the post as answered if it answers your question

Hi Nitesh, Actually in the File the last row starts like "T, I have to remove that row when loading that file into another File. And as well, every records data starts like "ABCD","1234",".."......So I have to remove " Can you let me know.

Check using a conditional split for any row starting with "T (or any pattern) and filter it using a conditional split. You have to edit my previous conditional split expression. Nitesh Rai- Please mark the post as answered if it answers your question

In the Conditional Split I'm writting the expression as [Column 0] = ""T", but this is not working...can you give me the correct expreesion plz...

In the Conditional Split I'm writting the expression as [Column 0] = ""T", but this is not working...can you give me the correct expreesion plz...

In the Conditional Split I'm writting the expression as [Column 0] = ""T", but this is not working...can you give me the correct expreesion plz... Already gave you the expression in previous post.SUBSTRING([Column 0],1,1) == "\"T"Nitesh Rai- Please mark the post as answered if it answers your question

In the Conditional Split I'm writting the expression as [Column 0] = ""T", but this is not working...can you give me the correct expreesion plz... Already gave you the expression in previous post.SUBSTRING([Column 0],1,1) == "\"T"Nitesh Rai- Please mark the post as answered if it answers your question

nope dude...even putting this condition also I getting getting that record in the destication file. And even I have tried like SUBSTRING([Column 0 ],2,5) == "TCFD"

Hi kalyan, This works for me Substring(column1,1,2)=="\"H" Regards, Eshwar.