Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper 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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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. 

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
8 years ago

I

 

 

 

I am not able to put search function on the column block4

  • Satish_Kumar's avatar
    Satish_Kumar
    Icon for Helper V rankHelper V
    8 years ago
    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)

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx loan Amount:22292 USD(line 10)

xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxx

 

 

 

paragarph 2:

 

 

xxxxxxxxxxxxxxxx AW:1334499929909 date: 25-09-2017(line 3)

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx loan Amount:21192 USD(line7)

xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

 

 

So i have to extract these string from a paragarph where there exitance in paragraph is not fixed.

they might be present any where in the paragarph.

 

So, please help me out of this problem.................

 

 

Regards,

Satish