1,440
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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
