Remove Text From string1

Help Robot
,
1

Hey i have a string in datatable
000050996-001/1
I want to remove 001/ and want output as 000050996-1

2

Hi @Kuldeep_Pandey

Try this:

Assign activity:
Dim inputString As String = "000050996-001/1"
Dim outputString As String = System.Text.RegularExpressions.Regex.Replace(inputString, "[\d]+\/", "")

Log Message activity:
Output: "Output string: " + outputString

image
image923×662 55.4 KB

Hope it helps!!

3

Hi @Parvathy ,
you can use regex,
or get string remove substring if all item same format
regards,
LNV

4

Thanks , We can also do this from replace string

5

@Kuldeep_Pandey

I have used replace function only with regex expressions.

Regards,

1 Like
6

Hi @Kuldeep_Pandey

row(“Column1”) = row(“Column1”).ToString.Replace(“001/”, “”)

image
image795×319 15.4 KB

1 Like
7

If all row same format you can use
row(“ColumnName”) = row(“ColumnName”).ToString.Replace(“001/”, “”)

1 Like
8

string.replace(“001/”,“”)

1 Like
9

you can try with regex also ! @Kuldeep_Pandey

image

10

Hi @Kuldeep_Pandey

  1. Drag and drop a For Each Row activity onto your workflow.
  2. Configure the For Each Row activity to iterate through your DataTable (myDataTable).
  3. Inside the For Each Row activity, add an Assign activity.
  4. In the Assign activity, set the left-hand side to row("ColumnName").
  5. Set the right-hand side to row("ColumnName").ToString.Replace("001/", "").

row("ColumnName") = row("ColumnName").ToString.Replace("001/", "")

Hope it helps!!

1 Like
11

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