Forum Discussion
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...
So, generally you use FIND or SEARCH to locate a keyword and then feed this information into RIGHT, MID, or LEFT to extract the information that you want.
This paragarph is present in a single row and i have 7K line item named with block4 column.
So can you suggest me that what formula should i use to find my text and extarct the string.
where my string place is not fixed.
regards,
Satish