I am trying to extract the last name of a attendance report for sorting it alphabetically by last name. The attendance report (should be an .cvs) looks like this: (Tab was extracted for the post, so here: I open it via fgetcsv and find the word between space and a tab: Output looks like this: Testme Left I do…
Tag: regex
How to split a string at a specific character but not replace that character?
I want to split at every ‘;’ and every ‘{‘ from the string below: It splits at the point of every ‘;’ and ‘{‘ but these characters are also removed which I don’t want. I used explode() function though it splits, but also replace that character. And how to …
Regular expression to display >quotes in style
There’s some text in my db with quotes in it. In their raw form they look like this: What I wanted to do is make those quotes look somewhat distinctive from other text – either in php part before they go to the database or when they’re displayed on the page (doesn’t matter much to me, …
How to perform multiple search using php regex?
Hi, Can anyone tell me how can I perform multiple searches? For example, if the “designer” keyword not found, then search for “created by” and so on Answer You can use That is, use preg_match_all to match multiple occurrences and merge the two alternatives into a simpler (?:Created by|…
How to match or replace a pattern of two appearances of one statement in RegEx? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed last year. Improve this question I have a text like bellow: Ryan, Ryan needs to find his papers. I want to ch…
Using preg_replace to reformat money amounts in text with PHP
I’m struggling with some regular expressions. What I want to do is find money amounts in a string, remove the €,$, or £ but keep the number, and then look to see if there is a ‘b’ or an ‘m’ – in which …
Regex to match a string that contains substrings separated with dots
I need to get a value from an array using the dot notation. For example: So what I need to do is check if it’s a valid string by which we could get a value from array. Constraints: non-whitespace characters only contains at least one dot cannot start or end with a dot every dot must have a non-dot subst…
String to Multi-Dimensional array in PHP
Imagine that I have a variable that contains following value: I want to parse this string and create actual multi-dimensional array in PHP. For example: For that purpose, first of all I tried to parse that string via regular expression: However I failed when I tried it as following: And the output is: So; How…
Split VAT into segments based on Country code
What is the best wat to split any VAT number into segments? First part is the country code, is always 2 alphanumeric. Second is the remaining number. For example: NL820471616B01 should be split to NL and 820471616B01 BE0824148721 should be split to BE and 0824148721 ATU12345678 should be split to AT and U1234…
Replace all urls with minified urls within a string containing mixed content
I have string with links and iam going to extract links into an array as following results Now i will use bit.ly API function gobitly() for link shorten that ends with array like this the results of $links[] Now I want to rebuild the string and replace links to the new one to be like this Answer Since you kno…