How to check cell value begins with Letter

Hello People,

I have Scenario where in i need to check Cell Value Corresponding to that i need to update data.
For Example.

Column - ShipmentCode ShipmentGroup
if ShipmentCode begins with R , I need update ShipmentGroup As RM .
Need Suggestions.

@jeevith @NIVED_NAMBIAR ??

Thank You


You can use the .Net built-in function startswith, You have to use it in a IF activity. This startswith will return a boolean value, so if it is true then you can update the required column with “RM” as you have mentioned.

StartsWith (value As Char) 

Try like the following


Ya thanks a lot Got it :grinning:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.