Automate

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

I think there is a padding rule in the rule wizard that you can use for controlling additional pre-post spaces. Otherwise, you'd have to JavaScript.

------------------------------
Joshua Whitener | Technical Advisor
Exxon Mobil Corporation | 8326258441
------------------------------

Original Message:
Sent: 04-10-2020 15:12
From: Scott Gorski
Subject: Composer or Web Service Trim

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

HI Scott

normalizeSpace() is my go to .  I just tried it and it got rid of leading and trailing spaces, as well as extra spaces in between.  I'm not sure what you mean about removing spaces in an address.
Before

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 04-10-2020 15:12
From: Scott Gorski
Subject: Composer or Web Service Trim

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

Original Message------

HI Scott

normalizeSpace() is my go to .  I just tried it and it got rid of leading and trailing spaces, as well as extra spaces in between.  I'm not sure what you mean about removing spaces in an address.
Before

After

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 04-10-2020 15:12
From: Scott Gorski
Subject: Composer or Web Service Trim

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

This is what I needed.  I should have tried the normalizeSpace option even though the description of the Function in Composer states "Removed whitespace from a text string".  I took it that it would remove all whitespace, not only extra ones.

Thanks All!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

Original Message:
Sent: 04-13-2020 09:40
From: sigrid kok
Subject: Composer or Web Service Trim

HI Scott

normalizeSpace() is my go to .  I just tried it and it got rid of leading and trailing spaces, as well as extra spaces in between.  I'm not sure what you mean about removing spaces in an address.
Before

After

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 04-10-2020 15:12
From: Scott Gorski
Subject: Composer or Web Service Trim

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------

Glad it can help, Scott! :)

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 04-14-2020 11:22
From: Scott Gorski
Subject: Composer or Web Service Trim

This is what I needed.  I should have tried the normalizeSpace option even though the description of the Function in Composer states "Removed whitespace from a text string".  I took it that it would remove all whitespace, not only extra ones.

Thanks All!

------------------------------
Scott Gorski
General Mills | Data Analyst

Original Message:
Sent: 04-13-2020 09:40
From: sigrid kok
Subject: Composer or Web Service Trim

HI Scott

normalizeSpace() is my go to .  I just tried it and it got rid of leading and trailing spaces, as well as extra spaces in between.  I'm not sure what you mean about removing spaces in an address.
Before

After

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 04-10-2020 15:12
From: Scott Gorski
Subject: Composer or Web Service Trim

Hello All!

Has anyone been able to do the equivalent to Excel's TRIM (removing spaces before, after and double spaces) in a Composer solution? I hope I am just overlooking the obvious.

I tried the following:
- Composer Field Formula - add Trim in a formula for a field [example = trim($form.getValue('/my:myFields/my:field_1'))] - results - no change to the field on the form
- Script Formula - Since the script is an XML, there is no option to include a transform rule

I saw the option of normalizeSpace in the Composer function options, but I do not want to remove single spaces in the middle of text (like an home address).

Any help would be appreciated!

Thanks!

------------------------------
Scott Gorski
General Mills | Data Analyst
------------------------------