AnsweredAssumed Answered

What are the best practices for rewriting/reformatting addresses?

Question asked by JeffPihl1891 on Jan 14, 2014
Latest reply on Jan 14, 2014 by ted.sager
I am trying to shoe-horn addresses from NetSuite into our warehouses 940 requirements.

NetSuite fields: Attn, Addr1, Addr2, Addr3 (each of ? length)
Warehouse1 fields: addr1, addr2, addr3 (each of 30 chars max)
Warehouse2 fields: addr1, addr2 (each of ? length, my guess ~45 ,still waiting for WH tech to respond)

I'm assuming that I'll need to a create scripting function that imput the NS fields and output the warehoue fields. With likely a different function for each warehouse. Javascript string functions are certianly capable of  performing the changes to the text and I assume the functions may output longer strings so that the format validation will kick out the document and allow a manual adjustment of the address and reprocessing.

A) Does anyone have any address rewriting functions they'd care to share?
B) Any addressing gotchas I should be aware of?
C) Are there builtin tools or another approach I should consider?

Outcomes