Integration Manager Question

(0) Share

Report

Posted on by Ryan D 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

*This post is locked for comments

All responses (3)

Answers (0)

Sort by

sandipdjadhav 18,377 on at

Like (0)

Report
Copy link

Link copied!

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
Ryan D McBee on at

Like (0)

Report
Copy link

Link copied!

We are doing that now, but end users are complaining about the extra step:)
MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

[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)