Menu
  • HOME
  • TAGS

ODI Sql Spool with GetOption of Query Separator

oracle11g,separator,data-integration,oracle-data-integrator

try this: select <%=odiRef.getColList("", "[EXPRESSION]", **"||'" + odiRef.getUserExit("option_name") + "'||"**, "", "")%> from <%=snpRef.getFrom()%> ...

How to handle file with different line separator in java?

java,line,separator

Then the data I want to analyze is separated with "@". My idea is to change the default end of line character used by Java ans set "@". I wouldn't do that as it might break God knows what else that is depending on line.separator. As for why this...

How can I read two variables from a txt file that are on the same line? in python

python,file,var,readline,separator

with open('basic.txt') as f: for line in f: username, password, filename = line.split(':') print(username, password, filename) ...

JavaScript / Regex: Best way to remove thousand separators from string amount

javascript,regex,replace,separator

This one may suit your needs: ,(?=[\d,]*\.\d{2}\b) Debuggex Demo...

default field separator for awk

linux,unix,awk,posix,separator

Here's a pragmatic summary that applies to all major Awk implementations: GNU Awk (gawk) - the default awk in some Linux distros Mawk (mawk) - the default awk in some Linux distros (e.g., Ubuntu) BSD Awk - a.k.a. BWK Awk - the default awk on BSD-like platforms, including OSX On...

Replace column separation of # with comma or tab

python,tabs,comma,separator

When reading, you can use csv.reader() which takes a delimiter parameter like this: >>> with open(your_file, "r") as f: ... data = [x for x in csv.reader(f, delimiter='#')] ... >>> And when you're writing, csv.writer() accepts the same parameter.. >>> with open("foo.txt", "w") as f: ... w = csv.writer(f, delimiter=',')...

Awkward: Combine two awk statements

awk,separator

You could sed the field separator to a regex: awk -F' |:' '{print $2}' file 123 2983 8 ...

Why does Python's str.partition return the separator?

python,separator,partition,rationale

Per the documentation, str.partition and the associated str.rpartition were: New in version 2.5. Looking at the what's new for that version provides some rationale for these methods, which "simplify a common use case": The find(S)() method is often used to get an index which is then used to slice the...

Separate text to variables in R

r,csv,separator,strsplit

You can use read.table, but you should use count.fields or some kind of regex to figure out the correct number of columns first. Using Robert's "text" sample data: Cols <- max(sapply(gregexpr("+", text, fixed = TRUE), length))+1 ## Cols <- max(count.fields(textConnection(text), sep = "+")) read.table(text = text, comment.char="", header = FALSE,...

Digit Separator in Julia

python,c++,integer,julia-lang,separator

