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.

learn more… | top users | synonyms

0
votes
0answers
13 views

adding a number variable with a string [migrated]

I'm asking the user to enter a number and if the number is greater than 2 then I like to add the string -n to that number. Here's my code: read -p "Enter a number " result_sort if [ $result_sort ...
0
votes
2answers
30 views

Microsoft SQL. SELECT FROM WHERE query with varchar type column

Inside the SQL Server Management Studio I am trying a query like this: In human words: Give me all rows from the table where the string in the column "name" is "alice". My not working attempt on ...
1
vote
0answers
14 views

calc: Extract string from range of cells

I´m trying to figure out a easy to understand way to extract a string (that is in a range of cells) from a range of cells... That is the range of cells I have to look for a specific string (in a ...
1
vote
1answer
39 views

How To Search for multiple multi-word strings in vim?

For example I'm trying to search for the occurence of both hello world and goodbye world in the same line. I've tried a bunch of difference iterations. For example, if you want to find one multi-word ...
0
votes
2answers
55 views

How To Extract Pattern from a folder path (VBA Excel)

I'm pretty new to vba excel and trying to reorganise a very large file structure. Basically, all our equipment has a tag in the form of [A-Z][0-9]0-9][0-9][A-Z] e.g. J452G being a compressor. Every ...
2
votes
1answer
99 views

Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here: Excel function that evaluates a string as if it were a formula? Problem is this does not seem to work with a function in there. This ...
0
votes
1answer
77 views

A printer's SNMP community name is the default “public”, will changing it affect it's use?

I'd like to change it from the default "public" as a part of removing vulnerabilities in the workplace. Also, can the "read only", "read/write", and "trap" community names use the same strings?
0
votes
1answer
67 views

Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example: User enters the ...
0
votes
1answer
63 views

How to search and extract part of string in batch script?

I am pretty new to windows batch scripting and am having trouble to search and extract a portion of a string from a text file and display it out. Some samples data are shown below. The keyword for ...
0
votes
1answer
45 views

How can I delete before and after EMAIL in notepad++?

I have this: :814, 'pera', 'name1@gmail.com', '2ed', '', 'da', 0.00, '195..110.18'), >815, 'danka', 'name2@gmail.com', 'd3d6', '0655566', 'da', 0.00, '212..65.82'), *816, 'ana', ...
1
vote
2answers
75 views

Is it possible to see if two cells contain similar text in Excel? [duplicate]

I've got two columns populated with names, and I want to see if the names in each row are similar (not the exact same, just similar) to each other. Is there any way to do this on Excel?
0
votes
1answer
35 views

Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error Sheets("Material").Last.Offset(0, ...
-1
votes
1answer
57 views

Deleting entire line based off of string in powershell…and keeping the line below?

I'm having some issues with powershell. What I am trying to accomplish is this: file.txt = string1 a string2 b I am using the command: Get-Content C:file.txt | Where-Object {$_ -match ...
0
votes
3answers
65 views

Batch script If command on a String

What is wrong with the following command lines for my batch script? set test=BE99012345678901 if %test% == "BE99????????????"( echo This number begins with BE99 ) Else ( echo This number doesn't ...
1
vote
3answers
94 views

How can SHA512 make a long string into a short string

I´m wondering how this random and very long string €£$€@]}$€{[$£}]£[€€£$€@]}$€{[$£}]£[€]}€486745896€$@fdhhsgpbkjhYUVYUDTYhµµµ½789ty45thhrhYUFVYU7645646f8cgI JKHVruxty dw78fg f 9w64f ...
3
votes
3answers
487 views

Using vim to delete all lines except those that match an arbitrary set of strings

I use vim to remove all lines except those that match a particular string, e.g. :g!/[string that I want to remain in the editor]/d Works great. But what I really want, and haven't found anywhere, ...
0
votes
0answers
52 views

LibreOffice Calc dynamic text sort

