# Extract specif data from variable

**URL:** <https://forum.uipath.com/t/extract-specif-data-from-variable/391761>\
**Category:** Academy Feedback\
**Tags:** lp-developer-adv, studio\
**Created:** [January 17, 2022, 5:24pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761 "2022-01-17T17:24:51Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![salvatore.quimi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/salvatore.quimi/32/263311_2.png) [@salvatore.quimi](https://forum.uipath.com/u/salvatore.quimi)\
**Post date:** [January 17, 2022, 5:24pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/1 "2022-01-17T17:24:51Z")

</div>

Hi All,

I have a variable type String as screen below:

 ![image](https://global.discourse-cdn.com/uipath/original/4X/4/9/0/490b71a84723d6b4b4a4ea5d84c8526dcd3bc919.png)

I would extract the value to “Date”.

I try with this method:

clientDetails.Substring(clientDetails.IndexOf("Date ") + "Date: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Any suggestion?

Thank you!!!  
Regards

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 17, 2022, 5:31pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/2 "2022-01-17T17:31:00Z")

</div>

Hi @salvatore.quimi  
We can achieve this using regex

Thanks,  
Robin S

---

<div class="post-metadata">

**Author:** ![AdityaVN](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/adityavn/32/219762_2.png) [@AdityaVN](https://forum.uipath.com/u/AdityaVN)\
**Post date:** [January 17, 2022, 5:39pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/3 "2022-01-17T17:39:24Z")

</div>

if you are holding that string in a variable lets say - Text

use a array var lets say `SubString`

assign `SubString = Text.Split(":"c)`

this will give date `SubString(4).ToString`

hope this is helpful

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 17, 2022, 5:47pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/5 "2022-01-17T17:47:31Z")

</div>

Hi @salvatore.quimi

create one string variable for date Ex:Out\_Str

Put the below syntax in assign activity

**Out\_Str=System.Text.RegularExpressions.Regex.Match(Your\_Input\_String,“((?\<=Date:)[\d-]+)”).Value**

 ![image](https://global.discourse-cdn.com/uipath/original/4X/2/d/1/2d1ef7d843ba21c86280b81265bbe1ba27edd7fa.png)

Date will be stored in Out\_Str variable

Hope It solves your issue

Thanks  
Robin

---

<div class="post-metadata">

**Author:** ![salvatore.quimi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/salvatore.quimi/32/263311_2.png) [@salvatore.quimi](https://forum.uipath.com/u/salvatore.quimi)\
**Post date:** [January 17, 2022, 6:06pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/6 "2022-01-17T18:06:39Z")

</div>

Hi @Robinnavinraj_S ,

Your method is fine but for Acme exercises I can give this information:

 ![image](https://global.discourse-cdn.com/uipath/original/4X/5/c/0/5c0d2cbbf5763bb79ec4964faa2bef8f0204e1de.png)

For the TAXID → I used this method and it worked:  
outputVar = clientInformation.Substring(clientInformation.IndexOf("TaxID ") + "TaxID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

I tried the same method to catch the value of date but not work  
Could you support?

Thank you

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 17, 2022, 6:11pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/7 "2022-01-17T18:11:13Z")

</div>

Hi @salvatore.quimi  
If you want split method

You can also put it like this

**OutStr=YourInputString.Split(":"c).Last**

Hope it solves your issue

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 17, 2022, 6:39pm UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/8 "2022-01-17T18:39:43Z")

</div>

Hi @salvatore.quimi

Is your issue resolved ah ??

---

<div class="post-metadata">

**Author:** ![salvatore.quimi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/salvatore.quimi/32/263311_2.png) [@salvatore.quimi](https://forum.uipath.com/u/salvatore.quimi)\
**Post date:** [January 18, 2022, 9:11am UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/9 "2022-01-18T09:11:15Z")

</div>

hi @Robinnavinraj_S

finally I solved with this method:  
clientDetails.Substring(clientDetails.IndexOf("Date ") + "Date: ".Length).Split(Environment.NewLine.ToCharArray)(3)

Thank you for your support!

Regards

---

<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:** [January 21, 2022, 9:11am UTC](https://forum.uipath.com/t/extract-specif-data-from-variable/391761/10 "2022-01-21T09:11:33Z")

</div>

Closed on January 21, 2022, 9:11am UTC

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