Winshuttle Support systems have migrated into Precisely systems. If you weren't automatically forwarded to the new system, please go to https://support.precisely.com to access Suppport.

Forgot Transaction Script Password
Script runs ok, but debug stops at first screen.
Boolean error when creating a script
Is there a way to log out of Transaction, or sign in as a different user?
BDS document attachment is not supported for t-code
How to generate an Application Trace in Transaction
Loops are not working as expected in V12-Error Line item Not Found
Librfc.dll download steps
What authorizations are needed for Transaction
MM01: No batch input data for screen SAPLMGMM 0080/0070

How to remove Leading Zeros from Query Result Field

Fabian

January 28, 2020 13:37
Updated

Description

One of the Query data fields is returned with many leading zeros and the customer would like these zeros to be removed.

Applies to

Studio v.11x.

Solution

Create a transform using the formula =Value(cell).

Additional Information

Be sure to map the cell field (bottom left in image) to an unmapped cell in your script. The software will use this cell to convert the data.

Please note that as per current configuration and design, using Formula is only possible if the Data Type is Excel. Access as a Data Type is not supported.

Comments

0 comments

Please sign in to leave a comment.

# Notification banner writer

Articles in this section

Description

Applies to

Solution

Additional Information

Related articles