You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-04 23:26:59

quinnj105
Guest

quinnj105 said:

String Functions or Parsing Data

Is there a quick way to parse a set of numbers and place in two new columns?  I have US a column of US postal codes -- 9 total digits.  The left 5 digits are standard zip code.  The last four digits are the + 4 postal code...the combined set are commonly referred to as zip+4.

#2 2017-04-05 18:29:34

gvaznunes
Talend Team


gvaznunes said:

Re: String Functions or Parsing Data

Hi,

Use the function "Extract parts of text" twice:

  1. From beginning to index 5

  2. From index 5 to the end

You will have your 2 new columns respectively with the first 5 digits and the 4 last ones.

Regards,

Gwendal

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy