Split a number after the 9th digit

[nina.wenner]

Hi,

I have an invoice number as a string variable. I want to output only the first 9 digits from the number.

Example:
620239035001 → The result should be 620239035!

Can you give me a tip here?

Thank you and best regards
Nina

[Srini84 (Srinivas Kadamati)]

@nina.wenner

620239035001

@nina.wenner

Check as below for your reference

Hope this may help you

Thanks

[pravin_calvin (pravin kumar)]

Hi @nina.wenner

You Can also try with the Regex Pattern \d{9}

System.Text.RegularExpressions.Regex.Match(YourInputString," \d{9}").Value

Regards

[ppr (Peter Preuss)]

the regex way:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[Boopathi.M]

Hi @nina.wenner

We can also use =left(yourstringvar,9)

Thanks,

[nina.wenner]

Thanks for your help, it’s working.