I have a Flask site and I want to use the AngularJS JavaScript framework.  Unfortunately, it seems as if the delimiters overlap.  

How do I use Angular with Jinja2 if both rely on double curly braces (`{{ expr }}`)?  Is it even possible?

Is it possible to use AngularJS with the Jinja2 template engine?

I have a string of the format
&quot;key1=value1;key2=value2;key3=value3;&quot;

I need to convert it to a dictionary&lt;string,string&gt; for the above mentioned key value pairs.

What would be the best way to go about this?
Thanks.

Convert a delimted string to a dictionary&lt;string,string&gt; in C#

I want to import two kinds of CSV files, some use &quot;;&quot; for delimiter and others use &quot;,&quot;. So far I have been switching between the next two lines:

    reader=csv.reader(f,delimiter=&#39;;&#39;)

or

    reader=csv.reader(f,delimiter=&#39;,&#39;)

Is it possible not to specify the delimiter and to let the program check for the right delimiter?

The solutions below (Blender and sharth) seem to work well for comma-separated files (generated with Libroffice) but not for semicolon-separated files (generated with MS Office). Here are the first lines of one semicolon-separated file:

    ReleveAnnee;ReleveMois;NoOrdre;TitreRMC;AdopCSRegleVote;AdopCSAbs;AdoptCSContre;NoCELEX;ProposAnnee;ProposChrono;ProposOrigine;NoUniqueAnnee;NoUniqueType;NoUniqueChrono;PropoSplittee;Suite2LecturePE;Council PATH;Notes
    1999;1;1;1999/83/EC: Council Decision of 18 January 1999 authorising the Kingdom of Denmark to apply or to continue to apply reductions in, or exemptions from, excise duties on certain mineral oils used for specific purposes, in accordance with the procedure provided for in Article 8(4) of Directive 92/81/EEC;U;;;31999D0083;1998;577;COM;NULL;CS;NULL;;;;Propos* are missing on Celex document
    1999;1;2;1999/81/EC: Council Decision of 18 January 1999 authorising the Kingdom of Spain to apply a measure derogating from Articles 2 and 28a(1) of the Sixth Directive (77/388/EEC) on the harmonisation of the laws of the Member States relating to turnover taxes;U;;;31999D0081;1998;184;COM;NULL;CS;NULL;;;;Propos* are missing on Celex document

Can I import a CSV file and automatically infer the delimiter?

I am trying to load a CSV file into a Hive table like so:

    CREATE TABLE mytable
    (
    num1 INT,
    text1 STRING,
    num2 INT,
    text2 STRING
    )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY &quot;,&quot;;

    LOAD DATA LOCAL INPATH &#39;/data.csv&#39;
    OVERWRITE INTO TABLE mytable;    
&lt;br /&gt;
The csv is delimited by an comma (,) and looks like this:

    1, &quot;some text, with comma in it&quot;, 123, &quot;more text&quot;

This will return corrupt data since there is a &#39;,&#39; in the first string.&lt;br/&gt;
Is there a way to set an text delimiter or make Hive ignore the &#39;,&#39; in strings?

I can&#39;t change the delimiter of the csv since it gets pulled from an external source.

Hive load CSV with commas in quoted fields

The two characters `)&quot;` terminate the raw string literal in the example below. &lt;br&gt;
The sequence `)&quot;` could appear in my text at some point, and I want the string to continue even if this sequence is found within it.

    R&quot;(  
        Some Text)&quot;  
    )&quot;;       // ^^
   

How can I include the sequence `)&quot;` within the string literal without terminating it?

Include )&quot; in raw string literal without terminating said literal

I am trying to `insert` some text data into a table in SQL Server 9.

The text includes a single quote `&#39;`.

How do I escape that?

I tried using two single quotes, but it threw me some errors.

eg. `insert into my_table values(&#39;hi, my name&#39;&#39;s tim.&#39;);`

How do I escape a single quote in SQL Server?

Is there any way to specify a field delimiter for more spaces with the cut command? (like &quot; &quot;+) ?
For example: In the following string, I like to reach value &#39;3744&#39;, what field delimiter I should say?

    $ps axu | grep jboss

    jboss     2574  0.0  0.0   3744  1092 ?        S    Aug17   0:00 /bin/sh /usr/java/jboss/bin/run.sh -c example.com -b 0.0.0.0