Given the following table: A B 1 AA AA 2 HH BB 3 BB HH 4 II II 5 UU LL 6 LL UU I need to sort the values of column A to B dynamically, using only ...
13
votes
8answers
1k views

Bash Script to repeat every word in a line?

I have a string like: dog cat bird whale And I want to get dog dog cat cat bird bird whale whale All the words are in the same line. Any idea?
0
votes
1answer
40 views

How can I generate a large amount of standarized strings in a .txt file?

I'm in need of some large amount of strings generated in a .txt file. The format is number1:number2, number1 goes from 1030 up to 1130, number2 goes from 0 up to 15. Example: ...
0
votes
1answer
40 views

How to locate files within my computer containing strings of text

What I am trying to do: I am trying to locate files with in the directory \\xxxx that contain strings of text DSN=, Server=, UID=, Pwd=, Password=. The files do not have to contain every single ...
0
votes
1answer
16 views

What encoding is Banned Suffix List?

Mozilla maintains a effective TLD or banned suffix list at Public Suffix List and its wiki Public Suffix List. Most entries are straight forward, but some are confusing to me since I don't work with ...
0
votes
2answers
55 views

How do different operators deal with a given string

I want to read two strings as parameters to bash script, these strings are meant to be extensions, then I want to replace the extension of files with the first extension to the second extension. The ...
1
vote
1answer
240 views

Search, copy, paste, edit string in hex?

I'm using Windows 7 64-bit. I've got around 10,000 or so files that I want to edit. The trouble is that's just far too much to do by hand. I'll explain what I need to do below. In these files, there ...
1
vote
2answers
107 views

A method to find two strings within distance

I have a large text file collection. I'm looking for a way to find two strings that are on the same line (in the same file) in the collection where the distance in characters between those two ...
1
vote
1answer
66 views

Extract a string inside a line without whitespaces beetween other strings

I have a txt like this: [Server] Version=3 DTBNumber=1 [DTB001] DTBName=ODBC;DRIVER=SQL Native Client;UID=MAN;PWD=bingo156;DATABASE=SHITMAN;SERVER=(local); DTBType=5 DTBnUtenti=1 DTBUtenti=002LUCA; ...
0
votes
2answers
1k views

How to concat String, File Contents, and String in bash script?

I have a file which contains only one line $> cat file.txt apple,orange,cat,dog I need to append two String to it and assign it to a variable, one in front and another in the end, so that it ...
0
votes
0answers
57 views

How can i keep and remove some charecters from specific line notepad++

i have about 1000 of 80000 rows that looks like these lines and with different disposition ...
0
votes
1answer
36 views

Probability of colission when hash is half the size of data?

If i had a password of 100 bits, and hashed it with a hash function that returned a 50 bit key, now i brute force it until a get a string that produces a matching hash, is there now a 50% chance that ...
0
votes
1answer
74 views

GNU Screen - String Escapes

