String manipulation for finding value

Help Activities
1

Input value “(* 767000)”

Output required value is 76700

How to write string manipulation

Any suggestion will be helpful for me

2

Hi @satish.rathi59

Try this

Input= “*(* 767000* )”
Output = Input.Replace("(* ", "").Replace(")", "")

image
image841×333 13.7 KB

or

Input= “*(* 767000* )”
Output=String.Join("",Input.Where(Function(c) Char.IsDigit(c)))

image
image812×324 37.7 KB

or

Input= “*(* 767000* )”
Output=New String(Input.Where(Function(c) Char.IsDigit(c)).ToArray)

image
image824×328 38.8 KB

Hope this helps!!

3

grafik

4

Hi @satish.rathi59

You can use regular expressions to extract the required output.

- Assign -> Input = "(* 767000)"
- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input.ToString,"(\d+)").Value

The Output contains the required output.

Check the below workflow for better understanding.

image
image945×549 56.5 KB

image

Hope it helps!!

5

Hello @satish.rathi59

  1. Assign Activity:

    • InputValue = “(* 767000)”

  2. Assign Activity:

    • CleanedValue = System.Text.RegularExpressions.Regex.Replace(InputValue, “[^0-9]”, “”)

  3. Assign Activity:

    • OutputValue = Int32.Parse(CleanedValue)

Thanks & Cheers!!!