Getting value out of get full text

Help
1

attached is the scrreen shot i want to get values that are in rectangle i have used get full text to get the entire data now how can i get that highighted data
Capture

2

if this is standard message you should try string manipulations

3

how many string manipulation should i use?

4

i think string manipulation will not be a good approach or is it?

5

If you use string manipulation you could extract the service required and the upgrade/downgrade date.
You just need to string manipulation, one for each item

6

can you tell me or send a workflow how to do that

7

Use the below code.

  • Get Full Text, Ouptut → String1
  • Assign ServiceReq = String1.substring(String1.Indexof(“Service Required”)+17),String1.Indexof(“Upgrade/Downgrade”)-1))
  • Assign UpgradeReq = String1.substring(String1.Indexof(“Upgrade/Downgrade”)+34),String1.Indexof(“Campaign Name”)-1))
8

hi vivek can you explain what is (+17 ) and (-1)what will they do and also +34

9

String1.Indexof(“Service Required”) will give you starting index of “Service Required”. So to ignore “Service Required”, we are adding +17. Same applies for +34.

10

i want to get the value after service request and upgrade /downgrade on date .will it give values after that “:” ?

11

Yes you are correct. It will values after semicolon(;).

12

thnx let me try ill get back to you then

13

it worked thanks

1 Like
14

Congrats. Please mark the solution as solved :slightly_smiling_face:

15

how you are counting 17 and 34 on which basis i am still confused

16

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.