Small and medium business | Business Central, N...

Trimming text on Payment Export file

(0) Share

Report

Posted on by James De Filippo

Thanks to the community for resolving the previous post!

I have another issue, whereas the text length is restricted to 18 characters but some text will exceed this limit. I want to be able to trim the text, in this scnerio.

Please advise if there is any way to overcome this issue.

File Type: Variable Text

Data Type: Text

Length: 18

Im wondering if i can do this by way of a Data Format?

I have the same question (0)

All responses (9)

Answers (0)

Dallefeld 211 User Group Leader on at

Like (0)

Report

In the data exchange definition. you enter the length of the field for the export file.

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Kim,

Thanks for your response.

We do in fact have a length specified as 18, but the actual field value in this instance is 30. If this was a fixed text file type, then it would automatically trim the value but as this is a variable text it doesn't appear to be doing that.

Please advise.

Thanks

James

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

Oh I see, does it have to be variable? Could you change to fixed text?

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Kim,

Thanks for getting back to me.

We have found that using Fixed Text, if the value length is below the length specified in the data exchange definition it will cause an error.

Please advise, any help on this would be appreciated.

Regards,

James

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Please ask your partner to raise this as an issue to Microsoft support. Looks like something that needs hot fixing.

Thanks.

Was this reply helpful? Yes No
Vaishnavi J 3,062 on at

Like (0)

Report

Hi James,

Can you use the CopyStr function?

Which will copy the value until that number of characters is reached before exporting your file.

CopyStr(Rec PaymentJnlLine L1."Document No.", 1, 15) as an example

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Vaishnavi,

Where would i specify this function, using a Data Exchange Definition? would it be the Data Format in the column definitions or field mapping under the line definitions.

Thanks

James

Was this reply helpful? Yes No
Vaishnavi J 3,062 on at

Like (0)

Report

Hi James,

You can write your own export logic and then use the COPYSTR function to trim the data.

Here's a link to a blog where you can export data as a text file.

www.cloudfronts.com/.../

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (1)

Report

Hi Vaishnavi,

Although i do appreciate your reply, i was hoping to use the standard data exchange definitions to achieve this result. There are many features in the payment journal that support it and would like to retain this where possible.

Many thanks,

James

Was this reply helpful? Yes No