How to split numbers

Good day

So i have this flow and now i need to split 199988877777 number into 2 groups- first group should be the first 6 digits of clientID and today s date…please assist…thank you in advance

@pabaleloh,

To split a string in substring, you can use Substring like this

strOutput = ExtrenalRef.ToString.Substring(0, 6)

And to add todays date you can use below code. You can change the date format as per your need

Now.ToString("MMddyyyy")

2 Likes

use following steps

  1. Assign input to a variable
  2. Assign Leftvalue using expression = Left( InputString,6)
  3. Get righ value using expression = Split(InputString, LeftVale)(1).ToString
  4. Append date with group 1 left = LeftVale & “|” & DateTime.Now.ToString(“dd-MMM-yyyy”)

@sharazkm32 thank you

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