This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
**You are a friendly and helpful assistant.** | |
* Ensure your answers are complete unless the user requests a more concise approach. | |
* When generating code, offer explanations for code segments as necessary and maintain good coding practices. | |
* When presented with inquiries seeking information, provide answers that reflect a deep understanding of the field, guaranteeing their correctness. | |
* For any non-english queries, respond in the same language as the prompt unless otherwise specified by the user. | |
* For prompts involving reasoning, provide a clear explanation of each step in the reasoning process before presenting the final answer. | |
**Additionally, you are to:** |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sample for reference only | |
Copyright © 2001 Hong Kong Institute of Human Resource Management. All rights reserved. | |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM yannart/jboss-5.1.0.ga-jdk6 | |
# Download the agent and configure the controller-info.xml BEFORE building the image | |
COPY AppServerAgent /opt/appdynamics | |
ENV JAVA_TOOL_OPTIONS=-javaagent:/opt/appdynamics/javaagent.jar |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM yannart/jboss-5.1.0.ga-jdk6 | |
# Download the agent and configure the controller-info.xml BEFORE building the image | |
COPY AppServerAgent /opt/appdynamics | |
# INSTRUCTION REFERENCE: https://stackoverflow.com/questions/33364100/how-to-use-tls-1-2-in-java-6 | |
# Update Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files 6 | |
RUN wget --continue --no-check-certificate --header "Cookie: oraclelicense=a" "https://download.oracle.com/otn-pub/java/jce_policy/6/jce_policy-6.zip" && \ | |
unzip jce_policy-6.zip && \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub Unpivot() | |
' | |
' Macro1 Macro | |
' | |
Columns("A:A").Select | |
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove | |
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove | |
Range("C5").Select | |
Selection.Copy | |
Columns("D:D").Select |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub CleanWikiCovid() | |
Selection.Hyperlinks.Delete | |
Selection.UnMerge | |
Range("A1").Select | |
Cells.Find(What:="date", After:=ActiveCell, LookIn:=xlFormulas2, LookAt _ | |
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ | |
False, SearchFormat:=False).Activate | |
While Selection.Column > 1 | |
Selection.EntireColumn.Delete |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import json | |
def get_layers(data): | |
return data[1][6] | |
def get_items(data): | |
return data[12][0][13][0] | |
def parse_item(item): | |
output = {"latitude": item[1][0][0][0], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub Macro3() | |
' | |
' Macro3 Macro | |
' | |
newSheetName = "MergedSheet" | |
On Error Resume Next | |
Sheets(newSheetName).Select | |
If ActiveSheet.Name <> newSheetName Then |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
' | |
' A VBA macro to convert numbers to words for check/cheque printing | |
' | |
' Credit to Rick Rothstein (https://answers.microsoft.com/en-us/profile/1479b918-5537-45b1-a709-6c4bae9d7da4) | |
' Original reference: https://answers.microsoft.com/en-us/office/forum/office_2003-excel/convert-numers-to-words-for-checkcheque-printing/5a88ab46-4211-464f-8358-d196408f3ea5 | |
' | |
' A1: 123.45 | |
' In B1: | |
' =NumberAsText(A1) ==> One Hundred Twenty Three Point Four Five | |
' =NumberAsText(A1,"And") ==> One Hundred and Twenty Three Point Four Five |
NewerOlder