QD | Quote Distribution Subsystem

You need to make copies of QF and QD - you're making aliases.

The problem is almost certainly due to aliasing.

When you initialize lattice with this line:

Picking this up two days later, it started working...nothing changed (in the code at least).

I summed height of all elements in the design. It was 308. Then, I think 310 will be an ideal number. No problem, when I make it 310. Everything seems good.

Incorrect first answer: TRANSFORM First(tblTeamdata.Teammemebername) AS FirstMembername SELECT tblTeamdata.DAT FROM tblTeamdata GROUP BY tblTeamdata.DAT PIVOT tblTeamdata.Teamname;

Since each cell in the cross tab can have multiple MemberCodes you will have to use a function to return a list of those names. The function shall have date and teamcode as parameters.

(XX\.[A-Za-z]*\("([^"]*)",\s*([0-9A-Za-z]{2})\),\s*[0-9A-Za-z)]+)

To capture multiple times

• run the regexp on the big string
• if no matches, break
• use the second and third capture groups as you like
• get the first capture group
• in the big string replace that capture group with an empty string
• do it again with the modified string

Old Answer

XX\.[A-Za-z]*\("(.*)",\s*([0-9A-Za-z]{2})\)

I included capture groups if your interested

I can explain it if you'd like

• XX\. The beginning is probably obvious. XX\.
  • it's important to note that . in regex matches anything, however I assume you specifically want to get a period. Thus we escape it like \.
• [A-Za-z]* next we are matching any amount of characters from capital A to capital Z and lower case a and lowercase z. I assume that it will always be 2 characters but I'll let it slide for now
• \( next we escape the open parenthesis because parenthesis represents a capture group
• " next we look for a quotation mark
• (.*)" next we capture anything intil we hit another quotation mark.
  • It's important to note that if the string has an escaped quotation mark, this regexp breaks. If you need an escaped quotation mark also I'll try to help you out
• , next we look for a comma
• \s* after that we look for any amount of spaces. Could be zero, could be a hundred
• (0-9A-Za-z){2} next we capture two characters that could be 0-9 A-Z and A-Z
• \) finally we end with a parenthesis

This question essentially boils down to the difference between calling

This is because the qibla variable has additional space and enter character at the beginning and the end. Just use trim() function to remove them.

More information: https://www.w3schools.com/jsref/jsref_trim_string.asp

In my experience, the Allocated using API '', verified using API 'o' error suggests that there is a reference counting mistake somewhere in your program.

It's easy to add or forget a Py_INCREF or Py_DECREF. Adding Py_DECREF(Py_True) or Py_DECREF(Py_False) by mistake

Therefore, start by reviewing all your usages of Py_True, Py_False, and also Py_None.

Python 3.11 will have a more indicative message for this kind of a problem, when you use the debug version of libpython.

Source: https://bugs.python.org/issue45061

We can use indexing with the str accessor to select the strings then use get_dummies to create a dataframe of indicator variables, finally update the original dataframe using the values from indicator dataframe