Hello, I have an excel document to which I must copy the date that has combined with another text, extract the date that comes in Spanish format: "CORREDORES PERSONA NATURAL MOROSOS AL 20 DE JUNIO DE 2019 I only need the date without the “DE” between each word “DE” that is to say that it looks li…

@jonathanp90 once you get the date as string give like this buddy in assign activity DateTime.ParseExact(strdate.ToString,“ddMMMMyyyy”,system.Globalization.CultureInfo.InvariantCulture) you will get the output as you required.

Finding a date in string (text spanish date)

Help

pattyricarte (Patty Boy) June 25, 2019, 2:32am 2

Hi @jonathanp90
Is this format always the same or dynamically generated if it is statically you can use string manipulation for that See link below for your reference.
String Manipulation

2 Likes

Topic		Replies	Views
RePost for identifying date in the string Help studio	10	1458	March 5, 2019
Excel Regex Extract Date Activities datatable , excel , selector , uiautomation , data_scraping , question	7	1854	May 8, 2021
Regex Date Help studio , question	11	2739	December 3, 2020
How to extract date from text Studio studio , question , activities_panel	1	614	July 21, 2022
How to extract "dd-MMMM-yyyy" date from string StudioX studiox , question	6	1324	February 1, 2022

Most Active Users - Yesterday
Anil_G
Ajay_Mishra
pravallikapaluri
postwick
AJ_Ask
Anonymouss
vignesh.maruthappan
mkankatala
mrohan.senapaty
ATHEEQ_UR-RAHMAN
More details...

Finding a date in string (text spanish date)

Related Topics