Eliminate text from invoice number

Help Studio
, ,
1

Hello,

I need to remove the text from the invoice number- MAA4-1013406 and after removing i have to place the same in the invoice cell
![The image is a screenshot of an Excel spreadsheet displaying information including a billing address, GST registration number, place of supply, place of delivery, invoice number, invoice details, invoice date, and order number. (Captioned by AI)|690x42].
(upload://a4StnJeM9C5iZDndhkPv2z9OPUM.png)

How can i achieve this?

Please help

2

Hi, You missed to add the screenshot.
But you can apply a regex to get the Invoice #

-(\d+)$

The image shows a regular expression testing interface successfully matching the numeric part "1013406" from the test string "MAA4-1013406" using the regex pattern "-(+)$". (Captioned by AI)
The image shows a regular expression testing interface successfully matching the numeric part "1013406" from the test string "MAA4-1013406" using the regex pattern "-(+)$". (Captioned by AI)1321×238 23.1 KB

In order to remove it: text.replace(/-(\d+)$/, ‘’)

1 Like
3

Answer:
First (RegEx) Use a Assign Activity
InvoiceNumber = System.Text.RegularExpressions.Regex.Replace(OriginalInvoiceNumber, “[^0-9]”, “”)

  1. Explanation:
  • OriginalInvoiceNumber: Variable holding the value MAA4-1013406.
  • The regex pattern [^0-9] removes everything except digits.

OR

string Manipulation
assign
InvoiceNumber = OriginalInvoiceNumber.Split("-"c)(1)

This splits the string at - and retrieves the second part (1013406).

Then
Use a Write Cell activity in the Excel scope to write the InvoiceNumber back into the same cell

4

i tried using regex… now i want to replace the existing value to the new varaiable
Sequence.xaml (12.3 KB)

5

This is the excel
Data.xlsx (9.5 KB)

6

Directly Update the Variable:

invoiceNumber = newInvoiceNumber

7

I did the same and achieved

1 Like
8

your issue resolved?