Can somebody please explain or point me to good tutorial about "String Escapes" used in ~/screenrc. I am playing with $PS1 and ~/.screenrc. While $PS1 seems pretty clear (colors, conditions, escape ...
0
votes
0answers
30 views

Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example: take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...
1
vote
0answers
90 views

GPU used for String operations ?

Am working a bit on CUDA, most of the examples and tutorials i see deal with implementing mathematical functions on the GPU ( Like some vector / matrix calculations). I was wondering if we can ...
0
votes
1answer
664 views

how to replace unknown substring of line with sed

I want to replace a substring in a line, but I don't know what that substring is. I do know how the line starts though. For example, DNS1=[...to be replaced....]. I tried: sed -i ...
0
votes
3answers
71 views

How can I get the string of a cell?

I have a list of around 20 items and the user can pick three of them to perform a comparison, so I need a formula which gets the "TRUE" and gives me the contents of the correspondent cell in the same ...
0
votes
2answers
63 views

MS Excel: is 'ABCD always exactly the same as =“ABCD” in a cell?

As described in the title, is 'ABCD always exactly the same as ="ABCD" in a cell? It says that all the characters after the beginning apostrophe will be treated as string, so does that essentially ...
0
votes
1answer
959 views

How do I populate a column with the first x characters of text data in another column

I have a column with 14 characters. There is real information based on the first three characters. I want to have another column with only the first three characters for visibility and group by ...
2
votes
1answer
9k views

Can I force an Excel 2010 Pivot-Table to display text strings from my raw data?

Here is my use-case. As a training specialist I want to look at a single tab in Excel and see student feedback at a glance. I want to see pie-charts showing who said "Yes" this course was a good use ...
1
vote
1answer
182 views

Batch : extract some characters of a string

How can I extract alphanumeric characters only from a string? Example : b:lbalbqsd1287/;:!, gives blbalbqsd1287 Is it possible with findstr?
0
votes
2answers
347 views

Deleting line from file using SED in MultiUser Case

I have a scenario where multiple users are connected to a server using SSH. I have a file which is read and written by all the users. The file contains numbers like this - 14554 14887 23451 15135 ...
1
vote
1answer
91 views

String variability generator: Forgotten password

There's a website that I changed my password on about 2 years ago, then quit. I know about 10 possibilities of what the password could be, and what I usually do is exchange a letter with a symbol, but ...
2
votes
3answers
4k views

Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question: 28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE" ...
0
votes
3answers
107 views

Bash PS1 string that evaluates certain code every time it is looked up

This question is very similar to this one: Colored PS1 string But I still don't understand completely. So say I have this function function getjobs { echo $(jobs | wc -l) } And my PS1 is ...
2
votes
2answers
408 views

how to make '' AND “” syntax highlight strings for python in notepad++?

Currently I have only "doubleQuotes" highlighted but the 'single ones' stay normal. Can someone confirm? Or have a solution how to fix that? In the stylers.xml there is WordsStyle named STRING which ...
0
votes
1answer
3k views

returning string from vlookup in excel

I am having trouble with the vlookup function in excel. I have 2 files: file1.xlsx and file2.xlsx. Both files have a list of products with a number of various information and I need to add values ...
1
vote
1answer
978 views

how to search for a specific string in the body of lotus notes email

There are previous questions similar to this have been asked but never answered explicitly. Simply saving use search all documents with an indexed database is not a complete answer. How do you ...
0
votes
1answer
249 views

shell script : rsync exclude

I'm building a shell script and at some point I'm excecuting thie command : rsync -arv --delete --exclude=".svn,*.db,.DS_Store" Source/ Dest/ However it seems the my exclusion doesn't work. Am I ...
1
vote
1answer
46 views

Converting strings in input file

I have a text file file1.txt on Unix. I'd like to produce another file file2.txt, in which I change all groups of lines that has this format (taken from a multiple-choice exam) a. [first choice] b. ...
0
votes
3answers
243 views

How to manipulate this string of text to make it readable?

I have this string in an excel file: 4603,2504603#;4616,2504616#;4617,2504617#;4519,2504519#;4620,2504620 (It's actually a lot longer than that, but the pattern is the same). I need to be able ...
1
vote
1answer
261 views

How to search for any files that do not contain a proper XML root element?

I need to be able to search several thousand XHTML and XML files and see a list of files that do not contain the following string on the first line: <?xml version="1.0" encoding="utf-8"?> How ...
0
votes
3answers
1k views

EXCEL: IF value for multiple cells

I have a 3 columns, some of which have countries in them like so I J K -------------- ----------------- ---------------- Denmark Finland ...
13
votes
3answers
6k views

Escaping apostrophe in single quotes string in bash

I don't understand how Bash evaluates escaping of apostrophe characters in single quoted strings. $ echo ''\''Hello World'\''' 'Hello World' #works $ echo '\'Hello World\'' > # expects you to ...