Stack Overflow
Stack Overflow

Questions tagged [string-function]

String functions are used in computer programming languages to manipulate a string or query information about a string.

Examples are (this list is by no means exhaustive):

  • searching strings for characters or other strings;
  • extracting sub-strings or characters at a specific position;
  • replacing text within a string with some other text;
  • iterating over the characters in a string;
  • concatenating strings.

For more details, see the Wikipedia "String Functions" page.

SQL String functions

A string function is a function that takes a string value as an input regardless of the data type of the returned value. In database management systems, there are many built-in string functions that can be used by developers. As an example:

100 questions
0
votes
2 answers

Postgresql substring using regex

I need to run a postgresql query to get names from database but I need to sort these names alphabetically. The names that I am gettign from database are as follows: (123) Jone Lee (22) Hans Hee 2 Dean Alloni Alen Khan I need to output to be Alen…
Hani
  • 127
  • 1
  • 1
  • 6
0
votes
2 answers

Word split fails with more then 3 words

I try to split a string every + then every |, it works fine when I try to read only 3 words from the split words1(0-3), but when I try to read words1(4) the whole function fails... here is the code: Private Function SetUpdateData() Try …
TymeBomb
  • 117
  • 2
  • 12
0
votes
2 answers

How to remove $ symbol from a string

I am trying to format currency without the "$" in the beginning of the currency format. How would I do this? I've tried this but it doesn't work: Format(e.Row.Cells(7).Text, "{0:n}") I know that $1,234 is: Format(e.Row.Cells(7).Text,…
J doe
  • 1
  • 1
  • 1
0
votes
1 answer

PostgreSQL fetch a part of string

I am storing a log like this: 10.03.2015 11:45:29-JAQ -- Updated Following Information Mobile Updated From 0 to 0502770020
Company Industry Id Updated From 747 to 753
Name Updated from futurehomes to futurehomesdubai
Company Head…
Pradeep.T.P
  • 133
  • 1
  • 1
  • 6
-1
votes
1 answer

Filtering and searching for strings by array_filter() function

I have a list of people's names and ages. Through function array_filter(), I can filter people who are over 40 years old, which returns the correct answer But if I want to put a filter for the names of people, this issue does not work properly…
arseni44
  • 3
  • 2
-1
votes
1 answer

how to highlight the data I need in qlik sense

I have address data. The address data is separated by commas and I need to display the city corresponding to this address in the next column on the sheet. The city itself is indicated in the address. Tell me how to select this city from the address,…
skrtsway
  • 19
  • 7
-1
votes
1 answer

How can I check if a Substring is a quotation

I want to make a if where it checks if a Substring is a ". Like here: char comma = '"' if(String.Substring(6, 1) == comma) But this doesnt doesn't work and it gives me this error Error CS0019 The == operator cannot be used on operands of the type…
Tobias Schober
  • 21
  • 2
-1
votes
3 answers

Runtime error in functions of python (list , string confusion in practice problem)

I have been trying to solve a particular question in my own amateur way from the Python 3 Bootcamp on Udemy. So far, there is an error, I guess, in the append() line of my python code. Here I have provided you with the question and the answer to be…
Yashiikkaa
  • 1
  • 1
-1
votes
2 answers

There is a find function....Is there an "opposite of find" function?

I want to know if you can find a letter by entering the position of it so it gives you the letter back. In other words, I want a function that is the opposite of the find function? P.S. if myString is a string and I input the position of the letter…
Dave Brown
  • 31
  • 4
-1
votes
2 answers

I need to get a portion from a string between two phrase, regex solutions would be great

I have string from which I need to get sub-string between a start and end phrases. Below is my string and start and end phrase. MY STRING Consolation Prize- Rs. 8,000/- NN 189822 NO 189822 NP 189822 NR 189822 NS 189822 NU 189822 NV 189822 NW…
Arun
  • 3
  • 4
-1
votes
3 answers

Php convert string into array for group?

I have group on string i want to explode by group and sub group For…
viralchampanery
  • 397
  • 1
  • 7
  • 16
-1
votes
1 answer

C++ How to use string::functions on smartpointer

In order to avoid unnecessary variables, is there a way to make int var = sharedPtrStringVar.length(); and other funtions of String work with smart pointers? Until now I`ve been copying the string from the pointer into a temp var but isn't there a…
Nerrock
  • 3
  • 2
-1
votes
2 answers

String function "CharAt" storing and displaying numeric values in "char"

Ok guys so i'm using this string function "charAT" to store charater variable to store in char r. But we know user can input anything. When user enters a numeric value like 123 or 5 or anything charAt is storing that in char variable r. Exception…
Tarunjeet Singh Salh
  • 194
  • 2
  • 12
-1
votes
1 answer

How to validate both lowercase and uppercase input?

I have a winform application and I was wondering what is the c# code to validate both lowercase and uppercase input for string search comparison.Thank you.
Dominique1256
  • 85
  • 1
  • 9
-2
votes
1 answer

If input is: Jane Silly Doe Output is: Doe, J.S. If input is: Julia Clark Output is: Clark, J. Issue: I can make it run for either or but not both

If input is: Jane Silly Doe Output is: Doe, J.S. If input is: Julia Clark Output is: Clark, J. Issue: I can make it run for either or but not both This only works for input Jane Silly Doe but not for input Julia Clark. I can make it run for either…
Dlal529
  • 13
  • 2
1 2 3 4 5
6
7