Delimiter Puns

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?

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:

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! 🙂

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

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.

https://imgur.com/a/6pqbqn7

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)

https://preview.redd.it/po9mzr7m10571.png?width=285&format=png&auto=webp&s=3eddc4801f4b2c040da680b496d8d5346acc2178

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

name;number;minutes

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, ';')) {
      number++;
      cout << number << ": " << line << endl;
    }
    cout << "Displayed " << number << " lines from the file.\n";
    inputfile.close();
  }
}

This currently returns:

1: Name
2: Number
3: Minutes
Name
4:Number

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?

Thanks

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">

and

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!

char str[50]="dfdsf{}.,dfdo,L!oo";
char* p=strtok(str,".,|~?!(){}<>");

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 >>list.tmp echo %%A
IF EXIST list.tmp (
    sort list.tmp > 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?

Thanks!

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.

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.

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=1.1.1.1, 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.

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 ","

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

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]** ....

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):

<13>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,1.1.1.1,2.2.2.2,3.3.3.3,4.4.4.4,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,100.0.0.0-100.255.255.255,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:

(?:[^\,]*\,){9}(.*?)\,

Explanation:

(?: ) 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:

https://regex101.com/r/0DpMBK/1

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

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?

SOLVED

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.

Examples

>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

(^[\d\.\,]*)(.+)

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

Flavor

• Python >= 3.6

Thanks in advance!

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.

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.

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?

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 >= dataprocess.datasize - 1) {

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

token = container.substr(0, pos);

cout << token << endl;

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

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

finish = true;

}

cout << container << 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

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

https://imgur.com/a/CBCwKqg

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.

Example:

A1 has 123 in it

B1 has 456 in it

C1 has 789 in it

Thanks again for any suggestions!

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?