Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
41 views

Get part of script run directory in bash

I'm running a Bash script that's buried in a directory on my system. I need to be able to get the first section of the directory path. The path returned by $0 in my script is as below. The ...
2
votes
2answers
317 views

function to automatically remove special characters from file names during saving in MacOS X

I'm often creating PDF files from web pages in MacOS X (10.6) and very often I have the problem that the automatically proposed file name (based on the name of the web page) contains many special ...
0
votes
1answer
46 views

What SQL can be used to extract a first and last name from a mixture of name fields

Name field can be a mixture of formats, for example: Mr. First Last, Mr First Last, First M Last, First M. Last, First Last Snr, First M Last Snr, First Last-Last, etc.
0
votes
2answers
74 views

VI make every first letter that comes after a underscore uppercase

Found this site: http://unix.t-a-y-l-o-r.com/VMswitch.html And it works for the first character but my lines are line this this_is_a_string And I would like this This_Is_A_String Any ...
1
vote
4answers
108 views

How to extract two numbers from two strings and calculate the difference in Bash?

I have a text file which contains (among others) the following lines: {chapter}{{1}Einleitung}{27}{chapter.1} {chapter}{{2}Grundlagen}{35}{chapter.2} How can I get the 2 lines from this text ...
1
vote
1answer
38 views

Tool to manipulate text in web form fields?

I'm looking for a way to manipulate text in form fields. For example, if I have a large textarea "body" field, from my browser I want to be able to highlight a piece of text in that textarea, for ...
1
vote
2answers
139 views

Shell: Find and replace word

I have a string in my shell script which is in a fixed format : '[STATUS REPORT] PROJECT'. When user executes my shell script he will be asked to provide a value for 'PROJECT'. I would like to ...
0
votes
1answer
216 views

How can I format a text field in Microsoft Access Report Designer?

I have a field (a string) that looks like this: '0000000840509001' when printed on my report. I want it to look like this: '84-05-090.01'. Is there any way to do this at the report design level? ...
1
vote
1answer
145 views

Delete all occurences of any word matching a partial string in sed

Assume that I have the following line: group blue:green yellow green redtomblue black !greyTOMwhilte !purple redblue I need to delete from it all words that contain the string "tom" or "TOM" using ...
0
votes
2answers
715 views

Extract emails from gmail

I have a website with a contact form. Once the user fills in the form, an email is being sent to my gmail in the following syntax: From: Contact us form <contact-us-form@example.com> ...
2
votes
1answer
429 views

Reverse Name order in Notepad++

I have a load of names in a file in the format Lastname, Firstname: Williams, Hywel Williams, Mark  Williams, Roger Williams, Stephen ... Is there a simple way of reversing them in ...
0
votes
2answers
1k views

How to extract part of a string, in Windows batch file?

If I have a variable in a batch (cmd) file that looks like "Abc_123", and I want to end up with a variable that has just "123", is there any built-in way to do this? I'm not terribly picky about the ...
1
vote
2answers
629 views

How to convert a single line of Hex numbers into a multi-row Excel table?

I'm currently at some hex strings in a video game's data files. The structure is: XX 01 YY YY (then repeats) Where: XX is the item's cost 01 is unknown (it won't matter) YY YY is the item's ID. ...
0
votes
2answers
249 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 ...
1
vote
2answers
152 views

String manipulation of type String substitution in mathematical expression

Imagine something like exp(49/200)+(x-49/200) I want to pass as argument of the function "roundn" whatever operation that is not a addtion or a subtraction So my expresion became ...
1
vote
1answer
374 views

Replace cell formatting with text in Excel?

I received an Excel document that has data that looks like the following: A B C ========================================= 1 |F:\folderName | | | 2 ...
1
vote
3answers
288 views

How Do I Parse a String?

I am new to bash, and I am creating a script that loops through the files in a directory and based on part of the filename, does something with the file, so far I have this: #!/bin/bash ...
2
votes
3answers
4k views

Any Excel function that will reverse a string?

Are there any built-in Excel functions that will reverse a string?
2
votes
4answers
519 views

How do I do a string replace in all PHP files recursively on Linux?

I have a function name that was misspelled, and I want to change it. The function is called in many places of the project. How can I do this with a Linux command on SUSE?
0
votes
2answers
160 views

Excel string extract

I have a string in a cell: ABCDxxxxxEFGH ABCD and EFGH are constant, xxxxx is of variable length. I want to write an excel formula to extract xxxxx.