change value format for data load

[gino2780]

Hello,

let's assume we have two tables and we want to join them via one key field (field1).

But, the value format of the key field in both tables is different:

How can i change the value format of e.g. fieldA (0000000000) of table1

into the value format of field1 (00-000-0000/0) of table2 (master)?

Greets,

G.A.

[sunny_talwar · Accepted solution]

May be like this:

Left(fieldA, 2) & '-'&Mid(fieldA, 3, 3)& '-' & Mid(fieldA, 6, 4) & '/' & Right(fieldA, 1)

[rupamjyotidas]

Maybe

Autonumber(keepchar(field1,'00' ) ) as FieldA

Autonumber(FieldA) as FieldA

[gino2780]

As always Sunny, works perfectly fine.

Thanks a lot