Apollo sees a slash in titles and thinks it’s a folder delimiter when saving images imgur.com/a/Qe4sE1H/
πŸ‘︎ 651
πŸ‘€︎ u/crumpetcrusher
πŸ“…︎ Jun 05 2021
🚨︎ report
String delimiters in BibTex

I've just started using BibDesk in macOS to manage bibliographic information. I have perhaps 275 entries in a mixed set of *.bib files created over a number of years using vim and TeXShop wherein I used double quotes to delimit strings, as in:

author = "Noble, Ben",
title  = "Applied Linear Algebra",

The default behavior in BibDesk (I am using v1.8.3) uses { } to delimit strings, as in:

	author = {Noble, Ben},
	title = {Applied Linear Algebra},

and reports an error for every instance of double quotes. There must be a way to force BibDesk to use " " but so far all my efforts to find this setting in BibDesk preferences or by querying google have failed to reveal this setting. Man, I do not want to convert my *.bib files, since BibTex will accept either pair of delimiters. I like to use " " for strings and reserve { } for accented non-English characters. BibDesk is very powerful, and I would like to use it, but only if I can make this switch. Any suggestions?

πŸ‘︎ 6
πŸ‘€︎ u/ancient_perlboy
πŸ“…︎ Jun 27 2021
🚨︎ report
Read a txt file into a DataFrame with only pre-defined field locations act as delimiter

Hello there,

I am trying to read a txt file into a DataFrame using pd.read_csv().

However I soon realized that I cannot use a simple delimiter. The txt file is formatted using the locations and length of each field, such as:

Client ID 1 10
Client Name 11 60

Each of the fields could contain a comma, space, or other characters that usually act as a delimiter.

A typical line would look like:

DIDIDI12354John, Doe                                                   @@47385y43785yHUIBBIBJIBIBUBK@@SUBUKBCSHB77                                    NUIKBHUS1234                                                  Unit 7                        45             NON'EXIST RD                                                          A                             

The only way to separate the fields seems to be using the position provided in the picture.

I wonder if there's a way that I can perform the task?

Thanks! πŸ™‚

πŸ‘︎ 2
πŸ‘€︎ u/sengiPum
πŸ“…︎ Jun 26 2021
🚨︎ report
Power Query - Split into 3 columns (Qty, Unit Price, Total Price), but numbers of delimiters are inconsistent

I'm currently importing pdfs from folder and appending them together. PDFs format are all consistent but somehow when it is imported into power query, sometimes the columns would not align. After some querying and cleaning the data, I ended up with the column that contains Qty, Unit Price, and Total Price but they are separated by inconsistent amount of delimiters (Hyphen).

Here's the column: https://imgur.com/a/gi3Luxl

πŸ‘︎ 17
πŸ‘€︎ u/Chopa77
πŸ“…︎ May 19 2021
🚨︎ report
How can I separate a column without a delimiter like IDStateOwnerOwnerID into 4 columns? picture inside

I get a report which exports data like 688ArizonaNoah1 and 52KentuckyJackson16 and I need to separate them into 4 columns. The first example would be like 668, Arizona, Noah, 1 and the second would be 52, Kentucky, Jackson, 16. How can I do this? The lengths of any of the columns can be variable

Picture example:

In the picture I get the values in yellow exported and need to break it out into the values in green.


πŸ‘︎ 4
πŸ“…︎ May 29 2021
🚨︎ report
Tab delimiter & Vivaldi's tab close button

I don't know css well and would appreciate help with:

  • adding delimiter between tabs like in picture
  • making tab close button behavior similar to that on Vivaldi browser (close button appearing only on hover and in place of favicon)


πŸ‘︎ 3
πŸ‘€︎ u/3ntand
πŸ“…︎ Jun 13 2021
🚨︎ report
Read string by delimiter and new line

I have a text file that has data on each line:


I can create new line numbers by the semicolon delimiter, however, after minutes, there is no semicolon, just a line break, so my program doesn't recognise each new line as a new line also. The current code I have is:

