How to the number with delimeter

Help Automation Ops
,
1

How to the number with delimeter with -.
There is a number with 2 delimiter but should pick the number before first delimiter

2

Hi @anjani_priya

If your input is 111:145:8900

Then use the below expression,

- Assign -> Output = Input.Split(":").First.toString

The above expression will extract the data before the first delimiter

Hope it helps!!

3

how to change change the whole column with modern activities

4

Okay @anjani_priya

ā†’ You can use the for each excel row activity to iterate the each row in the excel.
ā†’ Inside for each excel row activity insert the Assign activity and give the below expression,

- Assign -> CurrentRow("ColumnA") = CurrentRow("ColumnA").ToString.Split(":").First

Note: Change the column name in the expression as per your requirement.

Hope it helps!!

5

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