`cut -d&#39; &#39;` is not what I want, for it&#39;s only for one single space. 
`awk` is not what I am looking for either, but how to do with &#39;cut&#39;?

thanks. 


How to specify more spaces for the delimiter using cut?

I had to move my Eclipse workspace from Linux to Windows when my desktop crashed. A week later I copy it back to Linux, code happily, commit to CVS. And alas, windows newlines have polluted many files, so CVS diff dumps the entire file, even when I changed a line or two!

I could cook up a script, but I am wondering if it will mess up my Eclipse project files.




Eclipse and Windows newlines

I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their purpose. After 20 minutes of googling, I was not able to find an answer which satisfies me. So, my question is now: What are delimiters and when should I use them?

Delimiters in MySQL

Is there a function in C# to quickly convert some collection to string and separate values with delimiter?

For example:

`List&lt;string&gt; names` --&gt; `string names_together = &quot;John, Anna, Monica&quot;`


C# List&lt;string&gt; to string with delimiter

I found some answers online, but I have no experience with regular expressions, which I believe is what is needed here.

I have a string that needs to be split by either a &#39;;&#39; or &#39;, &#39;
That is, it has to be either a semicolon or a comma followed by a space. Individual commas without trailing spaces should be left untouched

Example string:

    &quot;b-staged divinylsiloxane-bis-benzocyclobutene [124221-30-3], mesitylene [000108-67-8]; polymerized 1,2-dihydro-2,2,4- trimethyl quinoline [026780-96-1]&quot;

