How to remove strings before nth character in a text?

how to remove text before or after a specific character in excel?
how to remove part of text in a cell in excel
remove specific character from string excel
excel remove everything after last slash
how to remove characters from a string
how to remove text before or after a specific character in excel vba
remove unwanted characters in excel
how to delete text only in excel

I have a dynamically generated text like this

xxxxxx-xxxx-xxxxx-xxxxx-Map-B-844-0

How can I remove everything before Map ...? I know there is a hard coded way to do this by using substring() but as I said these strings are dynamic and before Map .. can change so I need to do this dynamically by removing everything before 4th index of - character.

You could remove all four minuses and the characters between from start of the string.

var string = 'xxxxxx-xxxx-xxxxx-xxxxx-Map-B-844-0',
    stripped = string.replace(/^([^-]*-){4}/, '');
    
console.log(stripped);

How to remove texts before or after a specific character from cells in , How do I get rid of text before or after a character in Word? For removing all texts before or after a specific character with the Find and Replace function, please do as follows. 1. Select the cells you will remove texts before or after a specific character, press Ctrl + H keys to open the Find and Replace dialog.

I would just find the index of Map and use it to slice the string:

let str = "xxxxxx-xxxx-xxxxx-xxxxx-Map-B-844-0"
let ind = str.indexOf("Map")
console.log(str.slice(ind))

How to delete string after nth character in Excel?, , press Ctrl + H keys to open the Find and Replace dialog. Remove string in specific position by Remove by Position . If you have Kutools for Excel, you can use the Remove by Position to quickly remove strings after nth character, and also can specify how many characters you will remove.

I would just split on the word Map and take the first index

var splitUp = 'xxxxxx-xxxx-xxxxx-xxxxx-Map-B-844-0'.split('Map') var firstPart = splitUp[0]

How to remove text before the first match of a specific character in , How do I remove a string after the nth character in Excel? =FIND(“#”,SUBSTITUTE(B1,”,”,”#”,2))-1. You have got the within_text from the above SUBSTITUTE function and the FIND function will return the position of the first occurrence of the hash character in within_text string. Then subtract 1 to get the position before the second occurrence of the comma character in text.

Uses String.replace with regex expression should be the popular solution.

Based on the OP states: so I need to do this dynamically by removing everything before 4th index of - character.,

I think another solution is split('-') first, then join the strings after 4th -.

let test = 'xxxxxx-xxxx-xxxxx-xxxxx-Map-B-844-0'
console.log(test.split('-').slice(4).join('-'))

Excel formula: Remove text by position, If you want to extract text after the second or nth comma character in a text string in Cell B1, you need firstly to get the position of the second or nth  To extract text before a special character, you need to find the location of the special character in the text, then use Left Function. Formula: Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.

Introduction to stringr, Method C: Delete texts before or after the nth occurrence character by formula. Method D: Remove texts before/after a specific character with Kutools for Excel  string outcome here-are-some-words-to-try some a-b-c-d-e-f-g-h-i f Here are a few references I've tried using: Find third occurrence of a special character and drop everything before that in R. regex - return all before the second occurrence

MID - Docs Editors Help, You can use below formula to remove all string after nth character. formulas, charts and anything that you have used before; Encrypt Cells with password;  Method 1: Remove first or last x characters from text strings with formulas Remove first x characters from the beginning of the text strings: In Excel, you can use the RIGHT and LEFT functions to remove the certain number of characters from the beginning or the end of the strings, please do as this: 1. Type or copy the following formula in a blank cell C4 where you want to put the result:

Python: Remove the nth index character from a nonempty string , For replacement, we use an empty string ("") which causes REPLACE to replace characters 1-24 with nothing. Alternative with SUBSTITUTE. Since the text in this​  How do I remove part of a string? For example in ATGAS_1121 I want to remove everything before _. Use regular expressions. In this case, you can use gsub: This regular expression matches the beginning of the string (^), any character (.) repeated zero or more times (*), and underscore (_). The ? makes the match "lazy" so that it only matches

Comments
  • Are you trying to remove everything before the last occurrence of Map?
  • What if xxxxxx-xxxx-xxxxx-xxxxx contains Map keyword??
  • That's a fair point if that's a possibility. @Sphinx. I read remove everything before Map ... to indicate that it's not a possibility.
  • @planet_hunter then use lastIndexOf. But we don't know from the OP's description which one is desired
  • You're probably right @Sphinx I added a regex alternative.