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
2answers
50 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 ...
0
votes
1answer
21 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: ...
1
vote
1answer
47 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 ...
0
votes
0answers
16 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....
0
votes
1answer
39 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 ...
1
vote
1answer
14 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) ...
0
votes
1answer
34 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 ...
0
votes
1answer
118 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 ...
0
votes
0answers
55 views

Searching for a string in all .txt files on the Windows 10 PC [duplicate]

It appears that there is a command for this on Linux (as one would expect), i have troubles finding it for Windows 10. As the title says, i want to search inside all files with .txt extension on all ...
0
votes
1answer
27 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 ...
0
votes
1answer
24 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 ...
1
vote
1answer
50 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 "...
1
vote
1answer
32 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,". ...
2
votes
2answers
48 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 ...
0
votes
1answer
59 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 ...
0
votes
0answers
23 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 ...
1
vote
1answer
541 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 ...
0
votes
0answers
134 views

Excel/Word: When opening a hyperlink that contains a question mark, the question mark and everything after it is removed in the URL. Why?

I am working in the Excel and Word app versions of Microsoft Office 365. If I attempt to open a hyperlink with a question mark, the website opens with only the text that appears before the question ...
0
votes
0answers
33 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 ...
-1
votes
0answers
138 views

How do you pass a number string to a program in a batch file

I'm making a batch file which runs ffprobe to get the length of a video file. this info is save inside a text file. I can then load that data into my batch file and remove the decimal places from the ...
0
votes
1answer
127 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) ...
0
votes
1answer
252 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 ...
1
vote
1answer
32 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 ...
1
vote
1answer
333 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 ...
0
votes
1answer
63 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 ......... -------------------------------------------------------------------------------------------...
0
votes
1answer
55 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 ...
0
votes
1answer
46 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, ...
0
votes
1answer
72 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","...
0
votes
1answer
4k 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 ...
0
votes
1answer
43 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" ...
0
votes
1answer
54 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: ...
0
votes
1answer
1k 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 ...
0
votes
2answers
246 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";
0
votes
1answer
60 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....
0
votes
4answers
138 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 ...
1
vote
3answers
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 ...
0
votes
1answer
42 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 ...
0
votes
1answer
383 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 ...
0
votes
2answers
70 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
0
votes
1answer
1k 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 ...
1
vote
1answer
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 ...
2
votes
1answer
618 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 ...
2
votes
1answer
929 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(...
2
votes
3answers
1k views

Extract and SUM numbers from a string

I have looked at the similar questions to this but could not find an exact solution to my problem. If there is a duplicate which can solve this I will close this question. In cell A1 I could have a ...
0
votes
1answer
32 views

Cut 4 digits from AD DisplayName

I have googled and used the PS help as much as possible but can't find a definitive resolution to the seemingly small issues that I have. My users have [ZZ] at the end of their displayName of their ...
0
votes
1answer
617 views

Extracting SharePoint data on daily basis

I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as Dataname_yyyyMMdd. As per my below script, it need to export data from the ...
0
votes
2answers
620 views

Extract Text from in front of, after, and inside characters

I have a variable (%~1) set to something like: Hello there this is a block: [C]Inside of Block[/C] Did you like it? I want to have it separated into three variables: Front=hello there this is a ...
0
votes
1answer
905 views

extract data from SharePoint document library to CSV using powershell

I am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
0
votes
1answer
458 views

Hashtags are coming when export data to CSV file by powershell script

I am running a powershell script for getting data from SharePoint document library. While run the script, data came to csv file, but columns names are coming with ";#" hashtags. For example, names, ...
1
vote
1answer
2k views

Equivalent of a wildcard in find for batch?

I'm almost certain this is a duplicate but I was unable to find it after a lot of searching so forgive me. I'm looking for a way to have the equivalent of a wildcard in the find command. For ...