Expression syntax to use LTRIM in Conditional Split Transformation

Question

Post reply

Expression syntax to use LTRIM in Conditional Split Transformation

notes4we

SSCommitted

Points: 1565
More actions
April 1, 2009 at 7:59 am

#202389

Can anyone please give me an example of an expression syntax to use LTRIM in Conditional Split Transformation?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

LTRIM([FirstName]) == ""

LTRIM([FirstName]) != ""

LTRIM([FirstName]) == "SomeValue"

--Ramesh

notes4we SSCommitted Points: 1565 More actions · Answer 2

Ramesh (4/1/2009)
LTRIM([FirstName]) == "" LTRIM([FirstName]) != ""
LTRIM([FirstName]) == "SomeValue"

My criteria matches to the first one that you have mentioned.

LTRIM([FirstName]) == ""

I want to get all the records in the destination which ignores the blank spaces

All your expression syntaxes have no errors, but still I am not getting what I want in the destination for some reason. The conditional split transformation is not passing any records for some reason.

I will look into the conditional split transformation to check what I am doing wrong.

Thank you for your reply.

notes4we SSCommitted Points: 1565 More actions · Answer 3

I figured out my mistake. I was putting a wrong logic and so I was not getting the desired output.

I will now work on it.

Once again, thank you for your reply.

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 4

You are welcome, and I'm glad that I could help you.

--Ramesh

Expression syntax to use LTRIM in Conditional Split Transformation

Cookies on SQLServerCentral