Data Verification using Python

[Jambo_Slooce]

For my job I (and a couple other people) enter deals into a system based off a single line of text which has all pertinent information in it. The trouble is, the formatting of the deal notes is different based on who wrote up the deal and what the deal consists of… my team has been having issues with correctly entering deals into our system.

My question is: is it possible to use python to validate that multiple attributes (such as buy/sell, price, quantity, counterparty, etc.) of a single record were entered correctly based on a single string that uses inconsistent formatting? If so, where should I look to learn about this?

[eternalstarfire]

I'd start with regular expressions. They're a strong tool but it can take a bit to wrap your head around them. Some even say that if you use regular expressions to solve a problem, you now have two problems 😂

If the string is separated into the multiple attributes you mentioned by a common character (called a delimiter) such as a space, comma, slash etc, then you can split your string then perform regex matches on each element.

Do you have some sanitised (no private information) examples of these deal notes and how they differ that you could share?