question

AdrianoRocha-2012 avatar image
0 Votes"
AdrianoRocha-2012 asked

get each line for a textbox multiline separately

Hello guys!

I have a textbox multiline(true) and i need get the informations separately, like:
this is what ill paste every day, every time:

"
• Order Id 10786xxx:
Pickup Time: 2021-07-01 10:41:00
Pick-up: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Deliver: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
MEMO: Nursing Station: None | Location Type: ROOFTOP|Patient: BEVERLY GREENE | Notes: COURIER THURSDAY BY 4-5PM"

the field order id i have to get only the numbers, 8 on total
i dont need the field "Pickup Time"
the field pickup always will have different size, but i need get only after the word "Pick-up:" no matter how many characters
the field delivery always will have different size, but i need get only after the word "Delivery:" no matter how many characters
the field MEMO always will have different size, but i need get only after the word "MEMO:" no matter how many characters

so at the end will be like:
text1 = order id
text 2 = pickup location
text3 = deliver location
text4 = memo

can somebody help me how to do that?

office-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers