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

3
votes
3answers
7k 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
127 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
544 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
5k 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
1k 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
344 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
49 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
254 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
2answers
377 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
2k 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 ...
14
votes
4answers
8k views

How do you escape apostrophe in single quoted string in bash?

I don't understand how bash evaluates escaping of apostrophe characters in single quoted strings. Here is an example: $ echo ''\''Hello World'\''' 'Hello World' # works $ echo '\'Hello World\'' ...
2
votes
1answer
8k views

function keys for paste specific text

I want to assign some text to F keys on Windows 7. For example, I want to press F5 to paste "000", or press F6 to paste ".00 US Dollars". It would be appreciated if anyone can help me (a piece of ...
1
vote
1answer
437 views

Protocol URL in Firefox doesn't work if it contains “%2F”

If I write something like the following into the navigation bar of Mozilla Firefox, nothing happens: ...
-1
votes
1answer
94 views

How to edit this string in cmd

I need once more a little help. I have this string: /a href="/get.php file=hackmii_installer_v1.0.zip&amp;key=43e7ce13e9818c0b4c5737b7d061005606dfad5e"><b>HackMii Installer ...
0
votes
1answer
914 views

paste multiple lines string to CMD or Bash variables

I want to copy multiple lines (splitted by Enter key) from, for example, notepad and then paste it into new variable in CMD or Bash console and after that do some operations on it. Although it's ...
0
votes
1answer
287 views

Excel: How can I replace a short string of characters with one character?

So, I keep a spreadsheet of all of my bowling scores and how I do on each frame. To show that I got a split, I use "#s", where # is how many pins I knocked over, but I want to replace all of these ...
0
votes
2answers
349 views

Alias for recursive case insensitive search in current directory

How do I set an alias, such as "mysearch", which will search for a string recursively in the directory I'm standing in. It should be as below: mysearch "this table..." = find -type f -exec grep ...
0
votes
2answers
453 views

Search recursively for a string containing whitespaces

I want to search for "this table..." string under /home/myuser directory recursively, ie in all files under /home/myuser and in all directories and sub-directories under /home/myuser. /home/myuser ...
2
votes
3answers
2k views

Get LVM size using AWK?

I'm in need to find out the LVM size of image vm001. Let's say I have a LVM volume called /dev/VGgroup/vm001. Now using lvdisplay I can find out the size: --- Logical volume --- LV Name ...
1
vote
1answer
365 views

notepad++ to search a line for varied strings. advanced commands

here it is ab12@zmial.com, Charles Dawson cd21@zmial.com, ef23@zmial.com, gh32@zmial.com, ij34@zmial.com, mn45@zmial.com, op54@zmial.com, Queen Roffman qr56@zmial.com, kl43@zmial.com, ...
1
vote
1answer
513 views

Scrape a site with curl/wget appending a parameter to each site

I need to scrape a website for all sites and append an Paramater, e.g. www.theSite.com/allpages?myPara=us Now what I got is wget --recursive to get all sites, but that doesn't append the parameter ...
3
votes
4answers
56k views

Excel extract substring from string

I am looking for a way to extract a variable length substring from a string. My cells will look something like: ABC - DEF ABCDE - DEF ABCD - ABC I want to split the string at the - character, so ...
3
votes
5answers
868 views

Convert string “1-5” into array of numbers in bash

What is the best approach to convert the string containing the range of numbers into numbers itself? This format is used for example in defining the range of pages to print. I define, I want to print ...
0
votes
1answer
250 views

AWK CSV stream editing, merge third columns for identical first columns when second column >= 0

I'm on Windows and have only heard of linuxes awk etc so I can only imagine that this is possible without actual scripting: I have data like .. 162 42 A single serving 162 62 of ...
2
votes
1answer
741 views

Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string

I had a followup question to this related post - Formatting a CSV to force Excel to interpret value as a string (not date or number) I was wondering how does one escape text starting with " using ...
17
votes
5answers
38k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

Searching around for a while trying to figure out how to format a CSV file in such a way to force Excel to interpret the values as a string and not try and convert them to numbers or dates. e.g... ...
4
votes
4answers
4k views

What is a Linux command to find files containing some strings but not another?

I'm trying to search a lot of XML files for certain strings but not other strings, and I'm having trouble putting a command together to do it. I only want it to list the file names that match the ...
2
votes
2answers
315 views

sed in bash not working

I am trying to use the stream editor sed in bash to replace a string in a file to a new string that I entered, I have this thus far: echo "name to change" read updatenaamold echo "enter new name:" ...
4
votes
2answers
826 views

concatenate cmd line starting from some parameter

If I get a cmd line like: myscript param1 param2 param3 param4 param5 param6 ... (so on) How can I save a string consisting of parameters starting from some specific one? The $@ gives me the whole ...
1
vote
3answers
5k views

How can I extract sub-strings using windows command-line?

For example say I have a file called testfile.txt that contains a list of file names of the following format: A svn\New Text Document.txt M svn\Table_tblVersion.xml Is there a command ...
0
votes
1answer
2k views

How to analyze strings on Applescript/mac

How would I write a script to analyze strings in Applescript (or other scripting program for mac)? Example: scan text file for "I love eating", copy subsequent text, end at ".", so that if my file ...
4
votes
3answers
4k views

How to use grep to match domain names?

I have a list of urls like: hxxp://url.com/subpage.html hxxp://www.url2.com/index.php hxxp://subdomain.url3.com/somepage.php ... How can I use grep to match the domain names only? All the urls ...
0
votes
2answers
733 views

What the best program for string manipulation [closed]

I would like to know the best program (Surely a text editor) to make string manipulation like string substituion. By the way, I would like to do the next: String manipulation of type String ...
5
votes
5answers
15k views

Excel Cell Length Limit

Excel is refusing to open some of the files I programmaticaly create. I think what is happening is that it pukes because a particular column has very long strings (up to 1850 chars), but for the ...
1
vote
1answer
427 views

Symbol which looks like . (dot) but is classified as letter in unicode

Iam writing my bachelor thesis at the moment. The problem for me is now the spellchecker (I use Open Office but this is a general problem) won't recognize .NET as a valid word. A also cannot add it to ...
3
votes
4answers
2k views

How to get the shortest string in a text file with shell

Assume I have a text file as below abcd aaaaaaa gfgk hahahahahahhahh gf Then gf would be returned.Any good ideas?
2
votes
2answers
820 views

Find more than one string with Excel?

How to Find more than one string with Microsoft Office Excel? For example, I am looking for the cells which is contained both strings Paul and John? How to avoid to perform several finds by ...
6
votes
3answers
33k views

Any Excel function that will reverse a string?

Are there any built-in Excel functions that will reverse a string?
13
votes
3answers
74k views

Excel: Replace occurences of one character with another in a String?

I want an excel formula that will change Haverford, PA to haverford,+pa. (Text is to lowercase, and spaces are replaced with plus characters.) The following will get the first space, but not all of ...