# Regex needed 21

**URL:** <https://forum.uipath.com/t/regex-needed-21/571858>\
**Category:** Robot\
**Tags:** question, robot, studio\
**Created:** [August 10, 2023, 11:16am UTC](https://forum.uipath.com/t/regex-needed-21/571858 "2023-08-10T11:16:07Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kuldeep\_Pandey](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kuldeep_pandey/32/269564_2.png) [@Kuldeep\_Pandey](https://forum.uipath.com/u/Kuldeep_Pandey)\
**Post date:** [August 10, 2023, 11:16am UTC](https://forum.uipath.com/t/regex-needed-21/571858/1 "2023-08-10T11:16:08Z")

</div>

Hi Team  
I want some help in regex My input is  
INV REF POST DATE DESC INV DATE GROSS AMOUNT TDS Amount  
(INR)

**47094629** 16/06/2023 AS PARTS 10/06/2023 2065.81 **-2.00**  **2063.81**  
PURCHASE

47868528 14/06/2023 AS PARTS 10/06/2023 3626.35 -3.00 3623.35  
PURCHASE

47264525 14/06/2023 AS PARTS 10/06/2023 308383.39 -262.00 308121.3  
PURCHASE 9  
I want output from all three 1 element 47094629 2.00 2063.81 I have mentioned all three in a bold

---

<div class="post-metadata">

**Author:** ![B\_H\_Akshatha\_Pai](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/b_h_akshatha_pai/32/496897_2.png) [@B\_H\_Akshatha\_Pai](https://forum.uipath.com/u/B_H_Akshatha_Pai)\
**Post date:** [August 10, 2023, 11:18am UTC](https://forum.uipath.com/t/regex-needed-21/571858/2 "2023-08-10T11:18:21Z")

</div>

@Kuldeep_Pandey  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/e/8/3/e83b3893b8c8d85c4753b1334a25f80e614c2110.png)  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/2/2/b/22bba6bc579b692a73e73fb20ee110ebcffa6b4f.png)  
There are only two things in bold here which is the third one ?  
Regards,

---

<div class="post-metadata">

**Author:** ![mkankatala](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mkankatala/32/484097_2.png) [@mkankatala](https://forum.uipath.com/u/mkankatala)\
**Post date:** [August 10, 2023, 11:21am UTC](https://forum.uipath.com/t/regex-needed-21/571858/3 "2023-08-10T11:21:46Z")

</div>

Hi @Kuldeep_Pandey

You can use the below regular expressions

 ![image](https://global.discourse-cdn.com/uipath/original/4X/b/f/1/bf1256dc22851f79ed6a57116098c67c6c69a858.png)

Hope it helps!!

---

<div class="post-metadata">

**Author:** ![Kuldeep\_Pandey](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kuldeep_pandey/32/269564_2.png) [@Kuldeep\_Pandey](https://forum.uipath.com/u/Kuldeep_Pandey)\
**Post date:** [August 10, 2023, 11:22am UTC](https://forum.uipath.com/t/regex-needed-21/571858/4 "2023-08-10T11:22:08Z")

</div>

Thanks I will do 3 one by my own

---

<div class="post-metadata">

**Author:** ![B\_H\_Akshatha\_Pai](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/b_h_akshatha_pai/32/496897_2.png) [@B\_H\_Akshatha\_Pai](https://forum.uipath.com/u/B_H_Akshatha_Pai)\
**Post date:** [August 10, 2023, 11:22am UTC](https://forum.uipath.com/t/regex-needed-21/571858/5 "2023-08-10T11:22:57Z")

</div>

> [@Kuldeep\_Pandey](#):
>
> 4525 14/06/2023 AS PARTS 10/06/2023 308383.39 -262.00 308121.3  
> PURCHASE

If my solution has helped you kindly mark as solution and close the thread 😇

Regards

---

<div class="post-metadata">

**Author:** ![indra](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/indra/32/34761_2.png) [@indra](https://forum.uipath.com/u/indra)\
**Post date:** [August 10, 2023, 11:23am UTC](https://forum.uipath.com/t/regex-needed-21/571858/6 "2023-08-10T11:23:10Z")

</div>

@Kuldeep_Pandey

Use this [regex](https://regex101.com/r/KcQ7qJ/1) for **47094629**  
Use this [regex](https://regex101.com/r/koOXIi/1) for \*\* **-2.00**  **2063.81** \*\*

---

<div class="post-metadata">

**Author:** ![rlgandu](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/rlgandu/32/488436_2.png) [@rlgandu](https://forum.uipath.com/u/rlgandu)\
**Post date:** [August 10, 2023, 11:23am UTC](https://forum.uipath.com/t/regex-needed-21/571858/7 "2023-08-10T11:23:50Z")

</div>

@Kuldeep_Pandey

 ![image](https://global.discourse-cdn.com/uipath/original/4X/3/e/8/3e821401a100ea62a14307e635adcbaa0273086b.png)  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/7/7/6/7763dd5944a475c27997d62a95e87b4a214f1328.png)  
Str\_outPut=System.Text.RegularExpressions.Regex.Match(Input,“Expression”).Value

---

<div class="post-metadata">

**Author:** ![Kuldeep\_Pandey](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kuldeep_pandey/32/269564_2.png) [@Kuldeep\_Pandey](https://forum.uipath.com/u/Kuldeep_Pandey)\
**Post date:** [August 10, 2023, 11:23am UTC](https://forum.uipath.com/t/regex-needed-21/571858/8 "2023-08-10T11:23:53Z")

</div>

In first one i have others no also which have 8 digits its also highlighting is there any other query

---

<div class="post-metadata">

**Author:** ![B\_H\_Akshatha\_Pai](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/b_h_akshatha_pai/32/496897_2.png) [@B\_H\_Akshatha\_Pai](https://forum.uipath.com/u/B_H_Akshatha_Pai)\
**Post date:** [August 10, 2023, 11:40am UTC](https://forum.uipath.com/t/regex-needed-21/571858/9 "2023-08-10T11:40:24Z")

</div>

^\d+ try this

![image](https://global.discourse-cdn.com/uipath/original/4X/3/1/3/3138e2d7ddfb44e47b306818ed5a4a0c4d7d47c1.png)

Regards,

---

<div class="post-metadata">

**Author:** ![Kuldeep\_Pandey](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kuldeep_pandey/32/269564_2.png) [@Kuldeep\_Pandey](https://forum.uipath.com/u/Kuldeep_Pandey)\
**Post date:** [August 10, 2023, 11:48am UTC](https://forum.uipath.com/t/regex-needed-21/571858/10 "2023-08-10T11:48:58Z")

</div>

^\d{8}  
This one is good for extracting  
In 2 we have many - sign can Space is common in every extraction please add space

---

<div class="post-metadata">

**Author:** ![B\_H\_Akshatha\_Pai](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/b_h_akshatha_pai/32/496897_2.png) [@B\_H\_Akshatha\_Pai](https://forum.uipath.com/u/B_H_Akshatha_Pai)\
**Post date:** [August 10, 2023, 11:53am UTC](https://forum.uipath.com/t/regex-needed-21/571858/11 "2023-08-10T11:53:46Z")

</div>

is second one not working for you?

---

<div class="post-metadata">

**Author:** ![mkankatala](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mkankatala/32/484097_2.png) [@mkankatala](https://forum.uipath.com/u/mkankatala)\
**Post date:** [August 10, 2023, 11:53am UTC](https://forum.uipath.com/t/regex-needed-21/571858/12 "2023-08-10T11:53:56Z")

</div>

Here is the output with the regex expression

Find the below regex expression

```auto
^(\d+)|(?<=\d+\/\d+\/\d+\s+\d+\.\d+\s+).*

```

Check the regular expression extraction

 ![image](https://global.discourse-cdn.com/uipath/original/4X/8/e/f/8efc89a65820fa5dcc35c0777297b70c5a3835e7.png)

Check the below workflow I got the output

 ![image](https://global.discourse-cdn.com/uipath/original/4X/7/0/0/7007c8017cc35c7e8bc46ab6cb88a538f0c07c95.png)

Hope it helps!! @Kuldeep_Pandey

---

<div class="post-metadata">

**Author:** ![tazunnisa.badavide](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/tazunnisa.badavide/32/419354_2.png) [@tazunnisa.badavide](https://forum.uipath.com/u/tazunnisa.badavide)\
**Post date:** [August 10, 2023, 12:03pm UTC](https://forum.uipath.com/t/regex-needed-21/571858/13 "2023-08-10T12:03:13Z")

</div>

Hey!  
Can u try with this

 ![image](https://global.discourse-cdn.com/uipath/original/4X/4/2/6/4261a84f67a8f26665618560d21fe6c479959d8f.png)  
Hope it helps

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [August 13, 2023, 12:03pm UTC](https://forum.uipath.com/t/regex-needed-21/571858/14 "2023-08-13T12:03:18Z")

</div>

Closed on August 13, 2023, 12:03pm UTC

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