Split field data at space into two fields

[beverlybishop]

NetSuite transaction Listener to FTP XML file.

I need to separate the house number from the street in the Address1 field. Essentially, everything left of the first space creates one field and everything right of the first space creates another field.

Is this possible?

[tylerlamparter]

@beverlybishop here you go!

//option to get everything after first space
{{regexMatch street "(?<=\s).*" 0}}

//two options to get characters before first space
{{regexMatch street "([^\s]+)" 0}}
{{split street " " 0}}

I'm also curious to see what @steveklett comes up with.

[beverlybishop]

Thanks, @tylerlamparter! I'm probably doing something wrong here. I get the same error for both regexMatch options and the split returns blank.

[tylerlamparter]

@beverlybishop in my sample, street is my field name. You would need to modify that for your data. In this case it would be data.0.street.

//option to get everything after first space
{{regexMatch data.0.street "(?<=\s).*" 0}}

//two options to get characters before first space
{{regexMatch data.0.street "([^\s]+)" 0}}
{{split data.0.street " " 0}}