How to trim fields for variables from emailbody

[callalilycek]

Hello,

I am trying to create variables to pull information from an event. The main issues I am having is how to trim the time zone field to only show Central Time, Eastern Time, etc rather than the whole answer after the "Time Zone:" field. I am not sure in my expression how to add the trim action.  (see screenshots below). The information looks somewhat like this:

***

Customer Info
--------------------
Name: CK
Email: anemail@gmail.com
Phone Number: 5555555555
Time Zone: (UTC-06:00) Central Time (US & Canada)

Booking Info
--------------------
Service name: Foundational Implementation Onboarding Introduction

Custom Fields
----------------------
Question 1- What is your Firm ID number?
Answer- 664139
Question 2- Any important notes for the Onboarding Representative?
Answer-

So far I have the expressions of:

Time Zone VAR named TimeZone2:

last(split(variables('EmailBody'), '<br>

Time Zone: '))

and then a second VAR named TimeZone with: 

first(split(variables('TimeZone2'), '<br'))

Below is a screenshot of what pulls with the timezone VAR, highlighted is what I want to eliminate. Its not always the same output since whats in first parentheses can differ for numbers based on time zone altho US & Canada is the most popular for second set of parentheses.

[v-qiaqi-msft]

Hi @callalilycek,

Do you want to only capture the Central Time, Eastern Time, etc?

If the ")" and "(" are fixed in your email body, I think you could try use them to split the variable:

first(split(last(split(first(split(variables('TimeZone2'), '<br')),')')),'('))

[callalilycek]

Yea, only the Central time, Eastern time, etc.. peice. And parentheses are always there, I was struggling to place them in the code correctly. I will test this one!

[callalilycek]

That did not work, it took out everything. I also tried this: first(split(last(split(first(split(variables('TimeZone2'), '<br')),'(')),')')) but that only gave me the US & Canada piece cutting out the rest of the information.

[v-qiaqi-msft]

Hi @callalilycek,

Oaky, you want to keep the content of the Booking Info as well, right?

If so, you just need to concat the Central time and the left Booking Info.

This part is for the Central time:

first(split(last(split(first(split(variables('TimeZone2'), '<br')),')')),'('))

And this part is for the following Booking Info:

last(split(last(split(first(split(variables('TimeZone2'), '<br')),')')),')'))

You could use the concat() to concatenate them:

concat(first(split(last(split(first(split(variables('TimeZone2'), '<br')),')')),'('))​,'<br>',last(split(last(split(first(split(variables('TimeZone2'), '<br')),')')),')')))

[callalilycek]

Those do not work as it says the expressions are invalid.

I think theres a misunderstanding of what im trying to do and probably my fault for badly explaining. I first need to have the flow pull the time zone information from the customer info. Then I want to trim it so it only pulls Central time, Eastern time, etc... Here is the current variable order and here are what the expressions are:

Time Zone VAR named TimeZone2:

last(split(variables('EmailBody'), '<br>

Time Zone: '))

and then a second VAR named TimeZone with: 

first(split(variables('TimeZone2'), '<br'))

This pulls the time zone field and the rest of the email body, and then the second variable cuts it to only be the part that says for example: (UTC-06:00) Central Time (US & Canada), and I want only the Central time, Eastern time, etc part to be pulled. Not sure if a trim action would do this, I just haven't figured out the right expression.

[v-qiaqi-msft]

Hi @callalilycek,

Sometimes a screenshot is better to describe.

Currently, you sait that my solution in the first reply only gave you the US & Canada piece cutting out the rest of the information, so I confirm with you that if you want to keep the content of the Booking Info as well.

Please tell me the answer based on the above question.

Further, do you want to delete the yellow part and keep the left content?

If so, I will show you how I achieve this in my scenario, note that I don't have <br> tag in my compose, I refer to it as plain.

last(split(outputs('Compose'), 'Time Zone: '))
first(split(last(split(outputs('Compose_2'),') ')),' ('))
last(split(last(split(outputs('Compose_2'),') ')),')'))
concat(outputs('Central_Time'),outputs('Info'))

[callalilycek]

Hello Qi,

Thanks for the follow up. The screenshots help and I think that is more than I need. I only want to pull the "Central time" or "Eastern time" etc. in total. The highlighted parts I do not want and I do not need the booking info after either for this variable. I just want the variable to pull the info from the time zone field and only the piece not highlighted in my screenshot. I think maybe I just need a trim action on one or both variables for my time zone field, just haven't got it to work correctly to eliminate the items in the parentheses. This is what I was attempting, and it allowed the expression, but it failed. My guess is I just don’t have the trim action correct with the parentheses.

TimeZone2 VAR:

trim(first(split(last(split(variables('EmailBody'),'Time Zone: '),') ')),' ('))

I also tried:

trim(first(split(last(split(variables('EmailBody'), 'Time Zone: ')),')('))

which gave all the info for the Time Zone field.

TimeZone VAR:

first(split(variables('TimeZone2'), '<br'))

[v-qiaqi-msft]

Hi @callalilycek,

Emm, I am confused😂 now.

If you only want to extract the time zone info, I think I have provided a solution already, doesn't it work?

first(split(last(split(variables('TimeZone'),')')),'('))

[callalilycek]

Hello @v-qiaqi-msft,

Yes I have had the variables set up to pull the time zone from the start, that was not the part I needed help with. I am trying to trim the results of the time zone field so it cuts out the parts after "Time Zone:" that are in parentheses, leaving only the "Central time" or "Eastern time" piece.  

[v-qiaqi-msft · Accepted solution]

Hi @callalilycek ,

This formula you wrote is wrong.

This is the correct one:

trim(first(split(last(split(last(split(variables('EmailBody'),'Time Zone: ')),') ')),' (')))

The last(split(variables('EmailBody'),'Time Zone: '))part meams the TimeZone variable in your scenario.

What's more, you could find out the expression you set for following variable, and add a Compose and write the following formula to get the info you need:

first(split(last(split(variables('TimeZone'),')')),'('))​

Using trim() or not depends on you.

[callalilycek · Accepted solution]

That one worked, thanks!