Regular expression to get Boolean values

I need help with a regular expression. I need last 3 Boolean values.

The combination of these 3 Boolean values could be anything:
True True True
False True False
True False True
This is the workflow I made:
TestRegularExpression.xaml (5.1 KB)

This is the sample text file.
APRFees.txt (793 Bytes)

I think you have shared wrong text file because i coudnt see the mentioned Boolean values in the text file

This is the Text: HU# Encompass Fee n Compliance Fee Description Amount Paid By Paio Encompass R Compliance R HOEPA/QM
901 Prepaid Interest Prepaid Interest 414.33 Borror L False False False

Hi @chauhan.rachita30

Try out this regex

(?<=Borror L )[\w\s]+

Update me whether you got a solution or not

thanks,

1 Like

Cannot rely on this Text, it can be anything because I am reading the text using screen scraping and its un-reliable.

ok

Can you try this expression

((True)+|(False)+)

Thanks,

1 Like

Thank you!!! It worked…Thanks a lot.

Your welcome

Can you help with one more regex: I need the first number occurrence from this text: that is “901”.

Is there any static text arround 901

No…But there would be only 2 numbers in the whole string. and I just need the first one.

Can you try this expression
(\s\d+\s)

1 Like

It wont grab the second number. Right?

Yes try out this and tell me

1 Like

working. Thanks

Scroll to the right

Is this a tab delimited file? Looks like it might be. I’d try reading it in as a delimited file. If it works and you then have it in a datatable, the rest is easy.

Read the file, split on VbCrLf, then loop through those, skipping the first row (headers) and split each row on \s with RegEx.

Output:
image

So you can just reference the last 3 elements in the array to get your three booleans (as strings to convert).

image

If its works fine could you mark it as solution so that it will will be helfull to others also

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