should be split into a list containing the following:

    (&#39;b-staged divinylsiloxane-bis-benzocyclobutene [124221-30-3]&#39; , &#39;mesitylene [000108-67-8]&#39;, &#39;polymerized 1,2-dihydro-2,2,4- trimethyl quinoline [026780-96-1]&#39;) 



Split string with multiple delimiters in Python

This code almost does what I need it to..

    for line in all_lines:
        s = line.split(&#39;&gt;&#39;)

Except it removes all the &#39;&gt;&#39; delimiters.

So,

    &lt;html&gt;&lt;head&gt;

Turns into

    [&#39;&lt;html&#39;,&#39;&lt;head&#39;]

Is there a way to use the split() method but *keep* the delimiter, instead of removing it?

With these results..

    [&#39;&lt;html&gt;&#39;,&#39;&lt;head&gt;&#39;]



Python split() without removing the delimiter

I have table :

    id | name    
    1  | a,b,c    
    2  | b



i want output like this :

    id | name    
    1  | a    
    1  | b    
    1  | c    
    2  | b

SQL split values to multiple rows

For coding reasons which would horrify you (I&#39;m too embarrassed to say), I need to store a number of text items in a single string.

I will delimit them using a character.

Which character is best to use for this, i.e. which character is the least likely to appear in the text? Must be printable and probably less than 128 in ASCII to avoid locale issues.

Least used delimiter character in normal text &lt; ASCII 128

When manually generating a JSON object or array, it&#39;s often easier to leave a trailing comma on the last item in the object or array.  For example, code to output from an array of strings might look like (in a C++ like pseudocode):

    s.append(&quot;[&quot;);
    for (i = 0; i &lt; 5; ++i) {
        s.appendF(&quot;\&quot;%d\&quot;,&quot;, i);
    }
    s.append(&quot;]&quot;);
    
giving you a string like

    [0,1,2,3,4,5,]

Is this allowed?

Can you use a trailing comma in a JSON object?

I&#39;m trying to find a Delphi function that will split an input string into an array of strings based on a delimiter. I&#39;ve found a lot from searching the web, but all seem to have their own issues and I haven&#39;t been able to get any of them to work.

I just need to split a string like: 
`&quot;word:doc,txt,docx&quot;` into an array based on &#39;:&#39;. The result would be 
`[&#39;word&#39;, &#39;doc,txt,docx&#39;]`. How can I do that?


Split a string into an array of strings based on a delimiter

The following code raises a `KeyError` exception:

    addr_list_formatted = []
    addr_list_idx = 0

    for addr in addr_list: # addr_list is a list
    	addr_list_idx = addr_list_idx + 1
    	addr_list_formatted.append(&quot;&quot;&quot;
    		&quot;{0}&quot;
    		{
    		&quot;gamedir&quot;  &quot;str&quot;
    		&quot;address&quot;  &quot;{1}&quot;
    		}
    	&quot;&quot;&quot;.format(addr_list_idx, addr))

Why?

I am using Python 3.1.

str.format() raises KeyError

I have comma separated data in a column:
&lt;!-- language: lang-none --&gt;

    Column 
    ------- 
    a,b,c,d 

I want to split the comma separated data into multiple columns to get this output:
&lt;!-- language: lang-none --&gt;

    Column1  Column2 Column3 Column4 
    -------  ------- ------- -------
    a	     b       c       d 

How can this be achieved?

Split comma separated column data into additional columns

Using `find . -print0` seems to be the only safe way of obtaining a list of files in bash due to the possibility of filenames containing spaces, newlines, quotation marks etc.

However, I&#39;m having a hard time actually making find&#39;s output useful within bash or with other command line utilities. The only way I have managed to make use of the output is by piping it to perl, and changing perl&#39;s IFS to null:

    find . -print0 | perl -e &#39;$/=&quot;\0&quot;; @files=&lt;&gt;; print $#files;&#39;

This example prints the number of files found, avoiding the danger of newlines in filenames corrupting the count, as would occur with:

    find . | wc -l

As most command line programs do not support null-delimited input, I figure the best thing would be to capture the output of `find . -print0` in a bash array, like I have done in the perl snippet above, and then continue with the task, whatever it may be.

How can I do this?

This doesn&#39;t work:

    find . -print0 | ( IFS=$&#39;\0&#39; ; array=( $( cat ) ) ; echo ${#array[@]} )

A much more general question might be: &lt;strong&gt;How can I do useful things with lists of files in bash?&lt;/strong&gt;

Capturing output of find . -print0 into a bash array

I am importing a CSV file like the one below, using `pandas.read_csv`:

    df = pd.read_csv(Input, delimiter=&quot;;&quot;)

Example of CSV file:

    10;01.02.2015 16:58;01.02.2015 16:58;-0.59;0.1;-4.39;NotApplicable;0.79;0.2
    11;01.02.2015 16:58;01.02.2015 16:58;-0.57;0.2;-2.87;NotApplicable;0.79;0.21

The problem is that when I later on in my code try to use these values I get this error: `TypeError: can&#39;t multiply sequence by non-int of type &#39;float&#39;` 

**The error is because the number I&#39;m trying to use is not written with a dot (`.`) as a decimal separator but a comma(`,`)**. After manually changing the commas to a dots my program works.

I can&#39;t change the format of my input, and thus have to replace the commas in my DataFrame in order for my code to work, and I want python to do this without the need of doing it manually. Do you have any suggestions?

Convert commas decimal separators to dots within a Dataframe

How can I split a string without removing the delimiters?

Let&#39;s say I have a string:
`var string = &quot;abcdeabcde&quot;;`

When I do
`var newstring = string.split(&quot;d&quot;)`, I get something like this:

`[&quot;abc&quot;,&quot;eabc&quot;,&quot;e&quot;]`

But I want to get this:

`[&quot;abc&quot;,&quot;d&quot;,&quot;eabc&quot;,&quot;d&quot;,&quot;e&quot;]`

When I tried to do my &quot;split2&quot; function, I got all entangled in splice() and indexes and &quot;this&quot; vs &quot;that&quot; and ... aargh! Help! :D

JS string.split() without removing the delimiters

How do I use a custom delimiter for angular JS? I&#39;d like to change from the `{{ var }}` syntax to `[[ var ]]`.

Can somebody show me a complete example on how to implement this with Angular?

Angular JS custom delimiter

    sc = new Scanner(new File(dataFile));
    sc.useDelimiter(&quot;,|\r\n&quot;);

I don&#39;t understand how delimiter works, can someone explain this in layman terms?

How do I use a delimiter with Scanner.useDelimiter in Java?

What&#39;s the best separator/delimiter character(s) for a plaintext db file?

I considered using `|`, `,`, `&lt;TAB&gt;`, `;`, etc. But they all seem to be possible to break when the nearby entries have special enough characters. 

So, the experienced database users, what delimiter character(s) do you suggest to use?

What&#39;s the best separator/delimiter character(s) for a plaintext db file?

In a config file, I have a key to which I wish to assign a URL.  The problem is that YAML interprets : and - characters as either creating mappings or lists, so it has a problem with the line

    url: http://www.example-site.com/

(both because of the colon following http and the hyphen in the middle)

Is there an explicit way to escape &#39;:&#39; and &#39;-&#39; ?  Or would it work to just put the whole thing in single quotes and call it a day?

How to escape indicator characters (i.e. : or - ) in YAML

I&#39;m trying to extract a certain (the fourth) field from the column-based, &#39;space&#39;-adjusted text stream. I&#39;m trying to use the `cut` command in the following manner: 

`cat text.txt | cut -d &quot; &quot; -f 4`

Unfortunately, `cut` doesn&#39;t treat several spaces as one delimiter. I could have piped through awk

`awk &#39;{ printf $4; }&#39; ` 

or sed

`sed  -E &quot;s/[[:space:]]+/ /g&quot;`

to collapse the spaces, but I&#39;d like to know if there any way to deal with `cut` and several delimiters natively?

How to make the &#39;cut&#39; command treat same sequental delimiters as one?

I&#39;m trying to use a BI tool to automate a process which extracts data from our DB system, and then upload it to a web site via HTTP POST.

The BI Tool I&#39;m using allows me to build the Request up as a text object which it will then send to the web resource. 

To get this working I use Fiddler to capture the web request that Chrome sent when I filled in the form manually. 

The request contains the following...

    ------WebKitFormBoundarycwwJjby5xTdrlr48
    Content-Disposition: form-data; name=&quot;upload&quot;; filename=&quot;data.csv&quot;
    Content-Type: application/vnd.ms-excel
    
    CSV HEADER DATA 
    CSV ROW DATA
    
    ------WebKitFormBoundarycwwJjby5xTdrlr48
    Content-Disposition: form-data; name=&quot;returnErrorCsv&quot;
    
    
    ------WebKitFormBoundarycwwJjby5xTdrlr48
    Content-Disposition: form-data; name=&quot;returnUrl&quot;
    
    
    ------WebKitFormBoundarycwwJjby5xTdrlr48
    Content-Disposition: form-data; name=&quot;entityPropertiesToReturn&quot;
    
    
    ------WebKitFormBoundarycwwJjby5xTdrlr48

I then got the BI Tool to mimic the request above and substitute in the data had extracted from the DB (where the CSV HEADER DATA and CSV ROW DATA Data would go - this data is confidential so I&#39;ve had to remove it).  

This is all working ok but my question is what does the string after WebKitFormBoundary mean? I.E cwwJjby5xTdrlr48

It is just a random string to identify one request from another? Or does it have another purpose? 

At the moment I&#39;m re-using cwwJjby5xTdrlr48 in all of my requests and it seems to be working ok but I thought it might be worth asking if I should construct my own string instead.

What does the random string after a WebKitFormBoundary do \ mean?

I am having trouble with the delimiter in the TStringList Class. Take a look:

    var
      s: string;
      sl: TStringList;
    
    begin
      sl := TStringList.Create;
      s := &#39;Users^foo bar^bar foo^foobar^barfoo&#39;;
      sl.Delimiter := &#39;^&#39;;
      sl.DelimitedText := s;
      ShowMessage(sl[1]);
    end;

`sl[1]` SHOULD return `&#39;foo bar&#39;`

`sl[1]` DOES return `&#39;foo&#39;`

It seems that the delimiter is now `&#39;^&#39;` AND `&#39; &#39;`

Any ideas?

Delphi: StringList Delimiter is always a space character even if Delimiter is set

I want to iterate through a list of files without caring about what characters the filenames might contain, so I use a list delimited by null characters. The code will explain things better.

    # Set IFS to the null character to hopefully change the for..in
    # delimiter from the space character (sadly does not appear to work).
    IFS=$&#39;\0&#39;

    # Get null delimited list of files
    filelist=&quot;`find /some/path -type f -print0`&quot;
    
    # Iterate through list of files
    for file in $filelist ; do
        # Arbitrary operations on $file here
    done

The following code works when reading from a file, but I need to read from a variable containing text.

    while read -d $&#39;\0&#39; line ; do
        # Code here
    done &lt; /path/to/inputfile

All Delimiter Solutions on Gang of Coders

Total of 29 Delimiter Solutions