int main () {

  cout << "Enter the name and extension of the file: ";
  cin >> filename;
  inputfile.open(filename.c_str(), fstream::in);
  if (inputfile.is_open() == false) {
    cout << "ERROR: not able to open " << filename << endl;
    cout << "Please try again." << endl;
    return main();
  else {
    cout << "Displaying all lines from " << filename << endl;
    number = 0;
    while (getline(inputfile, line, ';')) {
      cout << number << ": " << line << endl;
    cout << "Displayed " << number << " lines from the file.\n";

This currently returns:

1: Name
2: Number
3: Minutes

and so on. As you can see, the new line within the text file, where the second name begins, does not have a line number associated to it. To read the semicolon delimiter and a line break within the text file as new lines, I've tried:

while ((getline(inputfile, line ';')) || (getline(inputfile, line '\n)))

But to no avail. what else can I try?


πŸ‘︎ 16
πŸ‘€︎ u/blooaar
πŸ“…︎ May 20 2021
🚨︎ report
How to separate and split text in google sheets based on delimiters?

I have raw text in form of strings

<string name="ServerStarting">Server will restart in 10 minutes!</string>

So how do I pull the first portion (until first ">") in a separate cell?

How do I divide the above text in two portions:
<string name="ServerStarting">


Server will restart in 10 minutes!</string>

I remember using this function some long time ago, but forgot how to do it.

I think it had something to do with delimiters.

Thank you for help!

πŸ‘︎ 3
πŸ‘€︎ u/BasadoBasado
πŸ“…︎ Jun 06 2021
🚨︎ report
How to and save the met delimiters when using strtok()?
char str[50]="dfdsf{}.,dfdo,L!oo";
char* p=strtok(str,".,|~?!(){}&lt;&gt;");
πŸ‘︎ 6
πŸ‘€︎ u/JacksonSteel
πŸ“…︎ May 24 2021
🚨︎ report
HELP:- VBScript to delete text before and after delimiter

Hi All,

This is a batch script I have.

IF EXIST list.tmp DEL list.tmp
for /f "delims=' tokens=2" %%A in (results.txt) do &gt;&gt;list.tmp echo %%A
IF EXIST list.tmp (
    sort list.tmp &gt; Final.txt
    DEL list.tmp

For some reason "FOR /F" command is not processing results.txt on my system.

Can anyone post a VBScript that can do the same thing?


πŸ‘︎ 4
πŸ‘€︎ u/mNash316
πŸ“…︎ Apr 10 2021
🚨︎ report
Is there any CAS delimiter mods?

Basically, I'm looking for a mod that removes (Or at least expands to a big degree) the limits for CAS so I can make pretty much any part of a sim as big as I want.

I'm sure there used to be one, but I cant remember the name. Couldn't get it to work when I tried it either IIRC.

πŸ‘︎ 3
πŸ‘€︎ u/JuanAy
πŸ“…︎ May 28 2021
🚨︎ report
Separating Strings through a Delimiter

Even after racking my brains over it I can't figure this out at all.

I'm stuck at this problem that requires me to copy two separate parts of a single input string from the user (in the format of a=b) into two separate string variables ("a" and "b") using a delimiter ("="). Each string variable also has a max character limit.

Then I'm supposed to output the string variables into the console.

I thought of setting up a loop through the string until it finds the delimiter but I can't figure out how I'm supposed to do that, or how to separate the separate string variables after that.

πŸ‘︎ 10
πŸ‘€︎ u/Jackofallshits
πŸ“…︎ Apr 09 2021
🚨︎ report
Parsed message field based on delimiter

I need some help figuring out a way to dynamically parse through a log like the one below without having to specify groups. I’m very new to regex, so I’m not sure if that’s even possible.

For example: "message":"type=LOGIN_ERROR, realmId=master, clientId=ui, userId=92cdda0b-28b4-46df-8f81-48458708eb48, ipAddress=, error=invalid_user_credentials, auth_method=openid-connect, auth_type=code, redirect_uri=https://centralus-v2.mydomain.com/signin, code_id=f8d8be37-eb0e-40cc-a507-db5862cd0719, username=demo@mydomain.com, authSessionParentId=f8d8be37-eb0e-40cc-a507-db5862cd0719, authSessionTabId=pvMeYvDFhU4

Any help/feedback is appreciated.

πŸ‘︎ 2
πŸ‘€︎ u/stockmk7
πŸ“…︎ May 28 2021
🚨︎ report
VLOOKUP on partial strings with delimiters?

I have a dataset that looks like below and for each of the text strings between with Wk, I need to replace with a value from another table and then put back in that original format, including the "-" and ","

As Is Should Be
Wk1,Wk3,Wk5,Wk7-Wk11,W13 Wk3,Wk5,Wk7,Wk9-Wk13,Wk15
Wk1-Wk4,Wk5-Wk7,Wk9,Wk11 Wk3-Wk6,Wk7-Wk9,Wk11,Wk13

There's hundreds of rows of unique data so unfortunately it will take a while to Find and Replace. Is there anything I can do?

Edit: I'm using Excel 2016

πŸ‘︎ 2
πŸ‘€︎ u/loneralamode
πŸ“…︎ Apr 18 2021
🚨︎ report
Text File with Extended Character as Delimiter

Hi, I'm using Excel 2013, and trying to import a text file that apparently has data delimited by the "unit separator" extended character (hex 01F, dec 31) as well as tabs.

I've checked both Tab and Other in the delimiter option list, but I can't figure out how to input this extended character in the box.
Is there a way to do so, or am I stuck (seemingly as ever with Excel) with pre-massaging data for import?

As an example, a line in the file may contain:
field**[TAB]field[US]field[US]field[TAB]** ....

πŸ‘︎ 4
πŸ‘€︎ u/cutlass_supreme
πŸ“…︎ Apr 18 2021
🚨︎ report
Regex to select data after Nth comma (or any delimiter)

Hello everyone, this is not a question but a solution! I was going to post on here yesterday about a regex I was making but decided not to, then ended up figuring it out with the help of a friend.

A little backstory as to why I had to make this: coworker and I are sending firewall logs to our SIEM (what I found said that our SIEM uses java regex) and every line is comma delimited. We're making custom events for the data and wanted a robust yet specific regex because not every space between a comma has data. So, onto the regex!

Here is the blurb of data I was working with (sanitized, of course):

&lt;13&gt;Apr 20 16:19:36 SERVERNAME.domain.net 1,2021/04/20 16:19:36,013244444796,THREAT,data,2049,2021/04/20 16:19:36,,,,,FWRULE NAME,,,sharepoint-online-uploading,vsys1,fwrulename,zone,protocol.stuff,ethernet1,SourceOS,2021/04/20 16:19:36,34916,1,49538,443,11070,443,0x1406000,tcp,alert,"'FILE_01.docx'",DataPattern-Conf(60004),computer-and-internet-info,low,client-to-server,69181231233089036,0xa000000000000000,,United States,0,,0,,,3,,,,,,,,0,13,14,35,11,,SERVERNAME,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,424949495,

The regex we came up with is:



(?: ) means non-capture group, ie "Look for this thing, but don't capture it"

[^\,] ignore this character (comma), but select everything * up to this character \,

{9} is doing the leg work, we are able to specify which N block of data we want.

(.*?) capture all characters (keep in mind, this is after the regex has identified the block of data we want) \, up to this character (comma)

And finally, here it is working on Regex101:


I scoured over google, stack overflow, etc for hours and couldn't find this exact issue, so I really hope this helps someone out there!

Edit: just for clarity, something didn't sound right

πŸ‘︎ 2
πŸ‘€︎ u/ericvader8
πŸ“…︎ Apr 22 2021
🚨︎ report
Is it possible to split with a word as a delimiter?

I know about strok() but that only splits at single characters. I need a splitting-function that can split at a specific word. Is there already such a function or do I have to implement myself?

πŸ‘︎ 3
πŸ‘€︎ u/GeroSchorsch
πŸ“…︎ Mar 13 2021
🚨︎ report
Capture digits with delimiters, ignoring an optional terminating delimiter


I feel like a needy noob for asking for help with this, and I'm sure the pattern will be blindingly obvious once I see it, but I can't figure this one out. Friday woes.

I have strings in the following format:

(digits with delimiters) (text)

I would like to get the respective groups.

All known examples have a space between the two, but for safety's sake, I'd like to assume there isn't a space between the two groups.


>2.035 tons

Expected groups: (2.035), ( tons)

>1.5, three

Expected groups: (1.5), ( three)

>20,000 leagues

Expected groups: (20,000), ( leagues)

Naive Regex


Problems with the above pattern

  • If the digit group terminates with a delimiter (comma, period), then that terminal delimiter is included in the first capture group. I don't want this. For example, "1.5" and "three" are separated by a comma; "1.5," is not a value with a trailing/hanging delimiter.

Tried thus far

  • positive and negative lookaheads
  • conditional constructs


  • Python >= 3.6

Thanks in advance!

πŸ‘︎ 4
πŸ‘€︎ u/AndrewParsons
πŸ“…︎ Apr 16 2021
🚨︎ report
Is there a way to replicate Resharper's Highlight Matching Delimitersο»Ώ > Outline Border in Rider? jetbrains.com/help/reshar…
πŸ‘︎ 7
πŸ‘€︎ u/redthrawn
πŸ“…︎ Mar 26 2021
🚨︎ report
Split By Delimiter only produces 2 columns when there should be more

I am trying to split out a column of data which is delimited by a semi-colon ( ; ). The problem is whenever I run the Split Columns function in Power Query editor, it only produces 2 columns, when there should be more. I know there should be more because I have checked but the issue is I do not know what the maximum is, as there is over 140k lines of data.

Whenever I select the column and choose Split Columns, the number of columns indicated under advanced options is 2. I have tried deleting this but to no avail.

My work around annoyingly has been to edit the .csv file directly and use Text To Columns in Excel. I have then reimported the modified file and I can then Unpivot the columns as planned.

This is obviously really annoying though and I was hoping someone might know what is causing this. I have never had this issue before but I don't think I have had a dataset this large. Not sure that should be an issue though.

πŸ‘︎ 2
πŸ‘€︎ u/Staffchild101
πŸ“…︎ Apr 08 2021
🚨︎ report
Change concept - descriptor delimiter

Is there a way to change the concept β€” descriptor delimiter from : or :: to something like ;:?

I am using both : and :: in my daily writing, so now I have +8000 flashcards I don’t use.

πŸ‘︎ 5
πŸ‘€︎ u/miciver
πŸ“…︎ Apr 23 2021
🚨︎ report
How to print a list of strings with a delimiter?

I'm using Python 3.6 and I have

def foo(list):
     print "Hello, " + list[0])
      print "Hello, " + list[1])
       print "Hello, " + list[2])

Can anyone help me understand what this is supposed to mean?

πŸ‘︎ 2
πŸ‘€︎ u/abstract_void_bot
πŸ“…︎ Feb 22 2021
🚨︎ report
Nice Bug to Have... But Token display is missing digit delimiter (at least in US English locale)
πŸ‘︎ 2
πŸ‘€︎ u/NathanielWolf
πŸ“…︎ Mar 25 2021
🚨︎ report
Trying to find key pair on C++ map after using delimiter on string but then this happens, how to fix?

I created a map that contains morse code paired with its alphabetical counterpart. What I intended on doing was, after my program did its thing, that the string would be split up into different parts, as it would result in something like this for example:


The delimiter would use the dash as a splitter and output that but separated(without the /)

However, the problem was when I tried to output its alphabetical counterpart within the delimiter loop; it would keep outputting the last value from the string, but nothing else since I assumed they got deleted. This is the code:

if (j &gt;= dataprocess.datasize - 1) {

while ((pos = container.find(delimiter)) != string::npos) {

token = container.substr(0, pos);

cout &lt;&lt; token &lt;&lt; endl;

container.erase(0, pos + delimiter.length());

cout &lt;&lt; map1[container] &lt;&lt; endl; -- the line that finds the pair

finish = true;


cout &lt;&lt; container &lt;&lt; endl;


It only works once and just outputs the final value. I just do not know how to get it to convert all the other values that it is going through too

πŸ‘︎ 3
πŸ‘€︎ u/J-100
πŸ“…︎ Apr 04 2021
🚨︎ report
Best Way to Take a Single Cell Formatted List this 123, 456, 789 and Create Three Rows That Break the Date Out by Comma Delimiter - Can Power Query do This?

EDIT - I added a picture of how the information is sent to me/the desired results. Sorry, I wasn't very clear in my original post. There is additional data in other columns, I need to keep this extra data with the first ID that is listed.

Desired result


Hi everyone, thanks in advance for any help!

A vendor provides a list that contains multiple IDs in a single cell that are separated by a comma.

This is how the data is presented in a single cell like this, there are multiple rows that contain additional information below this with no blank rows in between: 123, 456, 789

I would like to break this out by the comma delimiter to a total of three cells in three rows (a total of three rows including the original cell that had the original data), and have Excel automatically insert the extra rows needed to break it out.


A1 has 123 in it

B1 has 456 in it

C1 has 789 in it

Thanks again for any suggestions!

πŸ‘︎ 5
πŸ‘€︎ u/llama111
πŸ“…︎ Feb 20 2021
🚨︎ report
Split line but keep delimiter (regex)

I need to parse something like [QUOTE]Some quoted text[/QUOTE] and keep the [QUOTE] blocks in the split string but I can't get it working properly. Look at this fiddle: https://jsfiddle.net/wn9d6p8o/

Basically I just want to get rid of the duplicated lines #3 and #6 but I'm out of ideas. Any regex experts here that can help?

πŸ‘︎ 2
πŸ‘€︎ u/neg_ersson
πŸ“…︎ Mar 29 2021
🚨︎ report

Please note that this site uses cookies to personalise content and adverts, to provide social media features, and to analyse web traffic. Click here for more information.