I am creating a GL integration that pulls from a csv file. The account number in the source file has an extra two zeros in the field. Is there a way to drop them off or to say left(myfield, 7)?
Thanks!
Ryan
*This post is locked for comments
[quote user="Ryan McBee"]
I am creating a GL integration that pulls from a csv file. The account number in the source file has an extra two zeros in the field. Is there a way to drop them off or to say left(myfield, 7)?
Thanks!
Ryan
[/quote]You can add the following script to your Account Number field:
CurrentField.Value = Left(SourceFields("sourceQueryName.YourField"), 7)
We are doing that now, but end users are complaining about the extra step:)
Ryan,
Why don't you do use Left function in Excel-CSV file thats easy / your CSV file must be in proper format before importing.
Thanks
Sandip
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156