Integration Manager Question

(0) Share

Report

Posted on by Ryan D McBee

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

All responses (3)

Answers (0)

Mariano Gomez 26,225 on at

Like (0)

Report

Re: Integration Manager Question

[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)
Ryan D McBee 1,440 on at

Like (0)

Report

Re: Re: Integration Manager Question

We are doing that now, but end users are complaining about the extra step:)
sandipdjadhav 18,265 on at

Like (0)

Report

Re: Integration Manager Question

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