Forum Discussion

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

    Greg_Deckler

     

    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

  • Satish_Kumar's avatar
    Satish_Kumar
    Helper V
    8 years ago

    I

     

     

     

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

    • Satish_Kumar's avatar
      Satish_Kumar
      Helper 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