Forum Discussion

Helper V

8 years ago

how to fetch string from paragraph

Hi All, I just want to know the to extract a string of series from a pragraph. for example: paragarph 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx AW:1345578299929909 date: 15-09-2017(line 2) xxxxx...

Anonymous

Not applicable

8 years ago

May be I am over simplifying your requirement.

But does something like this won't work?

New = SUBSTITUTE(Table2[String],"x","")

Helper V

8 years ago

AnonymousGreg_Deckler

Hi I am getting this error"An argument of function 'MID' has the wrong data type or has an invalid value."

while using MID function

.

Greg_Deckler
Community Champion
8 years ago
I think you need to read the documentation on these functions more closely.

SEARCH

https://msdn.microsoft.com/en-us/library/ee634235.aspx

You only need 2 parameters, the text to find and where to find it. The last two are optional, where to start (number) and what to return if not found.

MID

https://msdn.microsoft.com/en-us/library/ee634548.aspx

You need three parameters, the text you want to grab a string from, where to start and how many characters to get

So, let's say that you want to pull the phrase "DAX is fun" from some text but you don't know where it is located in the text of [Column4]. You would use something along the lines of:

Column = MID([Column4],SEARCH("DAX is fun",[Column4]),10)