xCASx

Find: ref=\"tns:(.*)\"
Replace: name=\"\1\" type=\"tns:\1\"

xCASx

-- export to csv
Copy (Select * From tablename) To 'C:\\dev\01.csv' With CSV;

-- import from csv
COPY tablename FROM 'C:\data\01.csv' DELIMITER ',' CSV HEADER;

-- Create a Range From 1 to 10
SELECT * FROM GENERATE_SERIES(1, 10)

xCASx

// Next formula makes 12 copies in C for each row in A in a determined order

=ИНДЕКС(A:A;ОКРВВЕРХ(ЧСТРОК(C$1:C1)/12;1))

xCASx

'''
This programm gets url list from text file and request the pages, finds favicons and save them into current directory
'''
import urllib
from urllib.request import urlopen
from urllib.request import urlretrieve
from bs4 import BeautifulSoup

'''had to add this windows specific block to handle this bug in urllib2:
http://bugs.python.org/issue11220

xCASx

/**
 * Convert a Collection to the array of {@link Class<T[]>} type
 * @param type          class of outgoing array
 * @param collection    collection which should be converted
 * @param <T>           base type for outgoing array
 * @return              outgoing array {@link Class<T[]>}
 */
private static <T> T[] convertCollectionToArray(Class<T[]> type, Collection collection) {
  T[] t = type.cast(Array.newInstance(type.getComponentType(), collection.size()));
  return (T[]) collection.toArray(t);