* Removed ending period from Fact Note

[BakerJL75]

Due to an import I would like to remove the last period in a fact note for every fact note. Only the last one. I'm still trying to get the hang of query's and LUA strings. Is there a way to do this in mass? FH7.

Thanks,
Jackie

[tatewise]

Yes, it can be done using Lua Pattern Mode in the Search and Replace plugin.
It cannot be done with a Query because they only ever read data and cannot change data.

On the Major Options tab ensure the Search Scope is All Records & Events/Attributes.

On the Extra Filters tab ensure that only Note & Description fields is ticked and choose Fact.Notes (~Fact.NOTE) from list.

Back on the Major Options tab set Search box to %.$ which matches a dot . anchored to the end of the Note $
The % escape symbol is needed because dot . has a 'magic' meaning in Lua Patterns but here we want its literal meaning.

Ensure the Replace box is empty and Lua Pattern Mode is selected.

However, I am fascinated why you need to remove those dots from the end of all Fact Notes?

[BakerJL75]

Thank you! Again.

Now that you ask, I need to investigate more.

My imported data all contains a period at the end of every note sentence. I made custom fact definitions that include the note field at the end.
I was ending up with 2 periods at the end of my sentences if there was a note.

Now that I'm typing this, it may be how I constructed my custom fact definitions. However, they are done, so I'll probably use search and replaces as you suggested and strip off the periods. I think that would be easier than fiddling with all my definitions again.

Jackie

[BakerJL75]

Worked great. As I expected. You write great instructions. Thanks!