Tags » Delimiter

10 เครื่องหมายบนแป้น Keyboard ที่คุณอาจเรียกผิดมานานแล้ว!

มีเกมมาให้เล่นกันขำๆครับ..

อยากทราบว่า เครื่องหมายบนแป้นคีย์บอร์ดทั้ง 10 นี้ มีชื่อว่าอะไร?

1. ”
2. #
3. $
4. ^
5. &
6. *
7. [ ]
8. { }
9. = 200 more words

Microsoft Excel

What is the syntax to split an array based on a value?

Split(expression, delimiter, count, compare)
'expression is a string; only mandatory parameter
'count - how many substrings to be returned. -1 means all substrings are returned
'compare - 0 for binary, 1 for textual… 44 more words
VBA

Using Charindex + Cross Apply to split delimiter-separated values (SQL Server)

Let’s suppose that we have some delimiter-separated values, like this:

We want to separate the delimited values into five columns, like this:

We can solve this using the following code: 124 more words

SQL Server Transact-SQL

bash | parsing lines to array with quoted delimiters

OIFS=$IFS;IFS=$'\n';ARRAY=($(echo "$LINE" | awk '{ for (i = 0; ++i <= NF;) printf "%s\n", $i }' FPAT='([^,]+)|("[^"]+")'));IFS=$OIFS

Bytes

Java 8 StringJoiner demo

Finally Java has convenient and intuitive API for joining strings with delimiters! Since Java 8 there is StringJoiner class. It is an API that you may know from Guava Joiner classes (see my post: … 231 more words

IT