How to check cell value begins with Letter

Help
, ,
1

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
R12345
if ShipmentCode begins with R , I need update ShipmentGroup As RM .
Need Suggestions.

@jeevith @NIVED_NAMBIAR ??

Thank You

2

@ShivuDundi,

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

Convert.ToString(row("ShipmentCode")).StartsWith("R")
3

Ya thanks a lot Got it :grinning:

1 Like
4

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