Skip to main content
  • EN

Hello, I have a full StreetAddress field and separate City/State/Zip fields. I want to parse Street only out from the StreetAddress field. I used AttributeCreator, Left() and FindString(). Please see below. Most records were correctly parsed out except for few ones like the second record in the table below. Is there a way for FindString() to return the last occurrence of a string? or any other ways for this purpose?

@Left(@Value(StreetAddress),@FindString(@Value(StreetAddress), @Value(City)) + 1)

 

StreetAddressCityStateZip1 Google Way Mountain View, CA 12345Mountain ViewCA12345

 

1 Houston Road Houston, TX 23456HoustonTX23456

Just basing this off what you have shown here, so not sure what all your data looks like.

Why don't you stringconcatenate: (this would be what it looks like in the bottom window) start off with a space ), @Value(CA) @Value(Zip).

Now you could just use the attribute created in the stringreplacer and replace on the streetaddress, replace with a blank.

This will avoid the issue you are having with a single attribute like Houston, not being unique in the entire string.

thanks. StringContatenator works.

Reply


Community Stats

30,126
Posts
114,351
Replies
37,758
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.