The standards proposal document for C++14 has a very lengthy discussion on the rationale and possible choices for a digit separator. The considered `, ', _, ::, and (space). Some of the discussion cites other languages. According to the document, _ is also used in Ada, VHDL, Verilog, and possibly...

Increment server number in double loop with separator every 5 servers

python,loops,increment,separator

I'd suggest using the modulo operator, here's a small demo: numservers = 15 # put anything you want here for i in range(1,numservers+1): print('server{}'.format(i)) if i%5 == 0: print('*'*22) ...

What is this field separator (^M)?

perl,separator

^M is ASCII character 13, known as a carriage return. MS-DOS uses a carriage return followed by a line feed (ASCII 10) to mark the end of a line. Unix systems use a line feed only. Usually you will "see" a carriage return when using an editor that thinks your...

Round number in java and add separator

java,rounding,separator

If you overwrite the standard format with #.00 you have no grouping seperator in your format. For your expected case you have to include the grouping seperator again into your custom format: DecimalFormat theFormatter = new DecimalFormat("#,###.00", theSymbols); The pattern definition symbols can be found in the Doc...

How to add comma separator after each string getting printed through foreach loops in smarty?

string,foreach,smarty,separator,smarty2

Another way to look at the problem is that a comma should be printed before every string except the 1st one, so create a variable called "comma" and initialize it to the empty string and set it to "," after the first string is printed. Not tested but you get...

Completely remove separators using slugify

php,slug,separator,slugify

This is possible changing the default separator to an empty string, so this: echo $slugify->slugify('A strange.example_user-name', ''); Will return this: astrangeexampleusername ...

How to write data line by line from the two files into a common file in java

java,filewriter,separator

You are close to solution but making simple mistake. i.e. you are reading by firstFile.next() which gives you word by word instead of line by line, As you are interested in line by line So use nextLine() Like: while (firstFile.hasNext()) { firstFileList.add(firstFile.nextLine().trim()); } while (secondFile.hasNext()) { secondFileList.add(secondFile.nextLine().trim()); } try {...

Adding Thousand Separator to Int in Swift

ios,swift,separator

You can use NSNumberFormatter to specify a different grouping separator as follow: extension Int { var addSpaceSeparator:String { let nf = NSNumberFormatter() nf.groupingSeparator = " " nf.numberStyle = NSNumberFormatterStyle.DecimalStyle return nf.stringFromNumber(self)! } } let myInt = 2358000 let myIntDescription = myInt.addSpaceSeparator // "2 358 000" Note: If you would like...

asp.net mvc: thousand separator for int value

asp.net-mvc,asp.net-mvc-4,int,separator

Apply the DisplayFormat attribute to your model property: [DisplayFormat(DataFormatString = "{0:N2}")] public decimal Cost { get; set; } Then the formatting is done by the ModelBinder for you instead of you having to remember to do it in each individual view....

in R: save text file with different separators for each column?

r,save,separator

The function write.table accepts only one separator. MASS::write.matrix can do the trick: require(MASS) m <- matrix(1:12, ncol = 3) write.matrix(m, file = "", sep = c("\\tab", ","), blocksize = 1) returns 1\tab5,9 2\tab 6,10 3\tab 7,11 4\tab 8,12 but as the documentation of this function does not say that multiple...

How to remove the first nav menu divider

html,css,menu,navigation,separator

Just use: nav li:first-child{ background:none; } ...

how to remove seperator from the end of a list python

python,list,separator

Just use the join() method: def to_string(my_list, sep=' '): return "List is: " + sep.join(map(str, my_list)) If you would like to use the range() function: for i in range(len(my_list)): if i > 0: new_str += sep new_str += str(my_list[i]) This is unfortunately horribly un-Pythonic, and inefficient because Python has to...

Conditions combined with logic OR - Swift (error)

swift,condition,logical-operators,separator,swift-playground

The condition in the if statement is really weird: When something should execute when either the first value is greater than the second or the second is greater than the first, then that's like checking whether the values are indifferent! So if normalDegrees > degreesInACircle || normalDegrees < degreesInACircle is...

How to change the default separator of my list items?

css,menu,separator,divider

You don't need position:absolute at all as it's overkill (albeit not very much overkill). You can use floats instead: li { display: inline-block; margin-left:10px; /* Adjust as needed */ } li:not(:first-of-type):after { /* Exempts the first LI */ display:block; float:left; margin-right:10px; /* Adjust as needed */ content:"/"; } <ul> <li>Home</li>...

Formatting number field with decimal separator depending on locale settings

crystal-reports,formatting,report,decimal,separator

As far as I know there is no way to directly get the local systems symbols for thousands separator and decimal. You can, however, manually check the locale via the contentlocale variable and select the appropriate formatting. For example, to display a '.' as the decimal symbol for United States...

Decimal number in CSV file

vb.net,csv,tostring,cultureinfo,separator

How I have to convert a decimal number to string if I want to use correct local decimal separator? By default the current culture's separator is used anyway. But you can use the overload of Decimal.ToString that takes a CultureInfo: Dim localizedNumber = (intValue / 100).ToString( CultureInfo.CurrentCulture ) If...

How to change the separator in the Webix multiSelectFilter?

javascript,filter,multi-select,separator,webix

In Webix 2.2 you can use separator property next to a filter configuration. Something like next header:{ content:"multiSelectFilter", separator:";" } Full sample can be checked by the next link http://webix.com/snippet/e3ed3929...

awk: Preserve multiple field separators

bash,awk,separator

$ cat /tmp/1 /path/to/example_file_123.txt /path/to/example_file_345.txt $ awk -F'_' '{split($1,a,".*/"); gsub(a[2],"",$1);print $1$2"_"a[2]"_"$3}' /tmp/1 /path/to/file_example_123.txt /path/to/file_example_345.txt ...

Multiplatform getResourceAsStream

java,windows,unix,path,separator

A resource path should always use '/' as it is not conceptually looking for a file path but a resource path within a class path entry.

Datagridview row to text boxes string split Issue

vb.net,datagridview,separator

we have no context for the code such as whether it is a click event etc, and your question is hard to follow, but this seems to be wrong: Dim i As Integer Dim line As String = DataGridView1.Item(1, i).Value i will always be zero - you just declared it...

UITableView cell's seperators disappear when selected

ios,objective-c,uitableview,separator

The cause of my issue was the fact I used a blue color shade to show a cell being selected. This shade however was a little too big. It was covering the seperator

What is the ISO characters for the Numbers group separator in Polish?

java,numbers,group,separator

You don't need to parse it. If you set the locale appropriately then Java will do the parsing for you. Just use the NumberFormat.parse(String): http://docs.oracle.com/javase/6/docs/api/java/text/NumberFormat.html#parse%28java.lang.String%29 You can use my code to print a list of available locales and their format: import java.text.NumberFormat; import java.text.SimpleDateFormat; import java.util.*; public class Test {...

Parse file and use some of the fields as variables using the header as name in bash [closed]

bash,sed,while-loop,separator,fastq

You may find an awk script more robust and less cumbersome to use than a shell loop: $ cat tst.awk BEGIN { FS="\t" } NR==1 { for (i=1; i<=NF; i++) f[$i]=i; next } { print "downloading", $(f["SRA_Sample_s"]) out_dir = $(f["tissue_s"]) gsub(/ /,".",out_dir) cmd = sprintf( "/soft/bio/sequence/sratoolkit-2.3.4-2/bin/fastq-dump.2.3.4 --split-3 --outdir %s --ncbi_error_report...

jQuery, change separator to dot and divide two selected numbers

javascript,jquery,replace,separator,divide

How can I convert selected values from comma separated values to dot separated values? From that, I take it that the values you get from $('.lot2').text() and $('span.Price').text() will use , as the decimal point rather than . (as is the case in some locales). I assume that you...

File.separator vs. File.pathSeparator [duplicate]

java,file,separator,difference,path-separator

java.io.File class contains four static separator variables. For better understanding, Let's understand with the help of some code separator: Platform dependent default name-separator character as String. For windows, it’s ‘\’ and for unix it’s ‘/’ separatorChar: Same as separator but it’s char pathSeparator: Platform dependent variable for path-separator. For example...