Trying to get the address in a location record from a IF (we use line level on IF but header on SO). I was able to do it with a lookupFields

var locationFields = search.lookupFields({

type: search.Type.LOCATION,

id: createdFrom,

columns: ['address.address']

});

but the results come back like this

"address.address": "xxxxxx\r\xxxxxx xxxx Ave\r\nChicago IL xxxxx\r\nUnited States"

That's what gets set in the custom field. How do I just get the address part and not the whole string?

Why would createdFrom be a location? Isn't that usually for transactions?

Ya but I want the whole address not to break it apart

Search columns is what's available. https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2022_2/script/record/address.html

To clarify this is on transaction.

Oh that makes sense. I was confused.

Ya so on my Invoice which has line level location, I want to pull the SO header level location address

Addresses are subrecords, usually subrecords on a sublist line. It doesn't matter when you perform a search, but if you want only address1, 2, and 3 or similar, you either need to get the individual fields and format them yourself or do some string manipulation to remove the city, state, etc.

right but I want the whole block

Use string concatenation or or extract a substring.