Questions tagged [string]

A string is a sequence of zero or more characters. It is commonly used to represent text or a sequence of bytes. Use this tag along with the appropriate programming language being used.

Filter by
Sorted by
Tagged with
1 vote
0 answers
24 views

If a ligature/digraph has separate collation order, should it be considered different from constituent letters?

There are many digraphs and ligatures in common use like ß, w, ffi, st, æ, dž, ch etc. Some of these are completely different from its constituents. For eg, search for u in a string containing w should ...
user avatar
1 vote
1 answer
49 views

How to find a character in a string using Powershell?

Using Contains to find a value using PowerShell is not working. Full Story: I have to get the PartNo, Ver, and Rev values from an SQL DB, and check if these values occur in the first line of the text ...
user avatar
  • 13
1 vote
1 answer
37 views

Extract/Replace and Convert string in Notepad++

i have a file looking like this: Line 207: ["Mystic Scroll: Shock and Swarm"] = { Line 297: ["Mystic Scroll: Concentrated Solar Beam"] = { Line 474: ["Mystic ...
user avatar
  • 13
-3 votes
1 answer
21 views

Turning a string of text into individual rows [closed]

I have a series of letters in Excel I would like to turn into individual rows. Is there a simple command to do this instead of using text to column and separating through each one. The list is as ...
user avatar
  • 1
0 votes
1 answer
25 views

Using Notepad++ i am trying to change a string of numbers and letters like a MAC address to have the Semicolons in between every two characters [closed]

Using Notepad++ I am trying to change a string of numbers and letters like a MAC address to have a Semicolon in between every two characters and then a Comma between each MAC address and put them all ...
user avatar
0 votes
1 answer
133 views

ZSH iterate through string array containing spaces

I am trying to write a ZSH script which will iterate through a series of strings that contain spaces. First, I'll set -A the array: set -A a "this is" "a test" "of the" &...
user avatar
0 votes
0 answers
17 views

Excel string connection updates data but I need to keep history as well

I have a string connection to my first worksheet.The data gets updated when I refresh the first worksheet.I have another worksheet that pulls the data from the first worksheet and put it in format I ...
user avatar
0 votes
1 answer
62 views

Extract string after a delimiter like "/ " OpenOffice Calc

I have a file that converts inputs for me into an SKU-number (Stock Keeping Unit). The names and attributes I have are in one line and one cell like so: Temperature Displaying Smart Ring / Rose Gold – ...
user avatar
0 votes
1 answer
25 views

How to increment group numbers in a settings file?

I have an application with a settings file (.ini) that contains data in the common format: [group1] foo=bar bar=baz ... [group2] foo=bar bar=baz ... ... [group500] foo=bar bar=baz ... where the ...
user avatar
-2 votes
1 answer
35 views

Extract string and save each in txt

I have a file text with inside : line1 name1 line2 name2 How can I extract as this? Extract & copy line1 to a new file saved as name1 Extract & copy line2 to a new file saved as name2 I used ...
user avatar
  • 1
1 vote
2 answers
59 views

Formula to extract value before specific text and after comma or beginning of original cell

I'm trying to extract statistics from a single cell 65 Rush Yds, 1 Rush TD, 1 Fum Lost, 105 Rec Yds, 1 Rec TD to individual columns Rush Yds: 65 Rush TD: 1 Fum Lost: 1 Rec Yds: 105 Rec TD 1 Extracting ...
user avatar
0 votes
1 answer
97 views

How do i pass function parameter as string in fish shell

Octave has an --eval option that takes a sting like "sqrt(4)" and outputs "ans = 2". I want to create a function that passes the a parameter as string so i can call it like this: ...
user avatar
1 vote
1 answer
75 views

Conditional Formatting - Looking for cells not including two particular characters followed by two numbers

Using Excel 2013 I'm looking to apply a conditional formatting rule to all cells in a range of a column that do not contain SD followed by two numbers, so an example would be SD01 or SD32. The column ...
user avatar
  • 580
0 votes
0 answers
22 views

Excel: convert IMAGE cell to txt cell?

I download an excel file from web. In this DB file I have photo linked to some records but in the file each photo is linked in an IMAGE cell. I would like to insert the name of the photo instead IMAGE....
user avatar
  • 746
0 votes
1 answer
68 views

Excel: Extract a project number from a text string (various position and length)

In an Excel spreadsheet I have a column of mixed text strings containing project master data (type, project no., address, theme and such). From this string I need to extract the project number in an ...
user avatar
  • 3
1 vote
1 answer
17 views

How to prevent Safari from implicitly converting character in XHR request?

I picked this character 〉 as a separator for my combo-key-field for my DynamoDb database. That character surfaces in the browser as part of a next-page-query token. (in an endless scroll list view) ...
user avatar
  • 111
0 votes
1 answer
154 views

How do I include double quotation mark in a concatenated string in Excel

I have been unable to find a resource that shows how to add double quotation marks to a concatenated excel string. For example if I would like to represent 72 inches as 72" in a string the added ...
user avatar
  • 121
0 votes
1 answer
318 views

I keep finding the same string in memory dumps

First off, forgive me - this is less a problem and more of a personal curiosity, but hopefully it will pique the curiosity of my fellow enthusiasts here! As a geek, I do love to get into the processes ...
user avatar
  • 103
0 votes
1 answer
41 views

Find number of files that contain certain String

I have a directory containing a vast amount of xml files. I would now like to find the number of files (and optionally the names of said files) that contain a certain string. XML tags do not really ...
user avatar
  • 103
0 votes
1 answer
26 views

Is there a way to break lines that match a string pattern, but only if that pattern falls between matching strings?

I’m using the code below to break lines that match a pattern: Find what: ([0-9]) ([A-Z]) Replace with: \1\n\2 so that … Super Bowl 3,1:56.2 Armbro Goal 3,1:54.3 … becomes Super Bowl 3,1:56.2 ...
user avatar
  • 93
1 vote
1 answer
296 views

How do I combine lines of text in Notepad++ that are between string lines into one line of code, while retaining lines outside the string delimiters?

I have 100s of pages in text format in Notepad++ that came from a pdf file. Each page in the file has varying amounts of lines, but they all contain lines that read “TARGET_LINE,” and "...
user avatar
  • 93
1 vote
1 answer
45 views

How do I combine varying multiple lines of text in Notepad++ into one line of code with a common beginning and ending string?

I have 1000s of lines of text in Notepad++ with multiple instances of lines beginning with “FIRST_LINE,” followed by varying numbers of lines, and ending with a line called "LAST_LINE,". ...
user avatar
  • 93
2 votes
2 answers
51 views

How can I create a new line break at the first letter following a dash?

I’ve been using this wonderful site for years, but after hours of searching in it, I cannot figure out how to do the following in Notepad++. So I opened an account to respectfully make the following ...
user avatar
  • 93
0 votes
1 answer
177 views

Excel 2016: how to find all superstring matches in a column of cells from another column?

I have two columns of strings in Excel 2016. Column A is long. Column B is short. I need to: Loop over all cells in col B For each cell, I need to find all cells in col A where the string from B is a ...
user avatar
  • 353
0 votes
0 answers
27 views

What is the find and replace "s/{pattern}/{string}" format called?

s/{pattern}/{string} keeps coming up in find and replace contexts (vim, sed). Is this a standard way of presenting find and replace strings? Does it have a name? Is there a standard somewhere for this ...
user avatar
  • 20
2 votes
1 answer
1k views

FINDSTR Multiple Search Strings [duplicate]

Looking for either word “ And ” or “ In ” with preceding and ending spaces, I can using following FINDSTR command: findstr /r /c:” And ” /c:” In “ textfile Is there a way to do similar search with ...
user avatar
  • 21
0 votes
0 answers
50 views

How to stop Excel from saving .txt files with strings converted to "#########..."?

I need to save an Excel file as a tab-separated .txt file for compatibility with other software. However when I do this, the long strings of text that appear as strings of hash symbols in the UI but ...
user avatar
  • 507
0 votes
1 answer
226 views

windows batch compare then skip utf  in first line of file

I would like list lines of file in batch and, in case of UTF file, skip "" characters in first line. @echo off setlocal EnableExtensions EnableDelayedExpansion for /f "delims=" %%a in (list.txt) ...
user avatar
0 votes
1 answer
516 views

Powershell: evaluate math expression represented as string

In PowerShell, how do I evaluate a mathematical expression stored as a string? How do I get PowerShell to evaluate the following: C:\> $a="30000/1001" C:\> $a 30000/1000 C:\> Desired ...
user avatar
  • 481
1 vote
1 answer
61 views

Applying -lt on string variables in bash

I am new to bash scripting. I have to compare two values here, $i and $cdsStart: check if $i is lesser than $cdsScript, below is my code for doing the same. inputFile="$1" while read -r ...
user avatar
  • 111
1 vote
1 answer
4k views

Excel: Function which gives location of a cell containing specific text

I've had a look around on google but have only been able to find formulae for checking whether or not a cell contains a given piece of text, however what I'm looking for is slightly different. I ...
user avatar
  • 13
0 votes
1 answer
73 views

How to split the not regularly whitespace fields using awk or like others?

I want to split the data as below: $1 $2 $3 $4 $5 $6 $7 $8 ......... -------------------------------------------------------------------------------------------...
user avatar
0 votes
1 answer
63 views

String manipulation - get part after a certain word

Background: Although I think Fail2Ban is great way of securing subsystems like Apache, it takes a lot of work to get all the info together. So I'm writing a BASH script to do that for me. I need to ...
user avatar
  • 7
0 votes
1 answer
53 views

Excel 2013 - How to remove numbers only from different positions and preceded by different symbols, letters

Is there any formula on Excel 2013 that can be used to remove digits from rows? I want to leave only letters and symbols. The formula needs to work for numbers that can occur at any position, ...
user avatar
0 votes
1 answer
304 views

Return a row if a column has a partial or perfect match with CSV in Powershell

Basically, I want to search for a string and return any full or partial matches in a CSV format. Let's say I have an object $Shoes that looks like: "Brand","Style","Color","Price" "Reebok","...
user avatar
  • 101
2 votes
1 answer
7k views

What is the << EOF equivalent in powershell

What is the powershell equivalent to the Linux command: tee file.txt <<EOF Where the terminal <input> would be something like: blah blah <\n> beh ble <\n> EOF Let's say ...
user avatar
  • 1,699
0 votes
1 answer
86 views

Extract MID between characters, but from second instance in Excel

I need to isolate the middle string of text from a line. The number which follows the "Q." "400" When I pull the MID section, it grabs everything from the FIRST "S" to the end of the "Q400" ...
user avatar
0 votes
1 answer
131 views

Replacing lots of text with a string from the same line in one file

I have this: TEXT_CONNECTED "You're connected." TEXT_DISCONNECTED "You're disconnected." and many more. TEXT_CONNECTED and TEXT_DISCONNECTED are also used elsewhere in the same file, like: ...
user avatar
0 votes
1 answer
2k views

In Bash how to get the position of a substring, within a string, starting the search at character position n

I am new to Bash scripting, I've used Visual Basic in Windows before and am looking for a bash equivalent string function for VB's inStr(). example in VB : strMain = "abcABC123ABCabc" searchStartPos ...
user avatar
0 votes
2 answers
254 views

Can we store a whole string with the help of a single character pointer? If yes , How? [closed]

Here p is a character pointer not an array! Yet compiler gave no warning or error? char *p = "Vladimir";
user avatar
0 votes
1 answer
69 views

How can I use Regex to determine if a string has either a number, equation symbols, or a period in it?

I created this new custom console api while I was bored, and I created a feature which allows you to change a variables value. If your curious about the console api, heres a live pen: https://codepen....
user avatar
0 votes
4 answers
291 views

How do I set a column of numbers to have same length (string) of character in Microsoft Excel when some of those numbers are negative and decimal?

Let's say I have a list of the following numbers: 97.24 73.25 -28.66 -52.75 -74.83 -234.43 -209.85 176.64 -163.34 -398.64 -3.73 -75.16 How would I align them in a column such that they ...
user avatar
  • 1
1 vote
3 answers
2k views

How to reverse a string in Excel?

Is there an Excel function (or macro) I can use to reverse a string. i.e. to turn these words into sdrow eseht? Here is why I need that: My strings are similar to John|XYZ Street|215|USA and I need ...
user avatar
  • 33
0 votes
1 answer
44 views

Add multiline string after specific string

I´m trying to insert a multi-line string in a file after a specific string was found. I already searched and tried a lot of options, but none of them returned the result I expected. Here is the block ...
user avatar
  • 103
0 votes
1 answer
438 views

Xcode console input not matching output C++

I'm experiencing some weird problem writing C++ code in Xcode on a MacBook. I know the code isn't faulty as I have had windows users run it with no problems at all, but somehow the output I get is not ...
user avatar
  • 3
0 votes
2 answers
88 views

Remove last character from first word in excel

I need to remove the last character from first word in excel. For example I have the cell B1 with "Teas from Spain" and I need cell A1 to be "Tea from Spain". Thank you
user avatar
0 votes
1 answer
2k views

batch that change particular string on a .txt file [duplicate]

I have a example.txt witch contanins: [DDRAWSINK] PlaybackDisp=0 Fullscreen=0 CurUsage=2 PlaybackRes=0 ForceRender=0 DV Output On=0 DV Preview VGA=0 DV Port=0 single lines can have only 1 ...
user avatar
1 vote
1 answer
6k views

Searching for *exact* string on Google or other search engines [closed]

Google advanced search says that to search for an exact word or phrase, put the word or phrase in quotations, e.g. "rat terrier" However this doesn't work the way I want/expected for certain kinds of ...
user avatar
  • 51
2 votes
1 answer
770 views

Wrong string concatenation using Bash Windows Subsystem

I'm having headaches to know why my script doesn't work as expected under windows subsystem linux. My version from the store : Debian GNU/Linux 9.6 (stretch) (I tried ubuntu too, with the same ...
user avatar
  • 23
2 votes
1 answer
1k views

Find position of first uppercase character in excel string

I need to find the position of the first uppercase character in an Excel string. There are lots of resources on the web that have the same (or effectively the same) solution for this: =MIN(IF(ISERROR(...
user avatar
  • 181