Answered

Replace Dates

(0) Share

Report

Posted on by Zohaib1999

132

Hi I have a Testlist, in this test are date values i want to replace the dates with nothing. (Remove the dates). So i used the Action to detect date entities to get all dates from the text. These Dates i want to replace.

It doesn't work with the following screenshot:

Categories:

Power Automate Desktop

I have the same question (0)

All responses (20)

Answers (1)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999
Could you please share the testlist screenshot with values pls?

Or Are you trying the replace the dates from below datatable?

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

The image shows the TextList* which i have with the dates.

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

exactly

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999
Here you go!! We have multiple ways to do that.
But below is PAD way of doing(Not scripts):
1. Create one more list variable as per your wish(In this example, I have created like Date_Replaced_Quelltext)
2. Iterate the previous list(Quelltext) using foreach
3. Replace date with empty string using regex
4. Insert the new value into newly created list
Result:
Code:
Variables.CreateNewList List=> QuellText
Variables.AddItemToList Item: $'''21 23.02.2024''' List: QuellText
Variables.AddItemToList Item: $'''00:00''' List: QuellText
Variables.AddItemToList Item: $'''am''' List: QuellText
Variables.AddItemToList Item: $'''bis''' List: QuellText
Variables.AddItemToList Item: $'''23.02.2024''' List: QuellText
Variables.AddItemToList Item: $'''Way 01.01.2024''' List: QuellText
Variables.CreateNewList List=> Date_Replaced_QuellText
LOOP FOREACH CurrentItem IN QuellText
Text.Replace Text: CurrentItem TextToFind: $'''\\b\\d{2}\\.\\d{2}\\.\\d{4}\\b''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Replaced
Variables.AddItemToList Item: Replaced List: Date_Replaced_QuellText
END

Thanks,
Deenu
-----------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as Accepted solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

is it posssible to say i want all the information from this list to get replaced?

Replace text action:
Here i searched for %columnAsList% which shows the results of the dates (screenshot above). How should i write the code %columnAsList% correctly?

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999 - Please follow the below screenshot
Text to find value(Regex): \b\d{2}\.\d{2}\.\d{4}\b

Thanks,
Deenu

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

The Goal which I had was to get all the dates first as a variable in form of %columnAsList%. These dates are in the %PDFText%. So i wanted to replace the dates from the PDFText with the %ColumnAsList% Results

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999 I'm quite confused. Could you please explain your full requirement with some screenshot?

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

First Step : Analyze the Dates from the -PDFText-

Second: Fill the Results in a TextList

Replace the Results with nothing or test

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999
In that case, there would be no need for a round trip approach to substitute the dates in the "Recognizedentities" datatable.

Instead of converting it into a list, utilize the "Find or Replace in DataTable" action directly, located within the "Variables --> DataTable" package, and incorporate your parameters as illustrated below.

Text to find value(Regex): \b\d{2}\.\d{2}\.\d{2}(?:\d{2})?\b

Result:

Thanks,
Deenu
-----------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as Accepted solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No